public void InsertZhuanzi(List <PiaoFang> items, int page)
{
var dt = FITTHelper.Query("select * from " + tableName + " where 1!=1").Tables[0];
var dateNow = DateTime.Now;
foreach (var item in items)
{
var date = ConvertDataTime(item.businessDate);
DataRow dr = dt.NewRow();
dr["年"] = date.Year;
dr["月"] = date.Month;
dr["日"] = date.Day;
dr["影院名称"] = item.cinemaName;
dr["影院专资编码"] = item.cinemaCode;
dr["片名"] = item.filmName;
dr["场次"] = item.totalSession;
dr["人次"] = item.totalAudience;
dr["票房"] = item.totalBoxoffice;
dr["排场"] = "0";
dr["日期"] = date;
dr["当前页"] = page;
dr["省市"] = item.provinceName;
dr["影片编码"] = item.filmCode;
dt.Rows.Add(dr);
}
try
{
FITTHelper.BulkToDB(tableName, dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void InsertDB(params TongJiJuArea[] items)
{
var dt = FITTHelper.Query("select * from 地区行政区划表B where 1!=1").Tables[0];
var dateNow = DateTime.Now;
foreach (var item in items)
{
DataRow dr = dt.NewRow();
dr["地区代码"] = item.AreaCode;
dr["地区全称"] = item.AreaName;
dr["城乡分类"] = string.IsNullOrEmpty(item.TypeCode) ? "" : item.TypeCode;
dr["省"] = string.IsNullOrEmpty(item.Sheng) ? "" : item.Sheng;
dr["市"] = string.IsNullOrEmpty(item.Shi) ? "" : item.Shi;
dr["县"] = string.IsNullOrEmpty(item.Xian) ? "" : item.Xian;
dr["乡"] = string.IsNullOrEmpty(item.Xiang) ? "" : item.Xiang;
dr["村"] = string.IsNullOrEmpty(item.Chun) ? "" : item.Chun;
dt.Rows.Add(dr);
}
try
{
FITTHelper.BulkToDB("地区行政区划表B", dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void InsertZhuanzi(List <PiaoFangTing> items, int page)
{
var dt = FITTHelper.Query("select * from " + tableName + " where 1!=1").Tables[0];
var dateNow = DateTime.Now;
foreach (var item in items)
{
var date = ConvertDataTime(item.businessDate);
DataRow dr = dt.NewRow();
dr["省份"] = item.provinceName;
dr["所属院线"] = item.cinemaChainName;
dr["影院编码"] = item.cinemaCode;
dr["影院名称"] = item.cinemaName;
dr["场次编码"] = item.sessionCode;
dr["影片编码"] = item.filmCode;
dr["影片名称"] = item.filmName;
dr["发行版本"] = item.screenName;
dr["影厅编码"] = item.screenCode;
dr["放映日期"] = item.sessionDateTime;
dr["总人数"] = item.totalAudience;
dr["总票房"] = item.totalBoxOffice;
dt.Rows.Add(dr);
}
try
{
FITTHelper.BulkToDB(tableName, dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void InsertDB(List <YingYuan> items, int j)
{
var dt = FITTHelper.Query("select * from 影院专资表 where 1!=1").Tables[0];
var dateNow = DateTime.Now;
foreach (var item in items)
{
var date = ConvertDataTime(item.businessDate);
DataRow dr = dt.NewRow();
dr["影院编码"] = item.cinemaCode;
dr["省份"] = item.provinceName;
dr["影院简称"] = item.cinemaName;
dr["影院工商注册名称"] = item.officalName;
dr["所属院线"] = item.cinemaChainName;
dr["是否电脑售票"] = item.pcsell;
dr["售票软件名称"] = item.softwareName;
dr["营业状态"] = int.Parse(item.businessStatus.Trim());
dr["厅数"] = int.Parse(item.totalScreenCount.Trim());
dr["座位数"] = int.Parse(item.totalSeatCount.Trim());
dr["部数"] = int.Parse(item.totalFilm.Trim());
dr["场次"] = int.Parse(item.totalSession.Trim());
dr["人数"] = int.Parse(item.totalAudience.Trim());
dr["票房"] = decimal.Parse(item.totalBoxOffice.Trim());
dr["上报天数"] = int.Parse(item.reportDays.Trim());
dr["当前页"] = j;
dt.Rows.Add(dr);
}
try
{
FITTHelper.BulkToDB("影院专资表", dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
