public DataTable GetHrRightApply(string clientJsonQuery)
{
DataTable dt = new DataTable();
dt.TableName = "HrRightApply";
dt.Columns.Add(new DataColumn("phid", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("rowno", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("checkstate", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("billno", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("billname", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("fillpsnid", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("fillpsnname", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("filldate", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("ischeck", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("checkpsn", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("checkdate", Type.GetType("System.String")));
dt.Columns.Add(new DataColumn("remark", Type.GetType("System.String")));
//获取下属员工Userid,拼成字符串列表，并加上当前用户
DataTable underHrUseridDt = dac.GetUnderHrUserid();
List <string> users = new List <string>();
for (int i = 0; i < underHrUseridDt.Rows.Count; i++)
{
users.Add(underHrUseridDt.Rows[i]["phid"].ToString());
}
users.Add(NG3.AppInfoBase.UserID.ToString());
DataTable hrRightApplyDt = dac.GetQueryHrRightApplyDt(clientJsonQuery);
int rowno = 1;
for (int i = 0; i < hrRightApplyDt.Rows.Count; i++)
{
string fillpsnid = hrRightApplyDt.Rows[i]["fillpsnid"].ToString();
if (!users.Contains(fillpsnid))
{
continue;
}
DataRow dr = dt.NewRow();
dr["phid"] = hrRightApplyDt.Rows[i]["phid"];
dr["rowno"] = rowno;
rowno++;
dr["checkstate"] = hrRightApplyDt.Rows[i]["checkstate"];
dr["ischeck"] = hrRightApplyDt.Rows[i]["ischeck"];
dr["billno"] = hrRightApplyDt.Rows[i]["billno"];
dr["billname"] = hrRightApplyDt.Rows[i]["billname"];
dr["fillpsnid"] = fillpsnid;
dr["fillpsnname"] = hrRightApplyDt.Rows[i]["fillpsnname"].ToString();
string filldate = hrRightApplyDt.Rows[i]["filldate"].ToString();
if (!string.IsNullOrEmpty(filldate))
{
filldate = filldate.Substring(0, filldate.IndexOf(" "));
filldate = filldate.Replace("/", "-");
dr["filldate"] = filldate;
}
dr["checkpsn"] = hrRightApplyDt.Rows[i]["checkpsn"].ToString();
string checkdate = hrRightApplyDt.Rows[i]["checkdate"].ToString();
if (!string.IsNullOrEmpty(checkdate))
{
checkdate = checkdate.Substring(0, checkdate.IndexOf(" "));
checkdate = checkdate.Replace("/", "-");
dr["checkdate"] = checkdate;
}
dr["remark"] = hrRightApplyDt.Rows[i]["remark"];
dt.Rows.Add(dr);
}
return(dt);
}