public ActionResult Edit(SyssettingInfo syssettingInfo)
{
if (string.IsNullOrEmpty(syssettingInfo.UpdatedBy))
{
return Insert(syssettingInfo);
}
else
{
return Update(syssettingInfo);
}
}
/// <summary>
/// 设置SQL参数表
/// </summary>
/// <param name="Syssetting">Syssetting对象</param>
/// <returns>Syssetting参数数组</returns>
private SqlParameter[] Set_Syssetting_Parameters(SyssettingInfo syssettingInfo)
{
SqlParameter[] paramArray = new SqlParameter[] {new SqlParameter("@SysSettingID",syssettingInfo.SysSettingID),
new SqlParameter("@Description",syssettingInfo.Description),
new SqlParameter("@Value",syssettingInfo.Value),
new SqlParameter("@DefaultValue",string.IsNullOrEmpty(syssettingInfo.DefaultValue)?"":syssettingInfo.DefaultValue),
new SqlParameter("@CreatedBy",string.IsNullOrEmpty(syssettingInfo.CreatedBy)?"":syssettingInfo.CreatedBy),
new SqlParameter("@UpdatedBy",string.IsNullOrEmpty(syssettingInfo.UpdatedBy)?"":syssettingInfo.UpdatedBy)
};
return paramArray;
}
/// <summary>
/// 初始化SyssettingInfo
/// </summary>
private SyssettingInfo InitSyssettingInfoByDataReader(SyssettingInfo syssettingInfo, IDataReader reader)
{
syssettingInfo = new SyssettingInfo(reader["SysSettingID"].ToString(),
reader["Description"].ToString(),
reader["Value"].ToString(),
reader["DefaultValue"].ToString(),
reader["CreatedBy"].ToString(),
reader["CreatedDate"].ToString() != "" ? DateTime.Parse(reader["CreatedDate"].ToString()) : new DateTime(),
reader["UpdatedBy"].ToString(),
reader["UpdatedDate"].ToString() != "" ? DateTime.Parse(reader["UpdatedDate"].ToString()) : new DateTime());
return syssettingInfo;
}
/// <summary>
/// 更新一条Syssetting记录
/// </summary>
/// <param name="db">DataBase对象</param>
/// <param name="tran">一个有效的DbTransaction</param>
/// <param name="syssetting">Syssetting对象</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>执行更新对数据库影响的行数</returns>
public int UpdateSyssetting(Database db, DbTransaction tran, SyssettingInfo syssettingInfo)
{
int result = 0;
SqlParameter[] paras = Set_Syssetting_Parameters(syssettingInfo);
if (paras != null)
{
result += DBHelper.ExecuteNonQuery(db, tran, CommandType.Text, SQL_UPDATE_SYSSETTING, paras);
}
return result;
}
/// <summary>
/// 新增一条Syssetting记录
/// </summary>
/// <param name="syssetting">Syssetting对象</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>执行新增对数据库影响的行数</returns>
public int InsertSyssetting(SyssettingInfo syssettingInfo)
{
int result = 0;
SqlParameter[] paras = Set_Syssetting_Parameters(syssettingInfo);
if (paras != null)
{
result = DBHelper.ExecuteNonQuery(CommandType.Text, SQL_INSERT_SYSSETTING, paras);
}
return result;
}
public ActionResult Insert(SyssettingInfo syssettingInfo)
{
try
{
syssettingInfo.CreatedDate = DateTime.Now;
syssettingInfo.UpdatedDate = DateTime.Now;
syssettingInfo.CreatedBy = CurrentUserInfo.UserCode;
syssettingInfo.UpdatedBy = CurrentUserInfo.UserCode;
ISyssettingService syssettingService = UnityHelper.UnityResolve<ISyssettingService>();
var data = syssettingService.InsertSyssetting(syssettingInfo);
LogHelper.LogOperation(CurrentUserInfo.UserCode, string.Format("Insert SyssettingInfo {0},{1}", LogHelper.ChangeEntityToLog(syssettingInfo), data));
if (data > 0)
{
return Content("OK");
}
else
{
return Content("Failed");
}
}
catch (BusinessException bex)
{
return Content(bex.Message);
}
catch (Exception ex)
{
LogHelper.LogError(ex, "");
return Content(ex.Message);
}
}
/// <summary>
/// 更新一条Syssetting记录
/// </summary>
/// <param name="syssetting">Syssetting对象</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>执行更新对数据库影响的行数</returns>
public int UpdateSyssetting(SyssettingInfo syssettingInfo)
{
return syssettingDA.UpdateSyssetting(syssettingInfo);
}
/// <summary>
/// 新增一条Syssetting记录
/// </summary>
/// <param name="syssetting">Syssetting对象</param>
/// <param name="whLoginID">要查询的仓库的前缀</param>
/// <returns>执行新增对数据库影响的行数</returns>
public int InsertSyssetting(SyssettingInfo syssettingInfo)
{
return syssettingDA.InsertSyssetting(syssettingInfo);
}
