/// <summary>
/// 获取考勤資料
/// </summary>
/// <param name=></param>
/// <returns></returns>
public List <MODEL.KQ_Section> SeeKQSection(string groupno)
{
string sql = @"
select * from KQ_Section
where GroupNo=@GroupNo
ORDER BY No
";
SqlParameter[] ps =
{
new SqlParameter("@GroupNo", groupno)
};
DataTable dt = SqlHelper.ExcuteTable(sql, ps);
List <MODEL.KQ_Section> lists = null;
if (dt.Rows.Count > 0)
{
lists = new List <MODEL.KQ_Section>();
foreach (DataRow row in dt.Rows)
{
MODEL.KQ_Section c = new MODEL.KQ_Section();
LoadDataToList2(row, c);
lists.Add(c);
}
}
return(lists);
}
/// <summary>
/// 加载行数据到对象--集合
/// </summary>
/// <param name="dr"></param>
/// <param name="classes"></param>
public void LoadDataToList2(DataRow dr, MODEL.KQ_Section kqs)
{
kqs.No = (int)SqlHelper.FromDbValue(dr["No"]);
kqs.GroupNo = (string)SqlHelper.FromDbValue(dr["GroupNo"]);
kqs.Section = (string)SqlHelper.FromDbValue(dr["Section"]);
kqs.DayF = (string)SqlHelper.FromDbValue(dr["DayF"]);
kqs.HourF = (int)SqlHelper.FromDbValue(dr["HourF"]);
kqs.MinF = (int)SqlHelper.FromDbValue(dr["MinF"]);
kqs.DayT = (string)SqlHelper.FromDbValue(dr["DayT"]);
kqs.HourT = (int)SqlHelper.FromDbValue(dr["HourT"]);
kqs.MinT = (int)SqlHelper.FromDbValue(dr["MinT"]);
kqs.HourFSTD = (int)SqlHelper.FromDbValue(dr["HourFSTD"]);
kqs.MinFSTD = (int)SqlHelper.FromDbValue(dr["MinFSTD"]);
kqs.HourTSTD = (int)SqlHelper.FromDbValue(dr["HourTSTD"]);
kqs.MinTSTD = (int)SqlHelper.FromDbValue(dr["MinTSTD"]);
}