public ActionResult Confirm(VarianceEditModel model)
{
try
{
var user = AccountHelper.GetLoginUserInfo(HttpContext.User.Identity);
model.LoginName = user.LoginName;
model.EditType = 2;
model.CustomerCode = user.CustomerCode;
string message = OrderVarianceManager.Instance.Edit(model);
if (!String.IsNullOrEmpty(message))
{
TempData["Error"] = message;
return View("Error");
}
return RedirectToAction("index");
}
catch (Exception ex)
{
TempData["Error"] = ex.ToString();
return View("Error");
}
}
public static string Edit(VarianceEditModel model)
{
SqlParameter[] parameters = new SqlParameter[31];
parameters[0] = new SqlParameter("@lx", SqlDbType.SmallInt);
parameters[0].Value = model.EditType;
parameters[1] = new SqlParameter("@tGuid", SqlDbType.VarChar);
parameters[1].Value = model.TGuid;
parameters[2] = new SqlParameter("@khh", SqlDbType.VarChar);
parameters[2].Value = model.CustomerCode;
parameters[3] = new SqlParameter("@xh", SqlDbType.VarChar);
parameters[3].Value = model.ModelNo;
parameters[4] = new SqlParameter("@htbh", SqlDbType.VarChar);
parameters[4].Value = model.OldHtbh;
parameters[5] = new SqlParameter("@czr", SqlDbType.VarChar);
parameters[5].Value = model.LoginName;
parameters[6] = new SqlParameter("@fhrq", SqlDbType.Date);
parameters[6].Value = model.SendDate;
parameters[7] = new SqlParameter("@bundleNo", SqlDbType.VarChar);
parameters[7].Value = model.BundleNo;
parameters[8] = new SqlParameter("@bn", SqlDbType.VarChar);
parameters[8].Value = model.OldBundleNo;
parameters[9] = new SqlParameter("@id", SqlDbType.Int);
parameters[9].Value = model.Id;
parameters[10] = new SqlParameter("@s1", SqlDbType.Int);
parameters[10].Value = model.Size1;
parameters[11] = new SqlParameter("@s2", SqlDbType.Int);
parameters[11].Value = model.Size2;
parameters[12] = new SqlParameter("@s3", SqlDbType.Int);
parameters[12].Value = model.Size3;
parameters[13] = new SqlParameter("@s4", SqlDbType.Int);
parameters[13].Value = model.Size4;
parameters[14] = new SqlParameter("@s5", SqlDbType.Int);
parameters[14].Value = model.Size5;
parameters[15] = new SqlParameter("@s6", SqlDbType.Int);
parameters[15].Value = model.Size6;
parameters[16] = new SqlParameter("@s7", SqlDbType.Int);
parameters[16].Value = model.Size7;
parameters[17] = new SqlParameter("@s8", SqlDbType.Int);
parameters[17].Value = model.Size8;
parameters[18] = new SqlParameter("@s9", SqlDbType.Int);
parameters[18].Value = model.Size9;
parameters[19] = new SqlParameter("@s10", SqlDbType.Int);
parameters[19].Value = model.Size10;
parameters[20] = new SqlParameter("@s11", SqlDbType.Int);
parameters[20].Value = model.Size11;
parameters[21] = new SqlParameter("@s12", SqlDbType.Int);
parameters[21].Value = model.Size12;
parameters[22] = new SqlParameter("@s13", SqlDbType.Int);
parameters[22].Value = model.Size13;
parameters[23] = new SqlParameter("@s14", SqlDbType.Int);
parameters[23].Value = model.Size14;
parameters[24] = new SqlParameter("@s15", SqlDbType.Int);
parameters[24].Value = model.Size15;
parameters[25] = new SqlParameter("@s16", SqlDbType.Int);
parameters[25].Value = model.Size16;
parameters[26] = new SqlParameter("@s17", SqlDbType.Int);
parameters[26].Value = model.Size17;
parameters[27] = new SqlParameter("@s18", SqlDbType.Int);
parameters[27].Value = model.Size18;
parameters[28] = new SqlParameter("@s19", SqlDbType.Int);
parameters[28].Value = model.Size19;
parameters[29] = new SqlParameter("@s20", SqlDbType.Int);
parameters[29].Value = model.Size20;
parameters[30] = new SqlParameter("@message", SqlDbType.VarChar);
parameters[30].Size = 500;
parameters[30].Direction = ParameterDirection.InputOutput;
SqlHelper.ExecuteNonQuery(ConnectionHelper.ConnectionString
, CommandType.StoredProcedure
, "spr_khys_ovrN"
, parameters);
return parameters[30].Value.ToString();
}
public string Edit(VarianceEditModel model)
{
return OrderVarianceDataProvider.Edit(model);
}