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