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(); }