private void LoadData()
{
//初始化符合条件的数据列表
string Name = this.txtUserName.Text.Trim();
try
{
RmsPM.DAL.QueryStrategy.UserStrategyBuilder USB = new RmsPM.DAL.QueryStrategy.UserStrategyBuilder();
if (Name.Length > 0)
{
USB.AddStrategy(new Strategy(RmsPM.DAL.QueryStrategy.UserStrategyName.UserName, "%" + Name + "%"));
}
string Sql = USB.BuildMainQueryString();
QueryAgent QA = new QueryAgent();
EntityData ds = QA.FillEntityData("SystemUser", Sql);
QA.Dispose();
this.dgPersonList.DataSource = new DataView(ds.CurrentTable);
this.dgPersonList.DataBind();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "加载人员列表失败");
}
}
private void LoadData()
{
//初始化符合条件的数据列表
string unitCode = Request["UnitCode"] + "";
string stationCode = Request["StationCode"] + "";
try
{
EntityData entity;
if (unitCode == "NoStationUser")
{
//所有未定岗的人员
entity = BLL.SystemRule.GetUsersNoStation();
}
else
{
//取部门下的所有用户（包括子部门）
RmsPM.DAL.QueryStrategy.UserStrategyBuilder USB = new RmsPM.DAL.QueryStrategy.UserStrategyBuilder();
if (stationCode != "")
{
USB.AddStrategy(new Strategy(RmsPM.DAL.QueryStrategy.UserStrategyName.StationCode, stationCode));
}
else if (unitCode != "")
{
USB.AddStrategy(new Strategy(RmsPM.DAL.QueryStrategy.UserStrategyName.UnitCodeEx, unitCode));
}
string s = USB.BuildMainQueryString();
s = s + USB.GetDefaultOrder();
QueryAgent QA = new QueryAgent();
entity = QA.FillEntityData("SystemUser", s);
QA.Dispose();
}
entity.Dispose();
this.dgList.DataSource = entity.CurrentTable;
this.dgList.DataBind();
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "加载人员列表失败");
}
}
private DataTable DisposeTask(System.Data.DataTable dtTask)
{
try
{
DataTable dtNew = dtTask.Copy();
dtNew.Columns.Add("StatusName");
dtNew.Columns.Add("ImportantName");
dtNew.Columns.Add("Master");
string[] strStatusList = { "未开始", "进行中", "暂停", "取消", "已完成" };
string[] strImportantList = { "一般", "重要" };
for (int i = 0; i < dtNew.Rows.Count; i++)
{
dtNew.Rows[i]["StatusName"] = (dtNew.Rows[i]["Status"] == System.DBNull.Value)?"":strStatusList[int.Parse(dtNew.Rows[i]["Status"].ToString())];
dtNew.Rows[i]["ImportantName"] = (dtNew.Rows[i]["ImportantLevel"] == System.DBNull.Value)?"":strImportantList[int.Parse(dtNew.Rows[i]["ImportantLevel"].ToString())];
DAL.QueryStrategy.UserStrategyBuilder USB = new RmsPM.DAL.QueryStrategy.UserStrategyBuilder();
USB.AddStrategy(new Strategy(DAL.QueryStrategy.UserStrategyName.WBSCode, dtNew.Rows[i]["WBSCode"].ToString()));
QueryAgent QA = new QueryAgent();
string sql = USB.BuildMainQueryString();
DataSet ds = QA.ExecSqlForDataSet(sql);
if (ds.Tables[0].Rows.Count > 0)
{
dtNew.Rows[i]["Master"] = ds.Tables[0].Rows[0]["UserName"];
}
else
{
dtNew.Rows[i]["Master"] = "";
}
QA.Dispose();
}
return(dtNew);
}
catch (Exception ex)
{
ApplicationLog.WriteLog(this.ToString(), ex, "");
return(null);
}
}
