/// <summary>
/// 获取考勤資料
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.KQ_Data> CheckKQData(string timefrom, string timeto)
{
string sql = @"
select a.Guid,KQtime,a.EnrollNo,Machine,b.EmpID,b.AID,TimeNO,b.KhName from KQ_Data a
left join(select * from HR_Employee)b on a.EnrollNo=b.EnrollNo
where KQTime>@KQTimefrom and KQTime<@KQTimeto
and (b.EmpID is null or b.AID is null)
ORDER BY AID,EmpID,KQTime
";
SqlParameter[] ps =
{
new SqlParameter("@KQTimefrom", timefrom),
new SqlParameter("@KQTimeto", timeto)
};
DataTable dt = SqlHelper.ExcuteTable(sql, ps);
List <MODEL.KQ_Data> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.KQ_Data>();
foreach (DataRow row in dt.Rows)
{
MODEL.KQ_Data c = new MODEL.KQ_Data();
LoadDataToList1(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
/// 获取考勤資料
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.KQ_Data> SeeKQDataEmpID(string kqdate)
{
string sql = @"
select AID,EmpID from KQ_Data where KQDate=@KQDate Group by AID,EmpID order by AID,EmpID
";
SqlParameter[] ps =
{
new SqlParameter("@KQDate", kqdate)
};
DataTable dt = SqlHelper.ExcuteTable(sql, ps);
List <MODEL.KQ_Data> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.KQ_Data>();
foreach (DataRow row in dt.Rows)
{
MODEL.KQ_Data c = new MODEL.KQ_Data();
LoadDataToList3(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
/// 获取考勤資料
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.KQ_Data> SeeKQDataByID(string empid, string kqdate)
{
string sql = @"
select * from KQ_Data where EmpID=@EmpID and KQDate=@KQDate order by KQTime desc
";
SqlParameter[] ps =
{
new SqlParameter("@EmpID", empid),
new SqlParameter("@KQDate", kqdate)
};
DataTable dt = SqlHelper.ExcuteTable(sql, ps);
List <MODEL.KQ_Data> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.KQ_Data>();
foreach (DataRow row in dt.Rows)
{
MODEL.KQ_Data c = new MODEL.KQ_Data();
LoadDataToList1(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList1(DataRow dr, MODEL.KQ_Data kqdata)
{
kqdata.Guid = (Guid)SqlHelper.FromDbValue(dr["Guid"]);
kqdata.KQTime = (DateTime?)SqlHelper.FromDbValue(dr["KQTime"]);
kqdata.EnrollNo = (int?)SqlHelper.FromDbValue(dr["EnrollNo"]);
kqdata.Machine = (string)SqlHelper.FromDbValue(dr["Machine"]);
kqdata.EmpID = (string)SqlHelper.FromDbValue(dr["EmpID"]);
kqdata.AID = (decimal?)Convert.ToDecimal(SqlHelper.FromDbValue(dr["AID"]));
kqdata.TimeNO = (string)SqlHelper.FromDbValue(dr["TimeNO"]);
kqdata.KhName = (string)SqlHelper.FromDbValue(dr["KhName"]);
kqdata.KQDate = (string)SqlHelper.FromDbValue(dr["KQDate"]);
}
/// <summary>
/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList3(DataRow dr, MODEL.KQ_Data kqdata)
{
kqdata.EmpID = (string)SqlHelper.FromDbValue(dr["EmpID"]);
kqdata.AID = (decimal?)Convert.ToDecimal(SqlHelper.FromDbValue(dr["AID"]));
}
