/// <summary> /// 添加客户信息 /// </summary> /// <param name="custo"></param> /// <returns></returns> public bool InsertCustomerInfo(Custo custo) { string NewID = Md5LockedUtil.MD5Encrypt32(custo.CustoID); string NewTel = Md5LockedUtil.MD5Encrypt32(custo.CustoTel); custo.CustoID = NewID; custo.CustoTel = NewTel; return(base.Insert(custo)); }
private void btnAdd_Click(object sender, EventArgs e) { try { if (WorkerName.Text != null /*&& ucHistory.txtCompany.Text != null*/ && cboSex.Text != null) { string NewID = Md5LockedUtil.MD5Encrypt32(WorkerID.Text.ToString()); string NewTel = Md5LockedUtil.MD5Encrypt32(WorkerTel.Text.ToString()); #region 员工信息添加代码块 Worker worker = new Worker { WorkerId = WorkerNo.Text.Trim(), WorkerName = WorkerName.Text.Trim(), WorkerBirthday = dtpBirthday.Value, WorkerSex = cboSex.SelectedIndex, WorkerTel = NewTel, WorkerClub = cboClub.Text, WorkerAddress = txtAddress.Text, WorkerPosition = cboWorkerPosition.Text, CardId = NewID, WorkerPwd = Pwd.Text, WorkerTime = dtpTime.Value, WorkerFace = cboWorkerFace.Text, WorkerEducation = cboEducation.Text }; int n = WorkerManager.AddWorker(worker); #endregion #region 履历添加代码块 if (ucHistory.txtCompany != null && ucHistory.txtPosition != null && ucHistory.dtpStartDate.Value != null && ucHistory.dtpEndDate.Value != null) { WorkerHistory workerHistory = new WorkerHistory { StartDate = ucHistory.dtpStartDate.Value, EndDate = ucHistory.dtpEndDate.Value, Postion = ucHistory.txtPosition.Text, Company = ucHistory.txtCompany.Text }; int j = WorkerHistoryManager.AddHistoryByWorkerId(workerHistory, WorkerNo.Text); #endregion #region 判断履历和信息代码块 if (n > 0 && j > 0) { MessageBox.Show("员工信息/履历添加成功!该员工登录密码为:" + Pwd.Text + ",请提醒员工妥善保管!"); FrmWorkerManager.Reload(); #region 获取添加操作日志所需的信息 OperationLog o = new OperationLog(); o.OperationTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd,HH:mm:ss")); << << << < HEAD : SYS.FormUI / FrmAddWorker.cs << << << < HEAD : SYS.FormUI / FrmAddWorker.cs o.Operationlog = AdminInfo.admingroup + AdminInfo.adminType + "于" + DateTime.Now + "进行了添加员工操作,员工编号为:" + WorkerNo.Text + "!"; o.OperationAccount = AdminInfo.admingroup + AdminInfo.adminType; OperationManager.InsertOperationLog(o);
public static int InsertCustomerInfo(Custo custo) { string NewID = Md5LockedUtil.MD5Encrypt32(custo.CustoID); string NewTel = Md5LockedUtil.MD5Encrypt32(custo.CustoTel); string sql = "insert USERINFO(CustoNo,CustoName,CustoSex,CustoTel,PassportType,CustoID,CustoAdress,CustoBirth,CustoType)"; sql += " values('" + custo.CustoNo + "','" + custo.CustoName + "','" + custo.CustoSex + "','" + NewTel + "','" + custo.PassportType + "','" + NewID + "','" + custo.CustoAdress + "','" + custo.CustoBirth + "','" + custo.CustoType + "') "; return(DBHelper.ExecuteNonQuery(sql)); }
private void btnUpd_Click(object sender, EventArgs e) { bool dr = UIMessageBox.Show("是否确认修改员工信息?", "修改提醒", UIStyle.Green, UIMessageBoxButtons.OKCancel); if (dr == true) { string NewTel = Md5LockedUtil.MD5Encrypt32(WorkerTel.Text.ToString()); #region 员工信息代码块 Worker worker = new Worker { WorkerId = WorkerNo.Text.Trim(), WorkerName = WorkerName.Text.Trim(), WorkerNation = cbWorkerNation.SelectedValue == null ? "N-00001" : cbWorkerNation.SelectedValue.ToString(), WorkerTel = NewTel, WorkerAddress = txtAddress.Text, WorkerFace = cboWorkerFace.Text, WorkerEducation = cboEducation.SelectedValue.ToString() == null ? "E-00001" : cboEducation.SelectedValue.ToString(), datachg_usr = AdminInfo.Account, datachg_date = DateTime.Now }; bool i = new WorkerService().UpdateWorker(worker); if (i == true) { UIMessageBox.ShowSuccess("信息修改成功!"); return; } else { UIMessageBox.ShowError("服务器繁忙!"); return; } #endregion } else { UIMessageBox.ShowWarning("修改操作已取消!"); return; } }
private void btnAdd_Click(object sender, EventArgs e) { try { if (WorkerName.Text != null && cboSex.Text != null) { string NewID = Md5LockedUtil.MD5Encrypt32(WorkerID.Text.ToString()); string NewTel = Md5LockedUtil.MD5Encrypt32(WorkerTel.Text.ToString()); #region 员工信息添加代码块 Worker worker = new Worker { WorkerId = WorkerNo.Text.Trim(), WorkerName = WorkerName.Text.Trim(), WorkerBirthday = dtpBirthday.Value, WorkerSex = (int)cboSex.SelectedValue, WorkerNation = cbWorkerNation.SelectedValue.ToString(), WorkerTel = NewTel, WorkerClub = cboClub.SelectedValue.ToString(), WorkerAddress = txtAddress.Text, WorkerPosition = cboWorkerPosition.SelectedValue.ToString(), CardId = NewID, WorkerTime = dtpTime.Value, WorkerFace = cboWorkerFace.Text, WorkerEducation = cboEducation.SelectedValue.ToString(), datains_usr = AdminInfo.Account, datains_date = DateTime.Now }; bool n = new WorkerService().AddWorker(worker); #endregion if (ucHistory.txtCompany != null && ucHistory.txtPosition != null && ucHistory.dtpStartDate.Value != null && ucHistory.dtpEndDate.Value != null) { #region 履历添加代码块 WorkerHistory workerHistory = new WorkerHistory { StartDate = ucHistory.dtpStartDate.Value, EndDate = ucHistory.dtpEndDate.Value, Position = ucHistory.txtPosition.Text, Company = ucHistory.txtCompany.Text, WorkerId = WorkerNo.Text.Trim() }; bool j = new WorkerHistoryService().AddHistoryByWorkerId(workerHistory); #endregion #region 判断履历和信息代码块 if (n == true && j == true) { UIMessageBox.Show("员工信息/履历添加成功!该员工登录密码为:123456,请提醒员工妥善保管并首次登录系统时修改密码!"); FrmWorkerManager.Reload(); #region 获取添加操作日志所需的信息 OperationLog o = new OperationLog(); o.OperationTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd,HH:mm:ss")); o.Operationlog = AdminInfo.Account + AdminInfo.Name + "于" + DateTime.Now + "进行了添加员工操作,员工编号为:" + WorkerNo.Text + "!"; o.OperationAccount = AdminInfo.Account + AdminInfo.Name; o.datains_usr = AdminInfo.Account; o.datachg_date = DateTime.Now; new OperationlogService().InsertOperationLog(o); #endregion } else { UIMessageBox.Show("员工信息/履历添加失败,请检查数据格式或稍后再试!"); } #endregion } } else { UIMessageBox.Show("信息不能为空!"); } } catch (Exception ex) { //MessageBox.Show(ex.ToString()); UIMessageBox.Show("服务器繁忙或数据格式为空!"); } finally { this.Close(); } }