/// <summary> /// 添加用户购买信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public async Task <bool> AddInsuranceBuyer(Temp_InsuranceBuyerInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Temp_InsuranceBuyerInfo("); strSql.Append("BuyerName,Gender,Relation,CreditNumber,Mobile,Email,CityName,SubmitDate,State,UpdateDate,UpdateUser,ProductCode,CarNo)"); strSql.Append(" values ("); strSql.Append("@BuyerName,@Gender,@Relation,@CreditNumber,@Mobile,@Email,@CityName,@SubmitDate,@State,@UpdateDate,@UpdateUser,@ProductCode,@CarNo)"); using (IDbConnection conn = new SqlConnection(ConfigurationSettings.GetConnectionString())) { var count = await conn.ExecuteAsync(strSql.ToString(), new { BuyerName = model.BuyerName, Gender = model.Gender, Relation = model.Relation, CreditNumber = model.CreditNumber, Mobile = model.Mobile, Email = model.Email, CityName = model.CityName, SubmitDate = model.SubmitDate, State = model.State, UpdateDate = model.UpdateDate, UpdateUser = model.UpdateUser, ProductCode = model.ProductCode, CarNo = model.CarNo }); return(count > 0); } }
public async Task <ActionResult> SubmitData() { string codeNo = Request["codeNo"]; if (TempData["Code"] == null || TempData["Code"].ToString() != codeNo) { return(Json(new { state = 100, msg = "验证码输入错误" }, JsonRequestBehavior.AllowGet)); } Temp_InsuranceBuyerInfo buyerInfo = new Temp_InsuranceBuyerInfo(); buyerInfo.BuyerName = Request["name"].Trim(); buyerInfo.Gender = Convert.ToInt32(Request["sex"]); buyerInfo.Relation = Request["relation"]; buyerInfo.CreditNumber = Request["No"].Trim(); buyerInfo.Mobile = Request["phone"].Trim(); buyerInfo.Email = Request["email"].Trim(); buyerInfo.CityName = Request["city"].Trim(); buyerInfo.ProductCode = Request["productCode"].Trim(); buyerInfo.SubmitDate = DateTime.Now; buyerInfo.UpdateDate = DateTime.Now; buyerInfo.State = 0; buyerInfo.UpdateUser = ""; buyerInfo.CarNo = Request["carNo"].Trim(); InsuranceBuyerInfoRepository _repo = new InsuranceBuyerInfoRepository(); bool result = await _repo.AddInsuranceBuyer(buyerInfo); if (result) { return(Json(new { state = 101, msg = "添加成功" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { state = 102, msg = "添加失败" }, JsonRequestBehavior.AllowGet)); } }