public JsonResult SaveSpare(int userID, string sessionID, InvSpareInfo info)
{
ServiceResultModel <int> result = new ServiceResultModel <int>();
try
{
if (!CheckSessionID(userID, sessionID, result))
{
return(MyJson(result, JsonRequestBehavior.AllowGet));
}
UserInfo user = null;
if (CheckUser(userID, result, out user) == false)
{
return(MyJson(result, JsonRequestBehavior.AllowGet));
}
if (this.invSpareDao.CheckSpareSerialCode(info.ID, info.FujiClass2.ID, info.SerialCode, info.StartDate))
{
result.SetFailed(ResultCodes.ParameterError, "序列号已存在");
return(MyJson(result, JsonRequestBehavior.AllowGet));
}
result.Data = this.invSpareManager.SaveSpare(info, user);
}
catch (Exception ex)
{
NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
}
return(MyJson(result, JsonRequestBehavior.AllowGet));
}
public int SaveSpare(InvSpareInfo info, UserInfo userInfo)
{
if (info.ID == 0)
{
info.ID = this.invSpareDao.AddSpare(info);
}
else
{
this.invSpareDao.UpdateSpare(info);
}
return(info.ID);
}
/// <summary>
/// 修改备用机信息
/// </summary>
/// <param name="info">备用机信息</param>
/// <returns>备用机id</returns>
public int UpdateSpare(InvSpareInfo info)
{
sqlStr = "UPDATE tblInvSpare Set FujiClass2ID=@FujiClass2ID,SerialCode=@SerialCode,Price=@Price,StartDate=@StartDate,EndDate=@EndDate,UpdateDate=GetDate() " +
" WHERE ID = @ID";
using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr))
{
command.Parameters.Add("@ID", SqlDbType.Int).Value = info.ID;
command.Parameters.Add("@FujiClass2ID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.FujiClass2.ID);
command.Parameters.Add("@SerialCode", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.SerialCode);
command.Parameters.Add("@Price", SqlDbType.Decimal).Value = info.Price;
command.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.StartDate);
command.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.EndDate);
command.ExecuteNonQuery();
return(info.ID);
}
}
/// <summary>
/// 添加备用机
/// </summary>
/// <param name="info">备用机信息</param>
/// <returns>备用机id</returns>
public int AddSpare(InvSpareInfo info)
{
sqlStr = "INSERT INTO tblInvSpare(FujiClass2ID,SerialCode,Price,StartDate,EndDate,AddDate) " +
" VALUES(@FujiClass2ID,@SerialCode,@Price,@StartDate,@EndDate,GetDate()); " +
" SELECT @@IDENTITY ";
using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr))
{
command.Parameters.Add("@FujiClass2ID", SqlDbType.Int).Value = SQLUtil.ConvertInt(info.FujiClass2.ID);
command.Parameters.Add("@SerialCode", SqlDbType.NVarChar).Value = SQLUtil.TrimNull(info.SerialCode);
command.Parameters.Add("@Price", SqlDbType.Decimal).Value = info.Price;
command.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.StartDate);
command.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = SQLUtil.ConvertDateTime(info.EndDate);
info.ID = SQLUtil.ConvertInt(command.ExecuteScalar());
return(info.ID);
}
}
public JsonResult SaveSpare(InvSpareInfo info)
{
ResultModel <int> result = new ResultModel <int>();
if (CheckSession(false) == false)
{
return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
}
if (CheckSessionID() == false)
{
return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
}
try
{
result.Data = this.invSpareManager.SaveSpare(info, GetLoginUser());
}
catch (Exception ex)
{
NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
}
return(JsonResult(result));
}
