internal int EditOrderApplyResp_OrderInfo(Api_hzins_OrderApplyResp_OrderInfo m) { if (m.id > 0) { return(0); } else { string sql = @"INSERT INTO [api_hzins_OrderApplyResp_OrderInfo] ([orderid] ,[insureNum] ,[policyNum] ,[cName] ,[cardCode] ,[issueState]) VALUES (@orderid ,@insureNum ,@policyNum ,@cName ,@cardCode ,@issueState);select @@identity;"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@orderid", m.orderid); cmd.AddParam("@insureNum", m.insureNum); cmd.AddParam("@policyNum", m.policyNum); cmd.AddParam("@cName", m.cName); cmd.AddParam("@cardCode", m.cardCode); cmd.AddParam("@issueState", m.issueState); object o = cmd.ExecuteScalar(); return(int.Parse(o.ToString())); } }
public int EditOrderApplyResp_OrderInfo(Api_hzins_OrderApplyResp_OrderInfo m) { using (var helper = new SqlHelper()) { int r = new Internalapi_hzins_OrderApplyResp_OrderInfo(helper).EditOrderApplyResp_OrderInfo(m); return(r); } }
protected void Page_Load(object sender, EventArgs e) { var inputStream = Request.InputStream; var strLen = Convert.ToInt32(inputStream.Length); var strArr = new byte[strLen]; inputStream.Read(strArr, 0, strLen); var requestMes = Encoding.UTF8.GetString(strArr); //TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\BaoxianLog.txt", requestMes); //录入和慧择网交互日志 ApiLog mapilog = new ApiLog { Id = 0, request_type = "Hzins_AsyncNotice", Serviceid = 2, Str = requestMes.Trim(), Subdate = DateTime.Now, ReturnStr = "success", ReturnSubdate = DateTime.Now, Errmsg = "", }; int ins = new ApiLogData().EditLog(mapilog); Hzins_AsyncOrderInfo mresp = (Hzins_AsyncOrderInfo)JsonConvert.DeserializeObject(requestMes, typeof(Hzins_AsyncOrderInfo)); if (mresp != null) { string insureNum = mresp.insureNum; int orderid = new Api_hzins_OrderApplyResp_OrderExtData().GetorderidbyinsureNum(mresp.insureNum); if (orderid == 0) { TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\BaoxianLog.txt", "orderid=0"); return; } B2b_order modelb2border = new B2bOrderData().GetOrderById(orderid); if (modelb2border == null) { TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\BaoxianLog.txt", "modelb2border==null"); return; } if (mresp.resultCode == 0) { if (mresp.policyList != null) { List <AsyncOrderInfo_policyList> policyList = mresp.policyList; foreach (AsyncOrderInfo_policyList policy in policyList) { int issueState = policy.issueState; string cName = policy.insurant; Api_hzins_OrderApplyResp_OrderInfo m1 = new Api_hzins_OrderApplyResp_OrderInfo { id = 0, orderid = modelb2border.Id, insureNum = insureNum, policyNum = "", cName = cName, cardCode = "", issueState = issueState }; int ins1 = new Api_hzins_OrderApplyResp_OrderInfoData().EditOrderApplyResp_OrderInfo(m1); } modelb2border.Order_state = (int)OrderStatus.HasSendCode; modelb2border.Order_remark = "异步出单成功"; new B2bOrderData().InsertOrUpdate(modelb2border); try { //如果保险订单(b单)是原始订单(a单)的绑定订单,则修改原始订单(a单)的状态 int aorderid = new B2bOrderData().Getinitorderid(orderid); if (aorderid > 0) { new B2bOrderData().Uporderstate(aorderid, (int)OrderStatus.HasSendCode); } } catch (Exception ex) { TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\BaoxianLog.txt", "aorderid error"); return; } } } else { modelb2border.Order_remark = "异步出单通知错误(" + requestMes + ")"; new B2bOrderData().InsertOrUpdate(modelb2border); TxtHelper.WriteFile("D:\\site\\b2betown\\ETS2.WebApp\\BaoxianLog.txt", "mresp.resultCode != 0"); return; } } Response.Write("success"); Response.End(); }