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));
}
}
