public List <UserHelpUserModel> GetUserHelpUserList(string SortColumns, int StartRecord, int MaxRecords, int CodeEqual, int GroupCodeEqual, string UserCodeEqual, DateTime AddDateEqual)
{
List <UserHelpUserModel> models = new List <UserHelpUserModel>();
UserHelpUserQueryModel objQueryModel = new UserHelpUserQueryModel();
objQueryModel.StartRecord = StartRecord;
objQueryModel.MaxRecords = MaxRecords;
objQueryModel.SortColumns = SortColumns;
objQueryModel.CodeEqual = CodeEqual;
objQueryModel.GroupCodeEqual = GroupCodeEqual;
objQueryModel.UserCodeEqual = UserCodeEqual;
objQueryModel.AddDateEqual = AddDateEqual;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
models = new UserHelpUserBLL().GetModels(objQueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
private List <UserHelpUserModel> _Select(UserHelpUserQueryModel qmObj)
{
List <UserHelpUserModel> list = new List <UserHelpUserModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from UserHelpUser ");
builder.Append(qmObj.QueryConditionStr);
if (qmObj.SortColumns.Length == 0)
{
builder.Append(" ORDER BY Code desc");
}
else
{
builder.Append(" ORDER BY " + qmObj.SortColumns);
}
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.SqlParameters = qmObj.Parameters;
SqlDataReader sqlDataReader = null;
int num = 0;
try
{
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1)))
{
UserHelpUserModel model = new UserHelpUserModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
private void LoadData()
{
string groupCode = Request["GroupCode"];
try
{
DataTable dt = new DataTable();
dt.Columns.Add("RelationCode");
dt.Columns.Add("AccessRangeType");
dt.Columns.Add("ImageFileName");
dt.Columns.Add("Name");
if (!string.IsNullOrEmpty(groupCode))
{
UserHelpUserQueryModel queryModel = new UserHelpUserQueryModel();
queryModel.GroupCodeEqual = int.Parse(groupCode);
RmsOA.BFL.UserHelpUserBFL bfl = new RmsOA.BFL.UserHelpUserBFL();
List <UserHelpUserModel> listModel = bfl.GetUserHelpUserList(queryModel);
if (listModel != null)
{
foreach (UserHelpUserModel model in listModel)
{
DataRow drNew = dt.NewRow();
drNew["RelationCode"] = model.UserCode;
drNew["Name"] = RmsPM.BLL.SystemRule.GetUserName(model.UserCode);
drNew["AccessRangeType"] = 0;
drNew["ImageFileName"] = "user.gif";
dt.Rows.Add(drNew);
}
}
}
this.repeaterSU.DataSource = dt;
this.repeaterSU.DataBind();
dt.Dispose();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "加载人员列表失败");
}
}
public List <UserHelpUserModel> GetUserHelpUserList(UserHelpUserQueryModel QueryModel)
{
List <UserHelpUserModel> models = new List <UserHelpUserModel>();
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
try
{
if (QueryModel == null)
{
QueryModel = new UserHelpUserQueryModel();
}
models = new UserHelpUserBLL().GetModels(QueryModel, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
}
return(models);
}
public List <UserHelpUserModel> GetModels(UserHelpUserQueryModel ObjQueryModel, SqlTransaction Transaction)
{
UserHelpUserDAL rdal = new UserHelpUserDAL(Transaction);
return(rdal.Select(ObjQueryModel));
}
public List <UserHelpUserModel> Select(UserHelpUserQueryModel qmObj)
{
return(this._Select(qmObj));
}
public List <UserHelpUserModel> Select()
{
UserHelpUserQueryModel qmObj = new UserHelpUserQueryModel();
return(this._Select(qmObj));
}
