public void Execute(IJobExecutionContext context)
{
// string path = System.Environment.CurrentDirectory; // MapPath("/App_Data/selfsetting.xml");
HttpContext http = HttpContext.Current;
string path = System.IO.Path.Combine(HttpRuntime.AppDomainAppPath, "App_Data/selfsetting.xml");
XmlDocument xmldoc = new XmlDocument();
// string path = System.AppDomain.CurrentDomain.BaseDirectory.ToString()+ "App_Data/selfsetting.xml";
xmldoc.Load(path);
string time = xmldoc.SelectSingleNode("root").SelectSingleNode("daorutime").Attributes[0].Value;
string daorupath = xmldoc.SelectSingleNode("root").SelectSingleNode("daorudir").Attributes[0].Value;
string daorunowdate = xmldoc.SelectSingleNode("root").SelectSingleNode("daorunowdate").Attributes[0].Value;
var files = DirFileHelper.GetFileNames(daorupath);
if (files.Length > 0)
{
DataSet ds = ExportFile.ExcelSqlConnection(files[0], "Info"); //调用自定义方法
DataRow[] dr = ds.Tables[0].Select();
int successcount = 0;
int failcount = 0;
M_HitchInfoBll M_HitchInfoBll = new M_HitchInfoBll();
for (int i = 0; i < dr.Length; i++)
{
try
{
M_HitchInfo model = new M_HitchInfo();
model.AreaName = dr[0][0].ToString();
model.FactorySation = dr[i][1].ToString();
model.Signal = dr[i][2].ToString();
model.HappenTimes = int.Parse(dr[i][3].ToString());
model.SignalType = dr[i][4].ToString();
model.HappenTimes1 = int.Parse(dr[i][5].ToString());
model.MessageType = dr[i][6].ToString();
model.CreateUserId = 1;
model.CreateUserName = "******";
model.CreateTime = DateTime.Now.AddDays(int.Parse(daorunowdate));
if (M_HitchInfoBll.M_HitchInfoAdd(model) > 0)
{
successcount++;
}
else
{
failcount++;
}
}
catch (Exception)
{
failcount++;
}
}
for (int i = 0; i < files.Length; i++)
{
File.Delete(files[i]);
}
}
}
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> IntoClubActivityInfo()
{
C_ClubActivityInfoBll bll = new C_ClubActivityInfoBll();
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"); //调用自定义方法
log.Debug(ds.Tables[0].Rows.Count);
DataRow[] dr = ds.Tables[0].Select();
int successcount = 0;
int failcount = 0;
for (int i = 0; i < dr.Length; i++)
{
try
{
C_ClubActivityInfo model = new C_ClubActivityInfo();
model.ClubName = dr[i][0].ToString();
model.ClubActivityTypeId = int.Parse(dr[i][1].ToString());
model.ActivityDate = DateTime.Parse(dr[i][2].ToString());
model.ActivityCost = int.Parse(dr[i][3].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> LeadingInM_HitchInfo()
{
string datetime = HttpContext.Current.Request.Form["leadingindatetime"].ToString();
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
{
M_HitchInfo model = new M_HitchInfo();
model.AreaName = dr[0][0].ToString();
model.FactorySation = dr[i][1].ToString();
model.Signal = dr[i][2].ToString();
model.HappenTimes = int.Parse(dr[i][3].ToString());
model.SignalType = dr[i][4].ToString();
model.HappenTimes1 = int.Parse(dr[i][5].ToString());
model.MessageType = dr[i][6].ToString();
model.CreateUserId = 1;
model.CreateUserName = "******";
model.CreateTime = DateTime.Parse(datetime);
if (M_HitchInfoBll.M_HitchInfoAdd(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> IntoAgency()
{
T_AgencyBll bll = new T_AgencyBll();
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_Agency model = new T_Agency();
model.AgencyName = dr[i][0].ToString();
model.CreateUserId = ManageProvider.Provider.Current().UserId;
model.CreateUserName = ManageProvider.Provider.Current().Account;
model.CreateTime = DateTime.Now;
model.IsDelete = 0;
model.IsShow = 1;
model.SortCode = 0;
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 }
});
}