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('没有相关数据可更新!');");
}
}
