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