public ArrayList GetDeptSchDetail(string strDeptName, string strShcID)
{
DataSet dsout = Ea.GetDeptSchDetail(strDeptName, strShcID);
ArrayList alDeptSch = new ArrayList();
if (dsout != null)
{
DataTable dtSch = dsout.Tables["SchDetail"];
DataTable dtStruct = dsout.Tables["Struct"];
for (int i = 0; i < dtStruct.Rows.Count; i++)
{
CMSMStruct.DeptSchStruct deptsch = new CommCenter.CMSMStruct.DeptSchStruct();
deptsch.strEmpOF = dtStruct.Rows[i]["vcEmpOF"].ToString();
deptsch.strClass = dtStruct.Rows[i]["vcClass"].ToString();
deptsch.strCheckIn = dtStruct.Rows[i]["dtCheckIn"].ToString();
deptsch.strCheckOut = dtStruct.Rows[i]["dtCheckOut"].ToString();
alDeptSch.Add(deptsch);
}
foreach (CMSMStruct.DeptSchStruct deptstmp in alDeptSch)
{
for (int j = 0; j < dtSch.Rows.Count; j++)
{
if (dtSch.Rows[j]["vcEmpOF"].ToString() == deptstmp.strEmpOF && dtSch.Rows[j]["vcClass"].ToString() == deptstmp.strClass && dtSch.Rows[j]["dtCheckIn"].ToString() == deptstmp.strCheckIn && dtSch.Rows[j]["dtCheckOut"].ToString() == deptstmp.strCheckOut)
{
if (deptstmp.strSIOTID == null || deptstmp.strSIOTID == "")
{
deptstmp.strSIOTID = dtSch.Rows[j]["vcSchID"].ToString();
deptstmp.strDeptName = dtSch.Rows[j]["vcDeptName"].ToString();
deptstmp.strManager = dtSch.Rows[j]["vcManager"].ToString();
// deptstmp.strCheckIn=dtSch.Rows[j]["dtCheckIn"].ToString();
// deptstmp.strCheckOut=dtSch.Rows[j]["dtCheckOut"].ToString();
}
if (deptstmp.strEmpNameGroup == null || deptstmp.strEmpNameGroup == "")
{
deptstmp.strEmpNameGroup += dtSch.Rows[j]["vcEmpName"].ToString();
}
else
{
deptstmp.strEmpNameGroup += "，" + dtSch.Rows[j]["vcEmpName"].ToString();
}
}
}
}
foreach (CMSMStruct.DeptSchStruct deptstmp in alDeptSch)
{
if (deptstmp.strEmpNameGroup == null || deptstmp.strEmpNameGroup == "")
{
deptstmp.strEmpNameGroup = "未安排";
}
}
}
return(alDeptSch);
}
public ArrayList GetDeptSchDetail(string strDeptName, string strShcID)
{
DataTable dtout = Ea.GetDeptSchDetail(strDeptName, strShcID);
ArrayList alDeptSch = new ArrayList();
if (dtout != null)
{
string strkeyLast = dtout.Rows[0]["vcEmpOF"].ToString() + dtout.Rows[0]["vcClass"].ToString() + dtout.Rows[0]["dtCheckIn"].ToString() + dtout.Rows[0]["dtCheckOut"].ToString();
string strkey = "";
CMSMStruct.DeptSchStruct deptsch = new CommCenter.CMSMStruct.DeptSchStruct();
deptsch.strEmpOF = dtout.Rows[0]["vcEmpOF"].ToString();
deptsch.strClass = dtout.Rows[0]["vcClass"].ToString();
deptsch.strEmpNameGroup = dtout.Rows[0]["vcEmpName"].ToString();
deptsch.strCheckIn = dtout.Rows[0]["dtCheckIn"].ToString();
deptsch.strCheckOut = dtout.Rows[0]["dtCheckOut"].ToString();
alDeptSch.Add(deptsch);
for (int i = 1; i < dtout.Rows.Count; i++)
{
strkey = dtout.Rows[i]["vcEmpOF"].ToString() + dtout.Rows[i]["vcClass"].ToString() + dtout.Rows[i]["dtCheckIn"].ToString() + dtout.Rows[i]["dtCheckOut"].ToString();
if (strkey == strkeyLast)
{
deptsch.strEmpNameGroup += "，" + dtout.Rows[i]["vcEmpName"].ToString();
}
else
{
deptsch = new CommCenter.CMSMStruct.DeptSchStruct();
deptsch.strEmpOF = dtout.Rows[i]["vcEmpOF"].ToString();
deptsch.strClass = dtout.Rows[i]["vcClass"].ToString();
deptsch.strEmpNameGroup = dtout.Rows[i]["vcEmpName"].ToString();
deptsch.strCheckIn = dtout.Rows[i]["dtCheckIn"].ToString();
deptsch.strCheckOut = dtout.Rows[i]["dtCheckOut"].ToString();
alDeptSch.Add(deptsch);
strkeyLast = dtout.Rows[i]["vcEmpOF"].ToString() + dtout.Rows[i]["vcClass"].ToString() + dtout.Rows[i]["dtCheckIn"].ToString() + dtout.Rows[i]["dtCheckOut"].ToString();
}
}
foreach (CMSMStruct.DeptSchStruct deptstmp in alDeptSch)
{
if (deptstmp.strEmpNameGroup == null || deptstmp.strEmpNameGroup == "")
{
deptstmp.strEmpNameGroup = "未安排";
}
}
}
return(alDeptSch);
}
