public static DataTable GetOneWeek(string optrType)
{
DateTime now = DateTime.Now;
DateTime d1 = now.AddDays(-8);
var dt = AttendanceRate.Find(CK.K["OptrType"] == optrType && CK.K["InputDate"] > d1, "InputDate desc").ToDataTable();
dt.Columns[1].ColumnName = "日期";
dt.Columns[2].ColumnName = "区域";
dt.Columns[3].ColumnName = "组长";
dt.Columns[4].ColumnName = "管理人员";
dt.Columns[5].ColumnName = "技术人员";
dt.Columns[6].ColumnName = "辅助人员";
dt.Columns[7].ColumnName = "大功率操作工";
dt.Columns[8].ColumnName = "小功率操作工";
dt.Columns[9].ColumnName = "新工";
dt.Columns[10].ColumnName = "缺勤";
dt.Columns[11].ColumnName = "大功率测试产量";
dt.Columns[12].ColumnName = "小功率测试产量";
dt.Columns[13].ColumnName = "小功率打印产量";
dt.Columns[14].ColumnName = "编带产量";
dt.Columns[15].ColumnName = "包装全检产量";
dt.Columns[16].ColumnName = "包装合批产量";
dt.Columns[17].ColumnName = "大功率交库";
dt.Columns[18].ColumnName = "大功率委托";
dt.Columns[19].ColumnName = "中功率交库";
dt.Columns[20].ColumnName = "中功率委托";
dt.Columns[21].ColumnName = "小功率交库";
dt.Columns[22].ColumnName = "小功率委托";
dt.Columns[23].ColumnName = "异常用人";
dt.Columns[24].ColumnName = "异常原因";
dt.Columns[25].ColumnName = "备注";
dt.Columns[26].ColumnName = "用户类型";
return(dt);
}
protected override void Saving()
{
if (IsAdd)
{
var obj = AttendanceRate.New;
BindControlsDecimal.BindControlsToObject(obj, tabPage1);
obj.OptrType = UserStatics.OptrType;
obj.Save();
}
else if (IsAdd == false)
{
var obj = AttendanceRate.FindById(long.Parse(ItemID));
BindControlsDecimal.BindControlsToObject(obj, tabPage1);
obj.Save();
}
}
protected override void Loading()
{
ctDistrict.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "区域");
ctDistrict.DisplayMember = "Name";
ctGroupMonitor.DataSource = BllAttendanceRate.GetGroupMonitorByWorkShop(UserStatics.OptrType, UserStatics.WorkShop);
ctGroupMonitor.DisplayMember = "Name";
if (!IsAdd)
{
var obj = AttendanceRate.FindById(long.Parse(ItemID));
BindControlsDecimal.BindObjectToControls(obj, tabPage1);
ReSetNumbericUpDownStatus();
}
else
{
ctInputDate.Value = UserStatics.GetSqlServerDateTime();
}
}
public static void DelCell(long id)
{
AttendanceRate.DeleteAll(CK.K["Id"] == id);
}
