/// <summary>
/// 检查是否重复
/// </summary>
/// <param name="Model.Department"></param>
/// <returns></returns>
public static bool CheckRepeat(Model.Department model)
{
try
{
string sql = "select * from Department where Name = @Name and Id <> @Id";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Name", model.Name.Trim()),
new SqlParameter("@Id", model.Id)
};
DataTable temp = DBHelper.ExecuteGetDataTable(CommandType.Text, sql, para);
if (temp.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
ErrorLog e = new ErrorLog();
e.TargetIds = model.Id.ToString();
e.CodeTag = "CheckRepeat";
e.LogName = "检查是否重复-ForDepartment";
e.ErrorMsg = ex.Message.ToString();
ErrorLogService.AddErrorLog <Model.Department>(e, model);
return(true);
}
}
private void button1_Click(object sender, EventArgs e)
{
Model.Department depID = new Model.Department();
deleteDep.DepartmentName = deptName;
depID.DepartmentName = deptName;
Employee numEmp = new Employee();
numEmp.DepartmentId = dtc.GetDepartmentID(depID);
if (dtc.GetEmpNumInDep(numEmp) > 0)
{
Employee removeEmp = new Employee();
Employee intoEmp = new Employee();
removeEmp.DepartmentId = dtc.GetDepartmentID(depID);
depID.DepartmentName = cbDepartment.Text;
intoEmp.DepartmentId = dtc.GetDepartmentID(depID);
dtc.RemoveEmp(removeEmp, intoEmp);
}
dtc.DeleteDep(deleteDep);
Model.SystemEvent addEvent = new SystemEvent();
addEvent.EventDate = DateTime.Now.ToShortDateString();
addEvent.EventDescription = "删除成功";
dtc.AddEvent(addEvent);
MessageBox.Show("删除成功！");
Close();
}
public Model.Department Select(Model.Department Dep)
{
try
{
SqlCommand cmd = new SqlCommand("Select * From [FAMIS].[dbo].[Department] Where Department_id =" + Dep.Department_id, db.Db());
SqlDataReader dr = cmd.ExecuteReader();
Model.Department Department;
Department = new Model.Department();
while (dr.Read())
{
if (!dr.IsDBNull(0))
{
Department.Department_id = dr.GetInt32(0);
}
if (!dr.IsDBNull(1))
{
Department.Name = dr.GetString(1);
}
}
return Department;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// Get one Department
/// </summary>
/// <param name="DepID"></param>
/// <returns></returns>
public Department getDeptByID(string DepID)
{
Department dept = new Department();
dept = (from c in ctx.Department
where c.DeptID == DepID
select c).First();
return dept;
}
public void DeleteDep(Department deleteDep)
{
var delete = (from d in hrContext.Department
where d.DepartmentName == deleteDep.DepartmentName
select d).Single();
hrContext.Department.DeleteOnSubmit(delete);
hrContext.SubmitChanges();
}
public void LOAD()
{
btnSetManger.Enabled = false;
Model.Department depID = new Model.Department();
Employee getDepEmp = new Employee();
depID.DepartmentName = departName;
getDepEmp.DepartmentId= dtc.GetDepartmentID(depID);
dgvDepartment.DataSource = dtc.GetDepEmp(getDepEmp);
lblEmployeeNumber.Text = dtc.GetDepEmp(getDepEmp).Count().ToString();
lblDepartmentName.Text = departName;
}
private bool tryPut(ref Model.Department model, out string errMsg)
{
errMsg = "";
bool re = false;
model.Modifier = this.auth.UserId;
model.ModifiedDate = DateTime.Now;
if (DepartmentManager.ModifyDepartmentById(ref model, out errMsg))
{
re = true;
}
return(re);
}
/// <summary>
/// update department information
/// </summary>
/// <param name="d"></param>
public bool updateDept(Department d)
{
bool result = true;
var dept = (from c in ctx.Department
where d.DeptID == c.DeptID
select c).First();
dept.Contact = d.Contact;
dept.Phone = d.Phone;
dept.Fax = d.Fax;
dept.CPID = d.CPID;
dept.DeptName = d.DeptName;
dept.DeptHead = d.DeptHead;
dept.DeptRep = d.DeptRep;
Employee deptRepOld = ctx.Employee.Where(x => x.RoleID == "DR").FirstOrDefault();
if(deptRepOld.EmpID != d.DeptRep)
{
deptRepOld.RoleID = "EM";
Employee deptRepNew = ctx.Employee.Where(x => x.EmpID == d.DeptRep).FirstOrDefault();
deptRepNew.RoleID = "DR";
}
try
{
ctx.SaveChanges();
}
catch
{
result = false;
}
//send notification to alert changes:
if (result == true)
{
Department dpt = ctx.Department.Where(x => x.DeptID == d.DeptID).FirstOrDefault();
if(d.DeptRep != dpt.DeptRep)
{
NotificationController nt = new NotificationController();
nt.sendNotification(12, Convert.ToInt32(dpt.DeptRep), dpt.DeptID);
}
if (d.CollectionPoint != dpt.CollectionPoint)
{
NotificationController nt = new NotificationController();
nt.sendNotification(13, Convert.ToInt32(dpt.DeptRep), dpt.DeptID);
}
}
return result;
}
private void btnOK_Click(object sender, EventArgs e)
{
Model.Department addDep = new Model.Department();
Model.SystemEvent addEvent = new SystemEvent();
dtc.name = txtDepartmentName.Text.Trim();
dtc.description = txtDepartmentDescription.Text.Trim();
dtc.Add(addDep);
addEvent.EventDescription = "添加部门成功！";
addEvent.EventDate = DateTime.Now.ToShortDateString();
dtc.AddEvent(addEvent);
MessageBox.Show("添加部门成功！", "消息：",MessageBoxButtons.OK );
txtDepartmentName.Clear();
txtDepartmentName.Focus();
}
private void AddEmployeeForm_Load(object sender, EventArgs e)
{
cbDepartment.DataSource = dtc.getDepName();//获取部门列表
//初始化控件
label12.Visible = false;
btnNewEmployee.Enabled = false;
lblWarning.Visible = false;
lblWarningSame.Visible = false;
Department getDeptName = new Department();
if (isAddEmployee == false)//若为修改模式
{
picEmp.EmployeeId = employeeID;//获取该ID所拥有的图片
getEmp.EmployeeId = employeeID;//获取该ID的信息
Name = "修改员工";//窗体改名
btnNewEmployee.Text = "修改";//控件改名
if (dtc.GetPic(picEmp) == null) { picPhoto.Image = null; }//如果该员工没有存在就不显示图片
else {
Stream stream = new MemoryStream(dtc.GetPic(picEmp).ToArray());//从数据库中读出二进制数值转化为数组并加载到内存流里
Bitmap img = (Bitmap)Image.FromStream(stream, false);//读取流中的数据并据此画出图像
picPhoto.Image = img;//显示图片
imageByte = dtc.GetPic(picEmp).ToArray();//获取二进制数组
foreach (Model.Employee g in dtc.GetEmp(getEmp))//将该员工的部分数据显示
{
txtName.Text = g.EmployeeName;
name = txtLoginName.Text = g.EmployeeLoginName;
txtEmail.Text = g.EmployeeEmail;
txtPassword.Text = g.EmployeePassword;
getDeptName.DepartmentId = (int)g.DepartmentId;
cbDepartment.Text = dtc.GetDeptName(getDeptName);
txtBaseSalary.Text = g.EmployeeBasicMoney.ToString();
txtPosition.Text = g.EmployeePostName;
txtPhone.Text = g.EmployeePhone;
numLevel.Text = g.Employee_Level_.ToString();
}
}
}
else
{
//清空文本框
txtName.Clear();
txtLoginName.Clear();
txtEmail.Clear();
txtPassword.Clear();
txtBaseSalary.Clear();
txtPosition.Clear();
txtPhone.Clear();
}
}
/// <summary>
/// 添加部门
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddDepartment(ref Model.Department model, out string errMsg)
{
errMsg = "";
try
{
model.Name = model.Name.Trim();
model.Description = model.Description.Trim();
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Name", model.Name),
new SqlParameter("@Description", model.Description),
new SqlParameter("@Creater", model.Creater),
new SqlParameter("@CreatedDate", model.CreatedDate),
new SqlParameter("@Modifier", model.Modifier),
new SqlParameter("@ModifiedDate", model.ModifiedDate),
new SqlParameter("@return", SqlDbType.Int)
};
para[6].Direction = ParameterDirection.ReturnValue;
int i = DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, "proc_DepartmentInsert", para);
if (i > 0)
{
model.Id = int.Parse(para[6].Value.ToString());
EventLog e = new EventLog();
e.TargetIds = para[6].Value.ToString();
e.CodeTag = "AddDepartment";
e.LogName = "添加部门";
EventLogService.AddEventLog <Model.Department>(e, model);
return(true);
}
else
{
errMsg = "添加记录失败，受影响行数为0";
return(false);
}
}
catch (Exception ex)
{
errMsg = ex.Message;
ErrorLog e = new ErrorLog();
e.TargetIds = "0";
e.CodeTag = "AddDepartment";
e.LogName = "添加部门";
e.ErrorMsg = ex.Message.ToString();
ErrorLogService.AddErrorLog <Model.Department>(e, model);
return(false);
}
}
//保存并退出按钮
private void buttonX3_Click(object sender, EventArgs e)
{
Model.Department dep = new Model.Department();
try
{
if (_update == false)
{
dep.Dt_Name = XYEEncoding.strCodeHex(this.textBoxXName.Text.Trim());
dep.Dt_RoleCode = comboBoxEx1.SelectedValue == null ? "" : XYEEncoding.strCodeHex(comboBoxEx1.SelectedValue.ToString());
dep.Dt_Code = XYEEncoding.strCodeHex(BuildCode.ModuleCode("DT"));
dep.Dt_Clear = 1;
int result = depm.InsDepartment(dep);
if (result == 1)
{
MessageBox.Show("部门添加成功！");
this.Close();
this.Dispose();
}
else
{
MessageBox.Show("部门保存失败！");
}
}
else
{
dep.Dt_Name = this.textBoxXName.Text.Trim();
dep.Dt_RoleCode = comboBoxEx1.SelectedValue == null ? "" : comboBoxEx1.SelectedValue.ToString();
dep.Dt_Code = _Department.Dt_Code;
int r = depm.UpdateDepartment(dep);
if (r == 1)
{
MessageBox.Show("修改部门成功！");
this.Close();
this.Dispose();
}
else
{
MessageBox.Show("修改部门失败!");
}
}
}
catch (Exception ex)
{
MessageBox.Show("错误，添加或者修改错误" + ex.Message);
}
}
/// <summary>
/// 根据id修改部门
/// </summary>
/// <param name="Model.Department"></param>
/// <returns></returns>
public static bool ModifyDepartmentById(ref Model.Department model, out string errMsg)
{
errMsg = "";
try
{
model.Name = model.Name.Trim();
model.Description = model.Description.Trim();
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Id", model.Id),
new SqlParameter("@Name", model.Name),
new SqlParameter("@Description", model.Description),
new SqlParameter("@Modifier", model.Modifier),
new SqlParameter("@ModifiedDate", model.ModifiedDate)
};
int i = DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, "proc_DepartmentByIdUpdate", para);
if (i > 0)
{
EventLog e = new EventLog();
e.TargetIds = model.Id.ToString();
e.CodeTag = "ModifyDepartmentById";
e.LogName = "修改部门";
EventLogService.AddEventLog <Model.Department>(e, model);
return(true);
}
else
{
errMsg = "该记录已被删除，不能修改！";
return(false);
}
}
catch (Exception ex)
{
errMsg = ex.Message;
ErrorLog e = new ErrorLog();
e.TargetIds = model.Id.ToString();
e.CodeTag = "ModifyDepartmentById";
e.LogName = "修改部门";
e.ErrorMsg = ex.Message.ToString();
ErrorLogService.AddErrorLog <Model.Department>(e, model);
return(false);
}
}
private bool tryValidate(Model.Department model, out string errMsg)
{
errMsg = "";
bool re = true;
if (model.Name == null || model.Name.Length == 0 || model.Name.Length > 20 ||
model.Description.Length > 200)
{
errMsg = "输入数据不合法";
re = false;
}
if (re && DepartmentManager.CheckRepeat(model))
{
errMsg = "不能重复";
re = false;
}
if (re && model.Modifier != auth.UserId)
{
errMsg = "登录信息异常，请刷新浏览器以重启应用(APP请退出应用后重新打开)";
re = false;
}
return(re);
}
private void 编辑ToolStripMenuItem_Click(object sender, EventArgs e)
{
if (superGridControl1.GetSelectedRows().Count > 0)
{
Model.Department dep = new Model.Department();
SelectedElementCollection col = superGridControl1.GetSelectedRows();
if (col.Count > 0)
{
GridRow gridRow = col[0] as GridRow;
dep.Dt_Code = gridRow["gridColumn2"].Value.ToString();
dep.Dt_Name = gridRow["gridColumn4"].Value.ToString();
dep.Dt_RoleCode = gridRow["gridColumn3"].Value.ToString();
}
InDepartment updatedep = new InDepartment();
updatedep._update = true;
updatedep._Department = dep;
updatedep.ShowDialog(this);
}
else
{
MessageBox.Show("请先选择需要编辑的信息");
}
}
public List<string> DelDep(Department delDep) { return dc.DelDep(delDep); }
public void DeleteDep(Department deleteDep)
{
dc.DeleteDep(deleteDep);
}
public int CheckDep(Department checkDep) { return dc.CheckDep(checkDep); }
public void Add(Department addDep) {
dc.name = name;
dc.description = description;
dc.AddDept(addDep);
}
public int GetDepartmentID(Department depID) { return dc.GetDepartmentID(depID); }
public int CheckDep(Department checkDep) {
var check = (from c in hrContext.Department
where c.DepartmentName == checkDep.DepartmentName
select c).Count();
return check;
}
//Nesse caso vai retornar uma lista de objeto. Não sei se seu retorno vão ter vários, ou um por vez. Se for um por vez, não precisa usar lista.
public List<Model.Department> Select(String pWhere)
{
List<Model.Department> lstDepartment = new List<Model.Department>();
Model.Department Department;
SqlCommand cmd = new SqlCommand("Select * From dbo.[Department] " + pWhere, db.Db());
//SQLHelper.ExecuteReader("string de conexao", CommandType.StoredProcedure, "Procedure", null)
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Department = new Model.Department();
if (!dr.IsDBNull(0))
{
Department.Department_id = dr.GetInt32(0);
}
if (!dr.IsDBNull(1))
{
Department.Name = dr.GetString(1);
}
lstDepartment.Add(Department);
}
}
return lstDepartment;
}
/// <summary>
/// 根据id修改部门
/// </summary>
/// <param name="Model.Department"></param>
/// <returns></returns>
public static bool ModifyDepartmentById(ref Model.Department model, out string errMsg)
{
return(DepartmentService.ModifyDepartmentById(ref model, out errMsg));
}
partial void DeleteDepartment(Department instance);
partial void UpdateDepartment(Department instance);
partial void InsertDepartment(Department instance);
public int GetDepartmentID(Department depID)
{
var get = (from g in hrContext.Department
where g.DepartmentName == depID.DepartmentName
select g.DepartmentId).SingleOrDefault();
return get;
}
public string getDeptName(Department getDeptName)
{
var get = (from g in hrContext.Department
where g.DepartmentId == getDeptName.DepartmentId
select g.DepartmentName).Single();
return get;
}
public List<string> DelDep(Department delDep)
{
var del = (from d in hrContext.Department
where d.DepartmentName != delDep.DepartmentName
select d.DepartmentName).ToList();
return del;
}
/// <summary>
/// 添加部门
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddDepartment(ref Model.Department model, out string errMsg)
{
return(DepartmentService.AddDepartment(ref model, out errMsg));
}
public string GetDeptName(Department getDeptName)
{
return dc.getDeptName(getDeptName);
}
public void AddDept(Department addDep) {
addDep.DepartmentName = name;
addDep.DepartmentDescription = description;
hrContext.Department.InsertOnSubmit(addDep);
hrContext.SubmitChanges();
}
/// <summary>
/// 检查是否重复
/// </summary>
/// <param name="Model.Department"></param>
/// <returns></returns>
public static bool CheckRepeat(Model.Department model)
{
return(DepartmentService.CheckRepeat(model));
}
