public int Update(PTDUTY model) { StringBuilder builder = new StringBuilder(); builder.Append("update PT_DUTY set "); builder.Append("DutyCode='" + model.DutyCode + "',"); builder.Append("c_sfyx='" + model.c_sfyx + "',"); builder.Append("DutyName='" + model.DutyName + "',"); builder.Append("DutyNumber=" + model.DutyNumber + ","); builder.Append("Remark='" + model.Remark + "'"); builder.Append(" where I_DUTYID=" + model.I_DUTYID); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
public int Add(PTDUTY model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into PT_DUTY("); builder.Append("i_bmdm,DutyCode,c_sfyx,DutyNumber,Remark,DutyName"); builder.Append(")"); builder.Append(" values ("); builder.Append(model.i_bmdm + ","); builder.Append("'" + model.DutyCode + "',"); builder.Append("'" + model.c_sfyx + "',"); builder.Append(model.DutyNumber + ","); builder.Append("'" + model.Remark + "',"); builder.Append("'" + model.DutyName + "'"); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
protected void btnAdd_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.txtDutyName.Text.Trim())) { base.RegisterScript("alert('岗位名称不能为空!');"); return; } if (string.IsNullOrEmpty(this.txtDutyNumber.Text.Trim())) { base.RegisterScript("alert('岗位编制不能为空!');"); this.txtDutyNumber.Focus(); return; } if (!Information.IsNumeric(this.txtDutyNumber.Text.ToString().Trim()) || this.txtDutyNumber.Text.ToString().Trim().Contains(".")) { base.RegisterScript("alert('岗位编制必须为自然数!');"); this.txtDutyNumber.Focus(); return; } if (Convert.ToInt32(this.txtDutyNumber.Text.ToString().Trim()) < 0) { base.RegisterScript("alert('岗位编制必须为自然数!');"); this.txtDutyNumber.Focus(); return; } PTDUTY data = this.GetData(); if (this.OperateType == "add") { DataTable pTDUTYDifferent = this.hrAction.GetPTDUTYDifferent(this.txtDutyName.Text.Trim(), this.BMDM.ToString()); if (pTDUTYDifferent.Rows.Count > 0) { base.RegisterScript("alert('岗位名称已存在,请重新输入!');"); return; } int num = this.hrAction.Add(data); if (num > 0) { base.RegisterScript("successed('添加');"); } else { base.RegisterScript("alert('没有相关数据可添加!');"); } } if (this.OperateType == "upd") { DataTable list = this.hrAction.GetList(this.RecordID.ToString()); if (list.Rows.Count > 0 && this.txtDutyName.Text.Trim() != list.Rows[0]["DutyName"].ToString()) { DataTable pTDUTYDifferent2 = this.hrAction.GetPTDUTYDifferent(this.txtDutyName.Text.Trim(), this.BMDM.ToString()); if (pTDUTYDifferent2.Rows.Count > 0) { base.RegisterScript("alert('岗位名称已存在,请重新输入!');"); return; } } int num = this.hrAction.Update(data); if (num > 0) { base.RegisterScript("successed('修改');"); return; } base.RegisterScript("alert('没有相关数据可更新!');"); } }