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