public void UpdateSalesLeaveStateInfo(SalesLeaveState info, string id, SalesLeaveStateUpdateDataMode mode)
{
if (SalesLeaveStateUpdateDataMode.MODE_DELETE == mode)
{
if (null == id)
{
return;
}
DeleteSalesLeaveStateByID(id);
}
if (SalesLeaveStateUpdateDataMode.MODE_INSERT == mode)
{
if (null == info)
{
return;
}
InsertSalesLeaveStateInfo(info);
}
if (SalesLeaveStateUpdateDataMode.MODE_UPDATE == mode)
{
if (null == info)
{
return;
}
UpdateExistsSalesLeaveStateInfo(info);
}
}
private void InsertSalesLeaveStateInfo(SalesLeaveState info)
{
string sql = "insert into SalesLeaveState(SalesLeaveStateName, SalesLeaveStateSeqNumber, SalesLeaveStateDescribe)";
sql += " VALUES('{0}', {1}, '{2}')";
sql = string.Format
(
sql,
info.SalesLeaveStateName,
info.SalesLeaveStateSeqNumber,
info.SalesLeaveStateDescribe
);
SqlOperation.UpdateData(sql);
}
private void UpdateExistsSalesLeaveStateInfo(SalesLeaveState info)
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("update SalesLeaveState set SalesLeaveStateName = '{0}', SalesLeaveStateSeqNumber = {1}, ");
sqlBuilder.Append("SalesLeaveStateDescribe = '{2}' where SalesLeaveStateID = {3}");
string sql = string.Format
(
sqlBuilder.ToString(),
info.SalesLeaveStateName,
info.SalesLeaveStateSeqNumber,
info.SalesLeaveStateDescribe,
info.SalesLeaveStateID
);
SqlOperation.UpdateData(sql);
}
private void btnSave_Click(object sender, EventArgs e)
{
SalesLeaveState info = new SalesLeaveState();
info.SalesLeaveStateName = txtSalesLeaveStateName.Text.ToString().Trim();
info.SalesLeaveStateSeqNumber = Convert.ToInt32(txtSequenceNumber.Text);
info.SalesLeaveStateDescribe = this.rtbSalesLeaveStateDescribe.Text.ToString();
if (0 == Convert.ToInt32(this.Tag))
{
objSalesLeaveStateService.UpdateSalesLeaveStateInfo(info, null, SalesLeaveStateUpdateDataMode.MODE_INSERT);
}
else
{
info.SalesLeaveStateID = Convert.ToInt32(this.Tag);
objSalesLeaveStateService.UpdateSalesLeaveStateInfo(info, null, SalesLeaveStateUpdateDataMode.MODE_UPDATE);
}
this.Close();
this.ShowUpdate();
}
