dFormat(" AND IO.INS_OPDEPID = {0}", m_insOperate.INS_OPDEPID);
}
//编辑人
if (!string.IsNullOrEmpty(m_insOperate.INS_OPUSERID))
{
sql.AppendFormat(" AND IO.INS_OPUSERID IN ( select USERID from USERINFO where USERNAME like '%{0}%' )", m_insOperate.INS_OPUSERID);
}
//是否审核
//if (!string.IsNullOrEmpty(m_insOperate.INS_ISAUDIT.ToString()))
//{
// sql.AppendFormat(" AND IO.INS_ISAUDIT = '{0}'", m_insOperate.INS_ISAUDIT);
//}
//编辑时间
//if (m_insOperate.INS_OPDATE.ToShortDateString() != "0001-1-1")
//{
// sql.AppendFormat(" AND IO.INS_OPDATE BETWEEN TIMESTAMP('{0}') AND TIMESTAMP('{1}')", m_insOperate.INS_OPDATE, m_insOperate.INS_OPDATE.AddDays(1));
//}
}
try
{
#region 插入数据参数列表
DB2Parameter[] parameters = {
new DB2Parameter("p_TableName", DB2Type.VarChar,500),
new DB2Parameter("p_NickName", DB2Type.VarChar,200),
new DB2Parameter("p_IDName", DB2Type.VarChar,200),
new DB2Parameter("p_PageIndex", DB2Type.Integer),
new DB2Parameter("p_PageSize", DB2Type.Integer),
new DB2Parameter("p_Strwhere", DB2Type.VarChar,8000),
new DB2Parameter("p_count", DB2Type.Integer)
};
parameters[0].Value = "INSTITUTIONALINFO II,INS_OPERATE IO";
parameters[1].Value = "II.*,IO.*";
parameters[2].Value = "II.INS_ID";
parameters[3].Value = pageIndex;
parameters[4].Value = pageSize;
parameters[5].Value = sql.ToString();
parameters[0].Direction = ParameterDirection.Input;
parameters[1].Direction = ParameterDirection.Input;
parameters[2].Direction = ParameterDirection.Input;
parameters[3].Direction = ParameterDirection.Input;
parameters[4].Direction = ParameterDirection.Input;
parameters[5].Direction = ParameterDirection.Input;
parameters[6].Direction = ParameterDirection.Output;
#endregion
this.IDataBase.FillDataSet("P_GETPAGEDATANEW", parameters, result.Value as CUTEntityINSOPerate);
result.Success = true;
count = CDataConvert.ConToValue(parameters[6].Value);
result.CurrOperateType = EOperateType.Seach;
}
catch (Exception ex)
{
result.Success = false;
result.ErrorInformation = ex.Message;
result.CurrOperateType = EOperateType.Error;
count = 0;
}
}
摘自 C#ASP.NET程序员
|