public JsonResult UpdateOrInsertOrderTypeTousuConfig(OrderTypeTousuConfig model)
{
var identity = ThreadIdentity.Operator;
var result = TousuBusiness.UpdateOrInsertOrderTypeTousuConfig(model);
if (result)
{
var aftervalue = "修改LastLevelTousu:" + model.LastLevelTousu + ",IsChecked:" + model.IsChecked + ",IsNeedPhoto:" + model.IsNeedPhoto + ",CautionText:" + model.CautionText;
using (var log = new ConfigLogClient())
{
var issuccess = log.InsertDefaultLogQueue("TousuConfigLog", JsonConvert.SerializeObject(new
{
ObjectId = model.LastLevelTousu,
ObjectType = "LastLevelTousuUpdate",
BeforeValue = "",
AfterValue = "修改LastLevelTousu:" + model.LastLevelTousu + ",IsChecked:" + model.IsChecked + ",IsNeedPhoto:" + model.IsNeedPhoto + ",CautionText:" + model.CautionText,
Operate = "Update",
Author = identity.Name
}));
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateOrInsertOrderTypeTousuConfig(OrderTypeTousuConfig model)
{
var result = TousuBusiness.UpdateOrInsertOrderTypeTousuConfig(model);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public static bool UpdateOrInsertOrderTypeTousuConfig(OrderTypeTousuConfig model)
{
return(DalTousuConfig.UpdateOrInsertOrderTypeTousuConfig(model));
}
public static bool UpdateOrInsertOrderTypeTousuConfig(OrderTypeTousuConfig model)
{
bool result = false;
IEnumerable <OrderTypeTousuConfig> ordertypeTousuConfigList;
if (model != null)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Shouhou")))
{
ordertypeTousuConfigList = dbHelper.ExecuteDataTable(@"SELECT [PKID]
,[OrderType]
,[TopLevelTousu]
,[SecondLevelTousu]
,[ThirdLevelTousu]
,[FourthLevelTousu]
,[LastLevelTousu]
,[IsNeedPhoto]
,[CautionText]
,[GroupName]
FROM [dbo].[OrderTypeTousuConfig] with(nolock)
where (OrderType=@OrderType)
and (LastLevelTousu=@LastLevelTousu)
order by PKID desc
;", CommandType.Text,
new SqlParameter[] {
new SqlParameter("@OrderType", model.OrderType),
new SqlParameter("@LastLevelTousu", model.LastLevelTousu)
}).ConvertTo <OrderTypeTousuConfig>();
}
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Shouhou")))
{
if (ordertypeTousuConfigList != null && ordertypeTousuConfigList.Any())
{
using (var cmd =
new SqlCommand(
@"UPDATE [OrderTypeTousuConfig] WITH(ROWLOCK) SET IsChecked=@IsChecked,IsNeedPhoto=@IsNeedPhoto,CautionText=@CautionText,GroupName=@GroupName,LastUpdateDateTime=@LastUpdateDateTime WHERE (OrderType=@OrderType)
and (LastLevelTousu=@LastLevelTousu)")
)
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@IsChecked", model.IsChecked);
cmd.Parameters.AddWithValue("@IsNeedPhoto", model.IsNeedPhoto);
cmd.Parameters.AddWithValue("@CautionText", model.CautionText);
cmd.Parameters.AddWithValue("@GroupName", model.GroupName ?? string.Empty);
cmd.Parameters.AddWithValue("@OrderType", model.OrderType);
cmd.Parameters.AddWithValue("@LastLevelTousu", model.LastLevelTousu);
cmd.Parameters.AddWithValue("@LastUpdateDateTime", DateTime.Now);
result = dbHelper.ExecuteNonQuery(cmd) > 0 ? true : false;
}
}
else
{
using (var cmd =
new SqlCommand(
@"INSERT INTO [dbo].[OrderTypeTousuConfig] ([OrderType],[TopLevelTousu],[SecondLevelTousu],[ThirdLevelTousu],[FourthLevelTousu],[LastLevelTousu],[IsNeedPhoto],[IsChecked],[CautionText],[GroupName],[CreateDateTime],[LastUpdateDateTime])
VALUES(@OrderType,@TopLevelTousu,@SecondLevelTousu,@ThirdLevelTousu,@FourthLevelTousu,@LastLevelTousu,@IsNeedPhoto,@IsChecked,@CautionText,@GroupName,@CreateDateTime,@LastUpdateDateTime)")
)
{
var datetimeNow = DateTime.Now;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@OrderType", model.OrderType);
cmd.Parameters.AddWithValue("@TopLevelTousu", model.TopLevelTousu);
cmd.Parameters.AddWithValue("@SecondLevelTousu", model.SecondLevelTousu);
cmd.Parameters.AddWithValue("@ThirdLevelTousu", model.ThirdLevelTousu);
cmd.Parameters.AddWithValue("@FourthLevelTousu", model.FourthLevelTousu);
cmd.Parameters.AddWithValue("@LastLevelTousu", model.LastLevelTousu);
cmd.Parameters.AddWithValue("@IsNeedPhoto", model.IsNeedPhoto);
cmd.Parameters.AddWithValue("@IsChecked", model.IsChecked);
cmd.Parameters.AddWithValue("@CautionText", model.CautionText);
cmd.Parameters.AddWithValue("@GroupName", model.GroupName ?? string.Empty);
cmd.Parameters.AddWithValue("@CreateDateTime", datetimeNow);
cmd.Parameters.AddWithValue("@LastUpdateDateTime", datetimeNow);
result = dbHelper.ExecuteNonQuery(cmd) > 0 ? true : false;
}
}
}
}
return(result);
}
