/// <summary> /// 得到一个对象实体 /// </summary> public InsuranceOrderInfo GetModel(int InsuranceOrderId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select InsuranceOrderId,InsuranceOrderCity1,InsuranceOrderCity1Name,InsuranceOrderCity2,InsuranceOrderCity2Name,InsuranceOrderCompany,InsuranceOrderCompany_Name,InsuranceOrderJiaoQiangXian,InsuranceOrderShangYeSanXian,InsuranceOrderShangYeSanXianEr,InsuranceOrderCheShangRenYuanSiJiXian,InsuranceOrderCheShangRenYuanSiJiXianEr,InsuranceOrderCheShangRenYuanChengKeXian,InsuranceOrderCheShangRenYuanChengKeXianEr,InsuranceOrderCheLiangSunShiXian,InsuranceOrderDaoQiangXian,InsuranceOrderBoliXian,InsuranceOrderZiRanXian,InsuranceOrderSheShuiXian,InsuranceOrderTeYueXian,InsuranceOrderSanFangZenRenXian,InsuranceOrderHuaHenXian,InsuranceOrderCarType,InsuranceOrderJiaoZhaoZhengBen,InsuranceOrderJiaoZhaoFuBen,InsuranceOrderName,InsuranceOrderTel,InsuranceOrderCardZheng,InsuranceOrderCardFan,InsuranceOrderAddres,InsuranceOrderShouJIanName,InsuranceOrderShouJIanTel,InsuranceOrderStatu,InsuranceOrderAmount,InsuranceOrderNotes,InsuranceUserId,InsuranceOrderOpenId,InsuranceOrderCreatDate,InsuranceOrderUpdateDate,InsuranceOrderIsRenewal from Hishop_InsuranceOrder "); strSql.Append(" where InsuranceOrderId=@InsuranceOrderId "); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "InsuranceOrderId", DbType.Int32, InsuranceOrderId); InsuranceOrderInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
protected override void AttachChildControls() { this.orderId = this.Page.Request.QueryString["orderId"]; InsuranceOrderInfo info = dao.GetModel(Convert.ToInt32(this.orderId)); decimal num = 0M; decimal num2 = 0M; num = info.InsuranceOrderAmount.Value; if (info == null) { this.Page.Response.Redirect("/Vshop/MemberInsuranceOrders.aspx"); } bool flag = true; if (info.InsuranceOrderStatu != 2) { HttpContext.Current.Response.Write("<script>alert('未报价订单无法支付!');location.href='/Vshop/MemberInsuranceOrders.aspx'</script>"); HttpContext.Current.Response.End(); } string gateway = "hishop.plugins.payment.weixinrequest"; int PaymentTypeId = 88; this.Page.Request.Url.ToString().ToLower(); int num3 = Globals.RequestQueryNum("IsAlipay"); string userAgent = this.Page.Request.UserAgent; if (((num3 == 1) || !userAgent.ToLower().Contains("micromessenger")) || (string.IsNullOrEmpty(gateway) || !(gateway == "hishop.plugins.payment.ws_wappay.wswappayrequest"))) { if (!string.IsNullOrEmpty(gateway) && (gateway == "hishop.plugins.payment.offlinerequest")) { this.litMessage = (Literal)this.FindControl("litMessage"); this.litMessage.SetWhenIsNotNull(SettingsManager.GetMasterSettings(false).OffLinePayContent); } this.litOPertorList = (Literal)this.FindControl("litOPertorList"); this.litOPertorList.Text = "<div class=\"btns mt20\"><a id=\"linkToDetail\" class=\"btn btn-default mr10\" role=\"button\">查看订单</a><a href=\"/Default.aspx\" class=\"btn btn-default\" role=\"button\">继续逛逛</a></div>"; if (!string.IsNullOrEmpty(gateway) && (gateway == "hishop.plugins.payment.weixinrequest")) { string str2 = "立即支付"; if ((num2 > 0M) && ((num - num2) > 0M)) { str2 = "还需支付 " + ((num - num2)).ToString("F2"); } this.litOPertorList.Text = "<div class=\"mt20\"><a href=\"/pay/wx_Submit.aspx?orderId=" + this.orderId + "\" class=\"btn btn-danger\" role=\"button\" id=\"btnToPay\">" + str2 + "</a></div>"; } if (((!string.IsNullOrEmpty(gateway) && (gateway != "hishop.plugins.payment.podrequest")) && ((gateway != "hishop.plugins.payment.offlinerequest") && (gateway != "hishop.plugins.payment.weixinrequest"))) && (((gateway != "hishop.plugins.payment.balancepayrequest") && (gateway != "hishop.plugins.payment.pointtocach")) && (gateway != "hishop.plugins.payment.coupontocach"))) { PaymentModeInfo paymentMode = ShoppingProcessor.GetPaymentMode(PaymentTypeId); string attach = ""; string showUrl = string.Format("http://{0}/vshop/", HttpContext.Current.Request.Url.Host); PaymentRequest.CreateInstance(paymentMode.Gateway, HiCryptographer.Decrypt(paymentMode.Settings), this.orderId, num - num2, "订单支付", "订单号-" + this.orderId, "*****@*****.**", info.InsuranceOrderCreatDate.Value, showUrl, Globals.FullPath("/pay/PaymentReturn_url.aspx"), Globals.FullPath("/pay/PaymentNotify_url.aspx"), attach).SendRequest(); } else { this.litOrderId = (Literal)this.FindControl("litOrderId"); this.litOrderTotal = (Literal)this.FindControl("litOrderTotal"); this.literalOrderTotal = (Literal)this.FindControl("literalOrderTotal"); this.literalBalancePayInfo = (Literal)this.FindControl("literalBalancePayInfo"); this.litPaymentType = (HtmlInputHidden)this.FindControl("litPaymentType"); int result = 0; this.litPaymentType.SetWhenIsNotNull("0"); if (int.TryParse(this.Page.Request.QueryString["PaymentType"], out result)) { this.litPaymentType.SetWhenIsNotNull(result.ToString()); } this.litOrderId.SetWhenIsNotNull(this.orderId); if (flag) { this.litOrderTotal.SetWhenIsNotNull("您需要支付:\x00a5" + num.ToString("F2")); } this.literalOrderTotal.SetWhenIsNotNull("订单金额:<span style='color:red'>\x00a5" + num.ToString("F2") + "</span>"); if (num2 > 0M) { this.literalBalancePayInfo.Text = "<div class='font-xl'>余额已支付:<span style='color:red'>\x00a5" + num2.ToString("F2") + "</span></div>"; } this.litHelperText = (Literal)this.FindControl("litHelperText"); SiteSettings masterSettings = SettingsManager.GetMasterSettings(false); this.litHelperText.SetWhenIsNotNull(masterSettings.OffLinePayContent); PageTitle.AddSiteNameTitle("下单成功"); } } else { this.Page.Response.Redirect("/Pay/IframeAlipay.aspx?OrderId=" + this.orderId); } }
private void LoadMemberInfo() { insurance = dao.GetModel(this.currentUserId); this.dropCashBackTypes.SelectedValue = insurance.InsuranceOrderStatu; if (insurance == null) { base.GotoResourceNotFound(); } else { if (Request.Params["ctl00$ContentPlaceHolder1$dropCashBackTypes"] != null) { if (insurance.InsuranceOrderStatu != int.Parse(Request.Params["ctl00$ContentPlaceHolder1$dropCashBackTypes"])) { int tmpstatus = int.Parse(Request.Params["ctl00$ContentPlaceHolder1$dropCashBackTypes"]); insurance.InsuranceOrderStatu = tmpstatus; if (tmpstatus == 2) { int JiaoQiangXian = 0, ShangYeSanXian = 0, SiJiXian = 0, ChengKeXian = 0, SunShiXian = 0, DaoQiangXian = 0, BoliXian = 0, ZiRanXian = 0, SheShuiXian = 0, TeYueXian = 0, SanFangZenRenXian = 0, HuaHenXian = 0; if (Request.Params["JiaoQiangXian"] != null) { JiaoQiangXian = int.Parse(Request.Params["JiaoQiangXian"]); insurance.InsuranceOrderJiaoQiangXian = "1" + "|" + int.Parse(Request.Params["JiaoQiangXian"]).ToString(); } if (Request.Params["ShangYeSanXian"] != null) { ShangYeSanXian = int.Parse(Request.Params["ShangYeSanXian"]); insurance.InsuranceOrderShangYeSanXian = "1" + "|" + int.Parse(Request.Params["ShangYeSanXian"]).ToString(); } if (Request.Params["SiJiXian"] != null) { SiJiXian = int.Parse(Request.Params["SiJiXian"]); insurance.InsuranceOrderCheShangRenYuanSiJiXian = "1" + "|" + int.Parse(Request.Params["SiJiXian"]).ToString(); } if (Request.Params["ChengKeXian"] != null) { ChengKeXian = int.Parse(Request.Params["ChengKeXian"]); insurance.InsuranceOrderCheShangRenYuanChengKeXian = "1" + "|" + int.Parse(Request.Params["ChengKeXian"]).ToString(); } if (Request.Params["SunShiXian"] != null) { SunShiXian = int.Parse(Request.Params["SunShiXian"]); insurance.InsuranceOrderCheLiangSunShiXian = "1" + "|" + int.Parse(Request.Params["SunShiXian"]).ToString(); } if (Request.Params["DaoQiangXian"] != null) { DaoQiangXian = int.Parse(Request.Params["DaoQiangXian"]); insurance.InsuranceOrderDaoQiangXian = "1" + "|" + int.Parse(Request.Params["DaoQiangXian"]).ToString(); } if (Request.Params["BoliXian"] != null) { BoliXian = int.Parse(Request.Params["BoliXian"]); insurance.InsuranceOrderBoliXian = "1" + "|" + int.Parse(Request.Params["BoliXian"]).ToString(); } if (Request.Params["ZiRanXian"] != null) { ZiRanXian = int.Parse(Request.Params["ZiRanXian"]); insurance.InsuranceOrderZiRanXian = "1" + "|" + int.Parse(Request.Params["ZiRanXian"]).ToString(); } if (Request.Params["SheShuiXian"] != null) { SheShuiXian = int.Parse(Request.Params["SheShuiXian"]); insurance.InsuranceOrderSheShuiXian = "1" + "|" + int.Parse(Request.Params["SheShuiXian"]).ToString(); } if (Request.Params["TeYueXian"] != null) { TeYueXian = int.Parse(Request.Params["TeYueXian"]); insurance.InsuranceOrderTeYueXian = "1" + "|" + int.Parse(Request.Params["TeYueXian"]).ToString(); } if (Request.Params["SanFangZenRenXian"] != null) { SanFangZenRenXian = int.Parse(Request.Params["SanFangZenRenXian"]); insurance.InsuranceOrderSanFangZenRenXian = "1" + "|" + int.Parse(Request.Params["SanFangZenRenXian"]).ToString(); } if (Request.Params["HuaHenXian"] != null) { HuaHenXian = int.Parse(Request.Params["HuaHenXian"]); insurance.InsuranceOrderHuaHenXian = "1" + "|" + int.Parse(Request.Params["HuaHenXian"]).ToString(); } insurance.InsuranceOrderAmount = JiaoQiangXian + ShangYeSanXian + SiJiXian + ChengKeXian + SunShiXian + DaoQiangXian + BoliXian + ZiRanXian + SheShuiXian + TeYueXian + SanFangZenRenXian + HuaHenXian; //新增一个订单表 OrderTmpInfo order = new OrderTmpInfo(); order.OrderId = this.GenerateOrderId(); order.OrderMarking = this.GenerateOrderId(); order.OrderDate = DateTime.Now; order.UserId = 0; order.Username = ""; order.OrderStatus = 1; order.PointToCash = 0; order.PointExchange = 0; order.SplitState = 0; order.DeleteBeforeState = 0; order.ClientShortType = 1; order.BargainDetialId = 0; order.BalancePayMoneyTotal = 0; order.BalancePayFreightMoneyTotal = 0; order.CouponFreightMoneyTotal = 0; order.UpdateDate = DateTime.Now; order.LogisticsTools = 1; order.Amount = order.OrderTotal = insurance.InsuranceOrderAmount; order.Gateway = "hishop.plugins.payment.weixinrequest"; order.CouponCode = insurance.InsuranceOrderId.ToString(); order.PaymentTypeId = 88; bool num17 = new OrderDao().Add(order); } if (dao.Update(insurance)) { string content = Request.Params["msgcontent"]; string ordernum = insurance.InsuranceOrderCreatDate.Value.ToString("yyyyMMddHHmmss") + insurance.InsuranceOrderId; string orderstatus = ((Hidistro.Entities.Insurance.InsuranceOrderTypes)insurance.InsuranceOrderStatu.Value).ToString(); Messenger.SendWeiXinMsg_InsuranceOrder(insurance.InsuranceOrderOpenId, ordernum, orderstatus, content); ifsuc = "1"; } else { ifsuc = "2"; } } } } }
public static bool UserPayOrder(OrderInfo order) { OrderDao dao = new OrderDao(); order.OrderStatus = OrderStatus.BuyerAlreadyPaid; order.PayDate = new DateTime?(DateTime.Now); bool flag = dao.UpdateOrder(order, null); string str = ""; Globals.Debuglog("调用付款:" + order.OrderId + ",成功否:" + flag.ToString() + ",order.UserId:" + order.UserId.ToString(), "_DebuglogPaymentTest.txt"); if (flag) { if (order.UserId == 0) { //更新保险订单状态 if (order.CouponCode != "") { InsuranceDao daoid = new InsuranceDao(); InsuranceOrderInfo insurance = daoid.GetModel(Convert.ToInt32(order.CouponCode)); insurance.InsuranceOrderStatu = 3; daoid.Update(insurance); } try { Messenger.SendWeiXinMsg_OrderPay(order); } catch { } } else { dao.UpdatePayOrderStock(order); SettingsManager.GetMasterSettings(true); MemberInfo member = GetMember(order.UserId, true); if (VshopBrowser.IsPassAutoToDistributor(member, true)) { DistributorsBrower.MemberAutoToDistributor(member); } new MemberDao().SetOrderDate(order.UserId, 1); foreach (LineItemInfo info2 in order.LineItems.Values) { ProductDao dao2 = new ProductDao(); str = str + "'" + info2.SkuId + "',"; ProductInfo productDetails = dao2.GetProductDetails(info2.ProductId); productDetails.SaleCounts += info2.Quantity; productDetails.ShowSaleCounts += info2.Quantity; dao2.UpdateProduct(productDetails, null); } if (!string.IsNullOrEmpty(str)) { dao.UpdateItemsStatus(order.OrderId, 2, str.Substring(0, str.Length - 1)); } if (!string.IsNullOrEmpty(order.ActivitiesId)) { new ActivitiesDao().UpdateActivitiesTakeEffect(order.ActivitiesId); } if (member == null) { return(flag); } Globals.Debuglog("发微信消息:" + order.OrderId + ",成功:" + flag.ToString() + ",order.UserId:" + order.UserId.ToString(), "_DebuglogPaymentTest.txt"); try { Messenger.SendWeiXinMsg_OrderPay(order); } catch { } } } return(flag); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(InsuranceOrderInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Hishop_InsuranceOrder("); strSql.Append("InsuranceOrderCity1,InsuranceOrderCity1Name,InsuranceOrderCity2,InsuranceOrderCity2Name,InsuranceOrderCompany,InsuranceOrderCompany_Name,InsuranceOrderJiaoQiangXian,InsuranceOrderShangYeSanXian,InsuranceOrderShangYeSanXianEr,InsuranceOrderCheShangRenYuanSiJiXian,InsuranceOrderCheShangRenYuanSiJiXianEr,InsuranceOrderCheShangRenYuanChengKeXian,InsuranceOrderCheShangRenYuanChengKeXianEr,InsuranceOrderCheLiangSunShiXian,InsuranceOrderDaoQiangXian,InsuranceOrderBoliXian,InsuranceOrderZiRanXian,InsuranceOrderSheShuiXian,InsuranceOrderTeYueXian,InsuranceOrderSanFangZenRenXian,InsuranceOrderHuaHenXian,InsuranceOrderCarType,InsuranceOrderJiaoZhaoZhengBen,InsuranceOrderJiaoZhaoFuBen,InsuranceOrderName,InsuranceOrderTel,InsuranceOrderCardZheng,InsuranceOrderCardFan,InsuranceOrderAddres,InsuranceOrderShouJIanName,InsuranceOrderShouJIanTel,InsuranceOrderStatu,InsuranceOrderAmount,InsuranceOrderNotes,InsuranceUserId,InsuranceOrderOpenId,InsuranceOrderCreatDate,InsuranceOrderUpdateDate,InsuranceOrderIsRenewal)"); strSql.Append(" values ("); strSql.Append("@InsuranceOrderCity1,@InsuranceOrderCity1Name,@InsuranceOrderCity2,@InsuranceOrderCity2Name,@InsuranceOrderCompany,@InsuranceOrderCompany_Name,@InsuranceOrderJiaoQiangXian,@InsuranceOrderShangYeSanXian,@InsuranceOrderShangYeSanXianEr,@InsuranceOrderCheShangRenYuanSiJiXian,@InsuranceOrderCheShangRenYuanSiJiXianEr,@InsuranceOrderCheShangRenYuanChengKeXian,@InsuranceOrderCheShangRenYuanChengKeXianEr,@InsuranceOrderCheLiangSunShiXian,@InsuranceOrderDaoQiangXian,@InsuranceOrderBoliXian,@InsuranceOrderZiRanXian,@InsuranceOrderSheShuiXian,@InsuranceOrderTeYueXian,@InsuranceOrderSanFangZenRenXian,@InsuranceOrderHuaHenXian,@InsuranceOrderCarType,@InsuranceOrderJiaoZhaoZhengBen,@InsuranceOrderJiaoZhaoFuBen,@InsuranceOrderName,@InsuranceOrderTel,@InsuranceOrderCardZheng,@InsuranceOrderCardFan,@InsuranceOrderAddres,@InsuranceOrderShouJIanName,@InsuranceOrderShouJIanTel,@InsuranceOrderStatu,@InsuranceOrderAmount,@InsuranceOrderNotes,@InsuranceUserId,@InsuranceOrderOpenId,@InsuranceOrderCreatDate,@InsuranceOrderUpdateDate,@InsuranceOrderIsRenewal)"); strSql.Append(";select @@IDENTITY"); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "InsuranceOrderCity1", DbType.Int32, model.InsuranceOrderCity1); db.AddInParameter(dbCommand, "InsuranceOrderCity1Name", DbType.String, model.InsuranceOrderCity1Name); db.AddInParameter(dbCommand, "InsuranceOrderCity2", DbType.Int32, model.InsuranceOrderCity2); db.AddInParameter(dbCommand, "InsuranceOrderCity2Name", DbType.String, model.InsuranceOrderCity2Name); db.AddInParameter(dbCommand, "InsuranceOrderCompany", DbType.Int32, model.InsuranceOrderCompany); db.AddInParameter(dbCommand, "InsuranceOrderCompany_Name", DbType.String, model.InsuranceOrderCompany_Name); db.AddInParameter(dbCommand, "InsuranceOrderJiaoQiangXian", DbType.String, model.InsuranceOrderJiaoQiangXian); db.AddInParameter(dbCommand, "InsuranceOrderShangYeSanXian", DbType.String, model.InsuranceOrderShangYeSanXian); db.AddInParameter(dbCommand, "InsuranceOrderShangYeSanXianEr", DbType.String, model.InsuranceOrderShangYeSanXianEr); db.AddInParameter(dbCommand, "InsuranceOrderCheShangRenYuanSiJiXian", DbType.String, model.InsuranceOrderCheShangRenYuanSiJiXian); db.AddInParameter(dbCommand, "InsuranceOrderCheShangRenYuanSiJiXianEr", DbType.String, model.InsuranceOrderCheShangRenYuanSiJiXianEr); db.AddInParameter(dbCommand, "InsuranceOrderCheShangRenYuanChengKeXian", DbType.String, model.InsuranceOrderCheShangRenYuanChengKeXian); db.AddInParameter(dbCommand, "InsuranceOrderCheShangRenYuanChengKeXianEr", DbType.String, model.InsuranceOrderCheShangRenYuanChengKeXianEr); db.AddInParameter(dbCommand, "InsuranceOrderCheLiangSunShiXian", DbType.String, model.InsuranceOrderCheLiangSunShiXian); db.AddInParameter(dbCommand, "InsuranceOrderDaoQiangXian", DbType.String, model.InsuranceOrderDaoQiangXian); db.AddInParameter(dbCommand, "InsuranceOrderBoliXian", DbType.String, model.InsuranceOrderBoliXian); db.AddInParameter(dbCommand, "InsuranceOrderZiRanXian", DbType.String, model.InsuranceOrderZiRanXian); db.AddInParameter(dbCommand, "InsuranceOrderSheShuiXian", DbType.String, model.InsuranceOrderSheShuiXian); db.AddInParameter(dbCommand, "InsuranceOrderTeYueXian", DbType.String, model.InsuranceOrderTeYueXian); db.AddInParameter(dbCommand, "InsuranceOrderSanFangZenRenXian", DbType.String, model.InsuranceOrderSanFangZenRenXian); db.AddInParameter(dbCommand, "InsuranceOrderHuaHenXian", DbType.String, model.InsuranceOrderHuaHenXian); db.AddInParameter(dbCommand, "InsuranceOrderCarType", DbType.Int32, model.InsuranceOrderCarType); db.AddInParameter(dbCommand, "InsuranceOrderJiaoZhaoZhengBen", DbType.String, model.InsuranceOrderJiaoZhaoZhengBen); db.AddInParameter(dbCommand, "InsuranceOrderJiaoZhaoFuBen", DbType.String, model.InsuranceOrderJiaoZhaoFuBen); db.AddInParameter(dbCommand, "InsuranceOrderName", DbType.String, model.InsuranceOrderName); db.AddInParameter(dbCommand, "InsuranceOrderTel", DbType.String, model.InsuranceOrderTel); db.AddInParameter(dbCommand, "InsuranceOrderCardZheng", DbType.String, model.InsuranceOrderCardZheng); db.AddInParameter(dbCommand, "InsuranceOrderCardFan", DbType.String, model.InsuranceOrderCardFan); db.AddInParameter(dbCommand, "InsuranceOrderAddres", DbType.String, model.InsuranceOrderAddres); db.AddInParameter(dbCommand, "InsuranceOrderShouJIanName", DbType.String, model.InsuranceOrderShouJIanName); db.AddInParameter(dbCommand, "InsuranceOrderShouJIanTel", DbType.String, model.InsuranceOrderShouJIanTel); db.AddInParameter(dbCommand, "InsuranceOrderStatu", DbType.Int32, model.InsuranceOrderStatu); db.AddInParameter(dbCommand, "InsuranceOrderAmount", DbType.Decimal, model.InsuranceOrderAmount); db.AddInParameter(dbCommand, "InsuranceOrderNotes", DbType.String, model.InsuranceOrderNotes); db.AddInParameter(dbCommand, "InsuranceUserId", DbType.Int32, model.InsuranceUserId); db.AddInParameter(dbCommand, "InsuranceOrderOpenId", DbType.String, model.InsuranceOrderOpenId); db.AddInParameter(dbCommand, "InsuranceOrderCreatDate", DbType.String, model.InsuranceOrderCreatDate); db.AddInParameter(dbCommand, "InsuranceOrderUpdateDate", DbType.String, model.InsuranceOrderUpdateDate); db.AddInParameter(dbCommand, "InsuranceOrderIsRenewal", DbType.Int32, model.InsuranceOrderIsRenewal); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(InsuranceOrderInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Hishop_InsuranceOrder set "); strSql.Append("InsuranceOrderCity1=@InsuranceOrderCity1,"); strSql.Append("InsuranceOrderCity1Name=@InsuranceOrderCity1Name,"); strSql.Append("InsuranceOrderCity2=@InsuranceOrderCity2,"); strSql.Append("InsuranceOrderCity2Name=@InsuranceOrderCity2Name,"); strSql.Append("InsuranceOrderCompany=@InsuranceOrderCompany,"); strSql.Append("InsuranceOrderCompany_Name=@InsuranceOrderCompany_Name,"); strSql.Append("InsuranceOrderJiaoQiangXian=@InsuranceOrderJiaoQiangXian,"); strSql.Append("InsuranceOrderShangYeSanXian=@InsuranceOrderShangYeSanXian,"); strSql.Append("InsuranceOrderShangYeSanXianEr=@InsuranceOrderShangYeSanXianEr,"); strSql.Append("InsuranceOrderCheShangRenYuanSiJiXian=@InsuranceOrderCheShangRenYuanSiJiXian,"); strSql.Append("InsuranceOrderCheShangRenYuanSiJiXianEr=@InsuranceOrderCheShangRenYuanSiJiXianEr,"); strSql.Append("InsuranceOrderCheShangRenYuanChengKeXian=@InsuranceOrderCheShangRenYuanChengKeXian,"); strSql.Append("InsuranceOrderCheShangRenYuanChengKeXianEr=@InsuranceOrderCheShangRenYuanChengKeXianEr,"); strSql.Append("InsuranceOrderCheLiangSunShiXian=@InsuranceOrderCheLiangSunShiXian,"); strSql.Append("InsuranceOrderDaoQiangXian=@InsuranceOrderDaoQiangXian,"); strSql.Append("InsuranceOrderBoliXian=@InsuranceOrderBoliXian,"); strSql.Append("InsuranceOrderZiRanXian=@InsuranceOrderZiRanXian,"); strSql.Append("InsuranceOrderSheShuiXian=@InsuranceOrderSheShuiXian,"); strSql.Append("InsuranceOrderTeYueXian=@InsuranceOrderTeYueXian,"); strSql.Append("InsuranceOrderSanFangZenRenXian=@InsuranceOrderSanFangZenRenXian,"); strSql.Append("InsuranceOrderHuaHenXian=@InsuranceOrderHuaHenXian,"); strSql.Append("InsuranceOrderCarType=@InsuranceOrderCarType,"); strSql.Append("InsuranceOrderJiaoZhaoZhengBen=@InsuranceOrderJiaoZhaoZhengBen,"); strSql.Append("InsuranceOrderJiaoZhaoFuBen=@InsuranceOrderJiaoZhaoFuBen,"); strSql.Append("InsuranceOrderName=@InsuranceOrderName,"); strSql.Append("InsuranceOrderTel=@InsuranceOrderTel,"); strSql.Append("InsuranceOrderCardZheng=@InsuranceOrderCardZheng,"); strSql.Append("InsuranceOrderCardFan=@InsuranceOrderCardFan,"); strSql.Append("InsuranceOrderAddres=@InsuranceOrderAddres,"); strSql.Append("InsuranceOrderShouJIanName=@InsuranceOrderShouJIanName,"); strSql.Append("InsuranceOrderShouJIanTel=@InsuranceOrderShouJIanTel,"); strSql.Append("InsuranceOrderStatu=@InsuranceOrderStatu,"); strSql.Append("InsuranceOrderAmount=@InsuranceOrderAmount,"); strSql.Append("InsuranceOrderNotes=@InsuranceOrderNotes,"); strSql.Append("InsuranceUserId=@InsuranceUserId,"); strSql.Append("InsuranceOrderOpenId=@InsuranceOrderOpenId,"); strSql.Append("InsuranceOrderCreatDate=@InsuranceOrderCreatDate,"); strSql.Append("InsuranceOrderUpdateDate=@InsuranceOrderUpdateDate,"); strSql.Append("InsuranceOrderIsRenewal=@InsuranceOrderIsRenewal"); strSql.Append(" where InsuranceOrderId=@InsuranceOrderId "); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "InsuranceOrderId", DbType.Int32, model.InsuranceOrderId); db.AddInParameter(dbCommand, "InsuranceOrderCity1", DbType.Int32, model.InsuranceOrderCity1); db.AddInParameter(dbCommand, "InsuranceOrderCity1Name", DbType.String, model.InsuranceOrderCity1Name); db.AddInParameter(dbCommand, "InsuranceOrderCity2", DbType.Int32, model.InsuranceOrderCity2); db.AddInParameter(dbCommand, "InsuranceOrderCity2Name", DbType.String, model.InsuranceOrderCity2Name); db.AddInParameter(dbCommand, "InsuranceOrderCompany", DbType.Int32, model.InsuranceOrderCompany); db.AddInParameter(dbCommand, "InsuranceOrderCompany_Name", DbType.String, model.InsuranceOrderCompany_Name); db.AddInParameter(dbCommand, "InsuranceOrderJiaoQiangXian", DbType.String, model.InsuranceOrderJiaoQiangXian); db.AddInParameter(dbCommand, "InsuranceOrderShangYeSanXian", DbType.String, model.InsuranceOrderShangYeSanXian); db.AddInParameter(dbCommand, "InsuranceOrderShangYeSanXianEr", DbType.String, model.InsuranceOrderShangYeSanXianEr); db.AddInParameter(dbCommand, "InsuranceOrderCheShangRenYuanSiJiXian", DbType.String, model.InsuranceOrderCheShangRenYuanSiJiXian); db.AddInParameter(dbCommand, "InsuranceOrderCheShangRenYuanSiJiXianEr", DbType.String, model.InsuranceOrderCheShangRenYuanSiJiXianEr); db.AddInParameter(dbCommand, "InsuranceOrderCheShangRenYuanChengKeXian", DbType.String, model.InsuranceOrderCheShangRenYuanChengKeXian); db.AddInParameter(dbCommand, "InsuranceOrderCheShangRenYuanChengKeXianEr", DbType.String, model.InsuranceOrderCheShangRenYuanChengKeXianEr); db.AddInParameter(dbCommand, "InsuranceOrderCheLiangSunShiXian", DbType.String, model.InsuranceOrderCheLiangSunShiXian); db.AddInParameter(dbCommand, "InsuranceOrderDaoQiangXian", DbType.String, model.InsuranceOrderDaoQiangXian); db.AddInParameter(dbCommand, "InsuranceOrderBoliXian", DbType.String, model.InsuranceOrderBoliXian); db.AddInParameter(dbCommand, "InsuranceOrderZiRanXian", DbType.String, model.InsuranceOrderZiRanXian); db.AddInParameter(dbCommand, "InsuranceOrderSheShuiXian", DbType.String, model.InsuranceOrderSheShuiXian); db.AddInParameter(dbCommand, "InsuranceOrderTeYueXian", DbType.String, model.InsuranceOrderTeYueXian); db.AddInParameter(dbCommand, "InsuranceOrderSanFangZenRenXian", DbType.String, model.InsuranceOrderSanFangZenRenXian); db.AddInParameter(dbCommand, "InsuranceOrderHuaHenXian", DbType.String, model.InsuranceOrderHuaHenXian); db.AddInParameter(dbCommand, "InsuranceOrderCarType", DbType.Int32, model.InsuranceOrderCarType); db.AddInParameter(dbCommand, "InsuranceOrderJiaoZhaoZhengBen", DbType.String, model.InsuranceOrderJiaoZhaoZhengBen); db.AddInParameter(dbCommand, "InsuranceOrderJiaoZhaoFuBen", DbType.String, model.InsuranceOrderJiaoZhaoFuBen); db.AddInParameter(dbCommand, "InsuranceOrderName", DbType.String, model.InsuranceOrderName); db.AddInParameter(dbCommand, "InsuranceOrderTel", DbType.String, model.InsuranceOrderTel); db.AddInParameter(dbCommand, "InsuranceOrderCardZheng", DbType.String, model.InsuranceOrderCardZheng); db.AddInParameter(dbCommand, "InsuranceOrderCardFan", DbType.String, model.InsuranceOrderCardFan); db.AddInParameter(dbCommand, "InsuranceOrderAddres", DbType.String, model.InsuranceOrderAddres); db.AddInParameter(dbCommand, "InsuranceOrderShouJIanName", DbType.String, model.InsuranceOrderShouJIanName); db.AddInParameter(dbCommand, "InsuranceOrderShouJIanTel", DbType.String, model.InsuranceOrderShouJIanTel); db.AddInParameter(dbCommand, "InsuranceOrderStatu", DbType.Int32, model.InsuranceOrderStatu); db.AddInParameter(dbCommand, "InsuranceOrderAmount", DbType.Decimal, model.InsuranceOrderAmount); db.AddInParameter(dbCommand, "InsuranceOrderNotes", DbType.String, model.InsuranceOrderNotes); db.AddInParameter(dbCommand, "InsuranceUserId", DbType.Int32, model.InsuranceUserId); db.AddInParameter(dbCommand, "InsuranceOrderOpenId", DbType.String, model.InsuranceOrderOpenId); db.AddInParameter(dbCommand, "InsuranceOrderCreatDate", DbType.String, model.InsuranceOrderCreatDate); db.AddInParameter(dbCommand, "InsuranceOrderUpdateDate", DbType.String, model.InsuranceOrderUpdateDate); db.AddInParameter(dbCommand, "InsuranceOrderIsRenewal", DbType.Int32, model.InsuranceOrderIsRenewal); int rows = db.ExecuteNonQuery(dbCommand); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 对象实体绑定数据 /// </summary> public InsuranceOrderInfo ReaderBind(IDataReader dataReader) { InsuranceOrderInfo model = new InsuranceOrderInfo(); object ojb; ojb = dataReader["InsuranceOrderId"]; if (ojb != null && ojb != DBNull.Value) { model.InsuranceOrderId = (int)ojb; } ojb = dataReader["InsuranceOrderCity1"]; if (ojb != null && ojb != DBNull.Value) { model.InsuranceOrderCity1 = (int)ojb; } model.InsuranceOrderCity1Name = dataReader["InsuranceOrderCity1Name"].ToString(); ojb = dataReader["InsuranceOrderCity2"]; if (ojb != null && ojb != DBNull.Value) { model.InsuranceOrderCity2 = (int)ojb; } model.InsuranceOrderCity2Name = dataReader["InsuranceOrderCity2Name"].ToString(); ojb = dataReader["InsuranceOrderCompany"]; if (ojb != null && ojb != DBNull.Value) { model.InsuranceOrderCompany = (int)ojb; } model.InsuranceOrderCompany_Name = dataReader["InsuranceOrderCompany_Name"].ToString(); model.InsuranceOrderJiaoQiangXian = dataReader["InsuranceOrderJiaoQiangXian"].ToString(); model.InsuranceOrderShangYeSanXian = dataReader["InsuranceOrderShangYeSanXian"].ToString(); model.InsuranceOrderShangYeSanXianEr = dataReader["InsuranceOrderShangYeSanXianEr"].ToString(); model.InsuranceOrderCheShangRenYuanSiJiXian = dataReader["InsuranceOrderCheShangRenYuanSiJiXian"].ToString(); model.InsuranceOrderCheShangRenYuanSiJiXianEr = dataReader["InsuranceOrderCheShangRenYuanSiJiXianEr"].ToString(); model.InsuranceOrderCheShangRenYuanChengKeXian = dataReader["InsuranceOrderCheShangRenYuanChengKeXian"].ToString(); model.InsuranceOrderCheShangRenYuanChengKeXianEr = dataReader["InsuranceOrderCheShangRenYuanChengKeXianEr"].ToString(); model.InsuranceOrderCheLiangSunShiXian = dataReader["InsuranceOrderCheLiangSunShiXian"].ToString(); model.InsuranceOrderDaoQiangXian = dataReader["InsuranceOrderDaoQiangXian"].ToString(); model.InsuranceOrderBoliXian = dataReader["InsuranceOrderBoliXian"].ToString(); model.InsuranceOrderZiRanXian = dataReader["InsuranceOrderZiRanXian"].ToString(); model.InsuranceOrderSheShuiXian = dataReader["InsuranceOrderSheShuiXian"].ToString(); model.InsuranceOrderTeYueXian = dataReader["InsuranceOrderTeYueXian"].ToString(); model.InsuranceOrderSanFangZenRenXian = dataReader["InsuranceOrderSanFangZenRenXian"].ToString(); model.InsuranceOrderHuaHenXian = dataReader["InsuranceOrderHuaHenXian"].ToString(); ojb = dataReader["InsuranceOrderCarType"]; if (ojb != null && ojb != DBNull.Value) { model.InsuranceOrderCarType = (int)ojb; } model.InsuranceOrderJiaoZhaoZhengBen = dataReader["InsuranceOrderJiaoZhaoZhengBen"].ToString(); model.InsuranceOrderJiaoZhaoFuBen = dataReader["InsuranceOrderJiaoZhaoFuBen"].ToString(); model.InsuranceOrderName = dataReader["InsuranceOrderName"].ToString(); model.InsuranceOrderTel = dataReader["InsuranceOrderTel"].ToString(); model.InsuranceOrderCardZheng = dataReader["InsuranceOrderCardZheng"].ToString(); model.InsuranceOrderCardFan = dataReader["InsuranceOrderCardFan"].ToString(); model.InsuranceOrderAddres = dataReader["InsuranceOrderAddres"].ToString(); model.InsuranceOrderShouJIanName = dataReader["InsuranceOrderShouJIanName"].ToString(); model.InsuranceOrderShouJIanTel = dataReader["InsuranceOrderShouJIanTel"].ToString(); ojb = dataReader["InsuranceOrderStatu"]; if (ojb != null && ojb != DBNull.Value) { model.InsuranceOrderStatu = (int)ojb; } ojb = dataReader["InsuranceOrderAmount"]; if (ojb != null && ojb != DBNull.Value) { model.InsuranceOrderAmount = (decimal)ojb; } model.InsuranceOrderNotes = dataReader["InsuranceOrderNotes"].ToString(); ojb = dataReader["InsuranceUserId"]; if (ojb != null && ojb != DBNull.Value) { model.InsuranceUserId = (int)ojb; } model.InsuranceOrderOpenId = dataReader["InsuranceOrderOpenId"].ToString(); ojb = dataReader["InsuranceOrderCreatDate"]; if (ojb != null && ojb != DBNull.Value) { model.InsuranceOrderCreatDate = (DateTime)ojb; } ojb = dataReader["InsuranceOrderUpdateDate"]; if (ojb != null && ojb != DBNull.Value) { model.InsuranceOrderUpdateDate = (DateTime)ojb; } ojb = dataReader["InsuranceOrderIsRenewal"]; if (ojb != null && ojb != DBNull.Value) { model.InsuranceOrderIsRenewal = (int)ojb; } return(model); }