/// <summary> /// 通用增、删、改操作 /// </summary> /// <param name="info"></param> /// <param name="id"></param> /// <param name="mode"></param> public void UpdateDayOffStateInfo(DayOffState info, string id, DayOffStateUpdateMode mode) { if (DayOffStateUpdateMode.MODE_INSERT == mode) { if (null == info) { } InsertDayOffStateInfo(info); } else if (DayOffStateUpdateMode.MODE_UPDATE == mode) { if (null == info) { return; } UpdateExistsDayOffStateInfo(info); } else if (DayOffStateUpdateMode.MODE_DELETE == mode) { if (null == id) { /*写日志*/ return; } DeleteDayOffStateInfoByID(id); } }
private void InsertDayOffStateInfo(DayOffState info) { string sql = "insert into DayOffState(DayOffStateName, SequenceNumber, DayOffStateDescribe)"; sql += " VALUES('{0}', {1}, '{2}')"; sql = string.Format(sql, info.DayOffStateName, info.DayOffStateID, info.DayOffStateDescribe); try { SqlOperation.UpdateData(sql); } catch (Exception ex) { throw new Exception("添加数据异常:" + ex.Message); } }
private void UpdateExistsDayOffStateInfo(DayOffState info) { StringBuilder sqlBUilder = new StringBuilder(); sqlBUilder.Append("update DayOffState set DayOffStateName = '{0}', SequenceNumber = {1}, "); sqlBUilder.Append("DayOffStateDescribe = '{2}' where DayOffStateID = {3}"); string sql = string.Format ( sqlBUilder.ToString(), info.DayOffStateName, info.SequenceNumber, info.DayOffStateDescribe, info.DayOffStateID ); SqlOperation.UpdateData(sql); }
private void UpdateDayOffStateInfo(DayOffStateUpdateMode mode) { DayOffState objDayOffState = new DayOffState() { DayOffStateName = this.txtDayOffStateName.Text.ToString().Trim(), DayOffStateDescribe = this.rtbDayOffStateDescribe.Text.ToString(), SequenceNumber = Convert.ToInt32(this.txtSequenceNumber.Text) }; if (DayOffStateUpdateMode.MODE_INSERT == mode) { objDayOffStateService.UpdateDayOffStateInfo(objDayOffState, null, mode); } if (DayOffStateUpdateMode.MODE_UPDATE == mode) { objDayOffState.DayOffStateID = Convert.ToInt32(this.Tag); objDayOffStateService.UpdateDayOffStateInfo(objDayOffState, null, mode); } }