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