/// <summary>
/// 更新库存状态至前一状态，若前一状态为空，则更新至第三参数
/// </summary>
/// <param name="user"></param>
/// <param name="stock"></param>
/// <param name="stockStatusEnum"></param>
/// <returns></returns>
public ResultModel UpdateStockStatusToPrevious(UserModel user, Stock stock, StockStatusEnum stockStatusEnum)
{
ResultModel result = new ResultModel();
try
{
string sql = string.Format("update NFMT.dbo.St_Stock set StockStatus = ISNULL(PreStatus,{0}) where StockId = {1}", (int)stockStatusEnum, stock.StockId);
int i = NFMT.DBUtility.SqlHelper.ExecuteNonQuery(this.ConnectString, CommandType.Text, sql, null);
if (i > 0)
{
result.ResultStatus = 0;
result.Message = "更新成功";
result.AffectCount = i;
}
else
{
result.ResultStatus = -1;
result.Message = "更新失败";
}
}
catch (Exception e)
{
result.Message = e.Message;
result.ResultStatus = -1;
}
return result;
}
//public ResultModel UpdateStockStatus(Stock stock, StockStatusEnum stockStatus, StockStatusEnum defaultStatus)
//{
// ResultModel result = new ResultModel();
// try
// {
// string sql = string.Format("update dbo.St_Stock set PreStatus = StockStatus ,StockStatus = {0} where StockId = {1} ", (int)stockStatus, stock.StockId);
// int i = NFMT.DBUtility.SqlHelper.ExecuteNonQuery(this.ConnectString, CommandType.Text, sql, null);
// if (i > 0)
// {
// result.ResultStatus = 0;
// result.Message = "更新状态成功";
// result.AffectCount = i;
// }
// else
// {
// result.ResultStatus = -1;
// result.Message = "更新状态失败";
// result.AffectCount = i;
// }
// }
// catch (Exception e)
// {
// result.ResultStatus = -1;
// result.Message = string.Format("更新状态失败,{0}", e.Message);
// }
// return result;
//}
/// <summary>
/// 直接更新库存状态
/// </summary>
/// <param name="stock"></param>
/// <param name="stockStatus"></param>
/// <returns></returns>
public ResultModel UpdateStockStatusDirect(Stock stock, StockStatusEnum stockStatus)
{
ResultModel result = new ResultModel();
try
{
string sql = string.Format("update dbo.St_Stock set StockStatus = {0} where StockId = {1} ", (int)stockStatus, stock.StockId);
int i = NFMT.DBUtility.SqlHelper.ExecuteNonQuery(this.ConnectString, CommandType.Text, sql, null);
if (i > 0)
{
result.ResultStatus = 0;
result.Message = "更新状态成功";
result.AffectCount = i;
}
else
{
result.ResultStatus = -1;
result.Message = "更新状态失败";
result.AffectCount = i;
}
}
catch (Exception e)
{
result.ResultStatus = -1;
result.Message = string.Format("更新状态失败,{0}", e.Message);
}
return result;
}
