public static DataTable GetTable(string optrType)
{
var dt = HrPersonnelFile.Find(CK.K["Status"] == "在职" && CK.K["OptrType"] == optrType).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 = "在职状态";
return(dt);
}
public static List <HrPersonnelFile> GetDistributor(string optrType)
{
HrPersonnelFile md = HrPersonnelFile.New;
md.Id = 0;
md.Name = "";
List <HrPersonnelFile> hrPersonnelFiles = HrPersonnelFile.Find(CK.K["OptrType"] == optrType && (CK.K["WorkShop"] == "测试区" || CK.K["WorkShop"] == "部门") && CK.K["Status"] == "在职" && (CK.K["Position"] == "主管工程师" || CK.K["Position"] == "操作工" || CK.K["Position"] == "组长" || CK.K["Position"] == "技术员" || CK.K["Position"] == "工程师"), "Position");
hrPersonnelFiles.Insert(0, md);
return(hrPersonnelFiles);
}
public static List <HrPersonnelFile> GetOperatorByWorkShop(string optrType, string workShop)
{
HrPersonnelFile md = HrPersonnelFile.New;
md.Id = 0;
md.Name = "";
List <HrPersonnelFile> hrPersonnelFiles = HrPersonnelFile.Find(CK.K["OptrType"] == optrType && CK.K["WorkShop"] == workShop && CK.K["Status"] == "在职" && (CK.K["Position"] == "操作工" || CK.K["Position"] == "组长"));
hrPersonnelFiles.Insert(0, md);
return(hrPersonnelFiles);
}
public static List <HrPersonnelFile> GetRepairMonitorByWorkShop(string optrType, string workshop)
{
HrPersonnelFile md = HrPersonnelFile.New;
md.Id = 0;
md.Name = "";
List <HrPersonnelFile> hrPersonnelFiles =
HrPersonnelFile.Find(CK.K["OptrType"] == optrType && (CK.K["WorkShop"] == workshop || CK.K["WorkShop"] == "部门") &&
CK.K["Status"] == "在职" &&
CK.K["Position"] == "维修班长", "Position");
hrPersonnelFiles.Insert(0, md);
return(hrPersonnelFiles);
}
protected override void Saving()
{
if (IsAdd)
{
var obj = HrPersonnelFile.New;
FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1);
obj.OptrType = UserStatics.OptrType;
obj.Save();
}
else
{
var obj = HrPersonnelFile.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindControlsToObject(obj, tabPage1);
obj.OptrType = UserStatics.OptrType;
obj.Save();
}
}
public static List <HrPersonnelFile> GetWhoRepair(string optrType)
{
if (optrType == "Test")
{
HrPersonnelFile md = HrPersonnelFile.New;
md.Id = 0;
md.Name = "";
List <HrPersonnelFile> hrPersonnelFiles =
HrPersonnelFile.Find(CK.K["OptrType"] == optrType && CK.K["WorkShop"] == "测试区" &&
CK.K["Status"] == "在职" &&
(CK.K["Position"] == "主管工程师" || CK.K["Position"] == "工程师" ||
CK.K["Position"] == "维修员" || CK.K["Position"] == "技术员" || CK.K["Position"] == "维修班长"));
hrPersonnelFiles.Insert(0, md);
return(hrPersonnelFiles);
}
return(null);
}
protected override void Loading()
{
ctSex.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "性别");
ctSex.DisplayMember = "Name";
ctMarries.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "婚姻状况");
ctMarries.DisplayMember = "Name";
ctPoliticalBackground.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "政治面貌");
ctPoliticalBackground.DisplayMember = "Name";
ctWorkShop.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "车间");
ctWorkShop.DisplayMember = "Name";
ctProcess.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "工序");
ctProcess.DisplayMember = "Name";
ctPosition.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "职务");
ctPosition.DisplayMember = "Name";
ctProfessionalTitle.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "职称");
ctProfessionalTitle.DisplayMember = "Name";
ctWageGrade.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "工资级别");
ctWageGrade.DisplayMember = "Name";
ctHighestEducation.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "学历");
ctHighestEducation.DisplayMember = "Name";
ctStatus.DataSource = CommonStatics.GetDict(UserStatics.OptrType, "在职状态");
ctStatus.DisplayMember = "Name";
if (!IsAdd)
{
var obj = HrPersonnelFile.FindById(long.Parse(ItemID));
FrmAddEditBindComboBoxText.BindObjectToControls(obj, tabPage1);
}
else
{
ctBirthday.Value = DateTime.Now.Date;
ctDateEmployed.Value = DateTime.Now.Date;
}
}
public static List <HrPersonnelFile> GetRepairMonitor(string optrType)
{
if (optrType == "Test")
{
HrPersonnelFile md = HrPersonnelFile.New;
md.Id = 0;
md.Name = "";
List <HrPersonnelFile> hrPersonnelFiles =
HrPersonnelFile.Find(CK.K["OptrType"] == optrType && (CK.K["WorkShop"] == "测试区" || CK.K["WorkShop"] == "部门") &&
CK.K["Status"] == "在职" &&
CK.K["Position"] == "维修班长", "Position");
hrPersonnelFiles.Insert(0, md);
return(hrPersonnelFiles);
}
else
{
return(null);
}
}
public static List <HrPersonnelFile> GetWhoHandledByWorkShop(string optrType, string workshop)
{
if (optrType == "Test")
{
HrPersonnelFile md = HrPersonnelFile.New;
md.Id = 0;
md.Name = "";
List <HrPersonnelFile> hrPersonnelFiles =
HrPersonnelFile.Find(CK.K["OptrType"] == optrType && CK.K["WorkShop"] == workshop &&
CK.K["Status"] == "在职" &&
CK.K["Position"] == "组长");
hrPersonnelFiles.Insert(0, md);
return(hrPersonnelFiles);
}
else
{
return(null);
}
}
/// <summary>
/// 按Optrtype和WorkShop获得报修人
/// </summary>
/// <param name="optrType">用户类型</param>
/// <param name="workshop">工作区</param>
/// <returns></returns>
public static List <HrPersonnelFile> GetWhoNoticeByProcess(string optrType, string workshop)
{
HrPersonnelFile md = HrPersonnelFile.New;
md.Id = 0;
md.Name = "";
List <HrPersonnelFile> hrPersonnelFiles = HrPersonnelFile.Find(
CK.K["OptrType"] == optrType &&
(CK.K["WorkShop"] == workshop || CK.K["WorkShop"] == "部门") &&
CK.K["Status"] == "在职" &&
(CK.K["Position"] == "主管工程师" ||
CK.K["Position"] == "维修班长" ||
CK.K["Position"] == "操作工" ||
CK.K["Position"] == "组长" ||
CK.K["Position"] == "技术员" ||
CK.K["Position"] == "工程师"), "Position");
hrPersonnelFiles.Insert(0, md);
return(hrPersonnelFiles);
}
public static void DelCell(long id)
{
HrPersonnelFile.DeleteAll(CK.K["Id"] == id);
}
