HR_Train_Course GetCourseInfo()
{
HR_Train_Course temp = new HR_Train_Course();
HR_Train_AssessType assess = new HR_Train_AssessType();
assess.AssessTypeName = cmbAssess.Text;
assess = _ServiceBasicInfo.GetSingleInfo_AssessType(assess);
HR_Train_CourseType courseType = new HR_Train_CourseType();
courseType.CourseTypeName = cmbType.Text;
courseType = _ServiceBasicInfo.GetSingleInfo_CourseType(courseType);
temp.AssessID = assess.ID;
temp.ClassHour = numClassHour.Value;
temp.CourseName = txtCourseName.Text;
temp.Fund = numFund.Value;
if (txtCourseName.Tag != null)
{
temp.ID = Convert.ToInt32(txtCourseName.Tag);
}
temp.IsOutSide = chbIsOutSide.Checked;
temp.Lecturer = txtLecturer.Text;
temp.TypeID = courseType.ID;
temp.Department = BasicInfo.DeptCode;
return(temp);
}
public void Operation_CourseType(HR_Train_CourseType obj)
{
try
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
HR_Train_CourseType temp = new HR_Train_CourseType();
var varData = from a in ctx.HR_Train_CourseType
where a.ID == obj.ID
select a;
if (varData.Count() == 0)
{
if (obj.ID == 0)
{
var varkk = from a in ctx.HR_Train_CourseType
where a.CourseTypeName == obj.CourseTypeName
select a;
if (varkk.Count() > 0)
{
throw new Exception("【名称】：" + obj.CourseTypeName + " 重复");
}
}
ctx.HR_Train_CourseType.InsertOnSubmit(obj);
}
else if (varData.Count() == 1)
{
if (obj.CourseTypeName == null)
{
ctx.HR_Train_CourseType.DeleteOnSubmit(varData.Single());
}
else
{
temp = varData.Single();
temp.CourseTypeName = obj.CourseTypeName;
}
}
else
{
throw new Exception("记录数不唯一");
}
ctx.SubmitChanges();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void btn_CourseType_Add_Click(object sender, EventArgs e)
{
try
{
HR_Train_CourseType temp = new HR_Train_CourseType();
temp.CourseTypeName = txtCourseType.Text;
_ServiceBasicInfo.Operation_CourseType(temp);
MessageDialog.ShowPromptMessage("添加成功");
RefreshGrid_CourseType();
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
public HR_Train_CourseType GetSingleInfo_CourseType(HR_Train_CourseType info)
{
DepotManagementDataContext ctx = CommentParameter.DepotDataContext;
var varData = from a in ctx.HR_Train_CourseType
where a.ID == info.ID || a.CourseTypeName == info.CourseTypeName
select a;
if (varData.Count() == 1)
{
return(varData.Single());
}
else
{
return(null);
}
}
private void btn_CourseType_Delete_Click(object sender, EventArgs e)
{
try
{
if (txtCourseType.Tag == null)
{
MessageDialog.ShowPromptMessage("请选择需要删除的记录");
return;
}
HR_Train_CourseType temp = new HR_Train_CourseType();
temp.ID = Convert.ToInt32(txtCourseType.Tag);
_ServiceBasicInfo.Operation_CourseType(temp);
MessageDialog.ShowPromptMessage("删除成功");
RefreshGrid_CourseType();
}
catch (Exception ex)
{
MessageDialog.ShowPromptMessage(ex.Message);
}
}
