public System.Web.Mvc.JsonResult UpdateCJH(string[] param) { DataTable dt = null; string Batchstr = ""; int Batch = 0; string batchNub = @"select Max(distinct batch) batch from I_FrameNumberMiddleTable where substr(batch,0,8)='" + DateTime.Now.ToString("yyyyMMdd") + "'"; var batchVar = OThinker.H3.Controllers.AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteScalar(batchNub); Batch = Convert.ToInt32(batchVar.ToString().Length > 8 ? batchVar.ToString().Substring(8, batchVar.ToString().Length - 8) : "0") + 1; if (batchVar.ToString().Length > 8 && batchVar.ToString().Substring(0, 8) == DateTime.Now.ToString("yyyyMMdd")) { Batchstr = DateTime.Now.ToString("yyyyMMdd") + Batch; } else { Batchstr = DateTime.Now.ToString("yyyyMMdd") + 1; } string[] strPar = param;//param.Split(','); string message = ""; OThinker.Data.Database.Parameter[] pars = new OThinker.Data.Database.Parameter[2]; for (int i = 0; i < strPar.Length; i++) { string sqlUser = string.Format(@"select distinct trim(Unit_No) Unit_No,asset_desc,trim(a.dealer_code) dealer_code,trim(b.dealer_name) dealer_name from IN_WFS.V_LOAN_STOCK_LIST a join IN_WFS.V_DEALER_INFO b on a.dealer_code = b.dealer_code where Vin_No='{0}'", strPar[i].Split(';')[0]); dt = ExecuteDataTableSql("Wholesale", sqlUser); try { pars[0] = new OThinker.Data.Database.Parameter("v_vin_no_old", DbType.String, strPar[i].Split(';')[0]); pars[1] = new OThinker.Data.Database.Parameter("v_vin_no_new", DbType.String, strPar[i].Split(';')[1]); ExecuteDataTableSP("Wholesale", "IN_WFS.ZUPDATEVIN", pars); } catch (Exception e) { message = message + strPar[i].Split(';')[0] + "; "; return(Json(new { Success = message == "", Message = e.Message }, JsonRequestBehavior.AllowGet)); } string objectid = Guid.NewGuid().ToString(); string VehicleNumber = dt.Rows[0]["Unit_No"].ToString(); string CarModel = dt.Rows[0]["asset_desc"].ToString(); //string TemporaryFrameNumber = (pars[0]).ToString(); //string PermanentFrameNumber = (pars[1]).ToString(); string TemporaryFrameNumber = strPar[i].Split(';')[0]; string PermanentFrameNumber = strPar[i].Split(';')[1]; string sql = string.Format(@"INSERT INTO I_FrameNumberMiddleTable(objectid,Batch,VehicleNumber,CarModel,TemporaryFrameNumber,PermanentFrameNumber) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}')", objectid, Batchstr, VehicleNumber, CarModel, TemporaryFrameNumber, PermanentFrameNumber); int count = OThinker.H3.Controllers.AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteNonQuery(sql); } try { MessageClass ms = new MessageClass(); string[] workerArr = { "YYB01" }; //发送消息给运营 string msstrc = dt.Rows[0]["dealer_name"].ToString() + "(" + dt.Rows[0]["dealer_code"].ToString() + ")有<font color=\"red\">" + strPar.Length + "</font>辆车临时车架号已改为永久车架号"; for (int j = 0; j < workerArr.Length; j++) { string arr = workerArr[j]; List <RoleUserViewModel> roleuser = new WapiDZEQ.Common.MessageRole().GetRoleUser(arr); for (int k = 0; k < roleuser.Count; k++) { string userId = roleuser[k].UserID; string USERCODE = roleuser[k].UserCode; ms.InsertMSG(userId, USERCODE, msstrc, true, 4, Batchstr); } } var result = new { Success = message == "", Message = message }; return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new { Success = message == "", Message = "" }, JsonRequestBehavior.AllowGet)); } }