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 Dictionary <string, object> Del()
{
T_SaleActivityBll bll = new T_SaleActivityBll();
var idList = HttpContext.Current.Request.Form["idlist"].ToString();
int result = bll.UpdateAll(idList);
if (result > 0)
{
return(new Dictionary <string, object>
{
{ "code", 1 },
{ "result", result }
});
}
else
{
return(new Dictionary <string, object>
{
{ "code", 0 }
});
}
}
