public Dictionary <string, object> IntoSalActivity() { T_SaleActivityBll bll = new T_SaleActivityBll(); string url = HttpContext.Current.Request.Form["url"].ToString(); string filename = HttpContext.Current.Request.Form["filename"].ToString(); DataSet ds = ExportFile.ExcelSqlConnection(HttpContext.Current.Server.MapPath(url), "Info"); //调用自定义方法 DataRow[] dr = ds.Tables[0].Select(); int successcount = 0; int failcount = 0; for (int i = 0; i < dr.Length; i++) { try { T_SaleActivity model = new T_SaleActivity(); model.AgencyId = int.Parse(dr[0][0].ToString()); model.AreaId = int.Parse(dr[i][1].ToString()); model.ActivityDate = DateTime.Parse(dr[i][2].ToString()); model.SaleActivityTypeId = int.Parse(dr[i][3].ToString()); model.PassengerFlow = int.Parse(dr[i][4].ToString()); model.LatentPassengerFlow = int.Parse(dr[i][5].ToString()); model.CarOwner = int.Parse(dr[i][6].ToString()); model.OrderQuantity = int.Parse(dr[i][7].ToString()); model.PrimeCost = int.Parse(dr[i][8].ToString()); model.LaterOrderQuantity = int.Parse(dr[i][9].ToString()); model.PublishWay = dr[i][10].ToString(); model.CreateUserId = ManageProvider.Provider.Current().UserId; model.CreateUserName = ManageProvider.Provider.Current().Account; model.CreateTime = DateTime.Now; model.IsDelete = 0; model.IsShow = 1; if (bll.Add(model) > 0) { successcount++; } else { failcount++; } } catch (Exception) { failcount++; } } return(new Dictionary <string, object> { { "code", "1" }, { "successcount", successcount }, { "failcount", failcount }, { "filename", filename }, { "count", dr.Length } }); }
public Dictionary <string, object> Add(T_SaleActivity model) { T_SaleActivityBll bll = new T_SaleActivityBll(); var RealPublishWay = HttpContext.Current.Request.Form["RealPublishWay"].ToString(); model.PublishWay = RealPublishWay; if (model.SaleActivityId > 0) { var oldmodel = bll.GetModel(model.SaleActivityId); model.CreateUserId = oldmodel.CreateUserId; model.CreateUserName = oldmodel.CreateUserName; model.CreateTime = oldmodel.CreateTime; model.PublishWay = RealPublishWay; if (bll.Update(model) > 0) { return(new Dictionary <string, object> { { "code", 1 } }); } else { return(new Dictionary <string, object> { { "code", 0 } }); } } else { model.CreateUserId = ManageProvider.Provider.Current().UserId; model.CreateUserName = ManageProvider.Provider.Current().Account; model.CreateTime = DateTime.Now; model.PublishWay = RealPublishWay; if (bll.Add(model) > 0) { return(new Dictionary <string, object> { { "code", 1 } }); } else { return(new Dictionary <string, object> { { "code", 0 } }); } } }
public ActionResult Add() { var model = new T_SaleActivity(); var bll = new T_SaleActivityBll(); if (Request.QueryString["SaleActivityId"] != null) { model = bll.GetModel(int.Parse(Request.QueryString["SaleActivityId"].ToString())); } else { model.IsShow = 1; } return(View(model)); }
public int Update(T_SaleActivity model) { return(T_SaleActivityDal.GetInstance().Update(model)); }
public int Add(T_SaleActivity model) { return(T_SaleActivityDal.GetInstance().Add(model)); }