private static string cell(ISheet isheet_0, int row_num, int cell_num) { string str; IRow row = isheet_0.GetRow(row_num); str = (row != null ? ExeclUtil.read_cell(row.GetCell(cell_num)) : ""); return(str); }
private static ArrayList query_header(ISheet isheet_0) { ArrayList arrayList_0 = new ArrayList(); int num = 0; while (true) { string str = ExeclUtil.cell(isheet_0, 0, num); if ((str == null ? true : "".Equals(str))) { break; } arrayList_0.Add(str); num++; } return(arrayList_0); }
public static bool smethod_0(string string_0, string string_1, ArrayList arrayList_1, out string string_2) { bool flag; HSSFWorkbook hSSFWorkbook = null; ArrayList arrayLists = new ArrayList(); try { try { FileStream fileStream = new FileStream(string_0, FileMode.Open, FileAccess.Read); hSSFWorkbook = new HSSFWorkbook(fileStream); ISheet sheetAt = hSSFWorkbook.GetSheetAt(0); int num = 1; //foreach (GClass30 arrayList1 in arrayList_1) //{ // ExeclUtil.set_cell(sheetAt, num, 0, arrayList1.string_0); // ExeclUtil.set_cell(sheetAt, num, 1, arrayList1.string_2); // ExeclUtil.set_cell(sheetAt, num, 2, arrayList1.string_3); // num++; //} if (File.Exists(string_1)) { File.Delete(string_1); } fileStream = new FileStream(string_1, FileMode.CreateNew, FileAccess.Write); hSSFWorkbook.Write(fileStream); fileStream.Flush(); fileStream.Close(); string_2 = ""; flag = true; } catch (Exception exception) { string_2 = exception.ToString(); flag = false; } } finally { ExeclUtil.close(hSSFWorkbook); } return(flag); }
public static void putOrder(CmsForm cmsForm) { ArrayList aliOrderList = ExeclUtil.query_order(cmsForm, cmsForm.appBean.taoke_cookie, 0); LogUtil.log_pid_call(cmsForm, "aliOrderList:" + aliOrderList.Count); if (aliOrderList.Count > 0) { //AliOrderUtil.submit_order_items(cmsForm, aliOrderList); AliOrderUtil.put_order_items(cmsForm, aliOrderList); } aliOrderList = ExeclUtil.query_order(cmsForm, cmsForm.appBean.taoke_cookie, 1); if (aliOrderList.Count > 0) { //AliOrderUtil.submit_order_items(cmsForm, aliOrderList); AliOrderUtil.put_order_items(cmsForm, aliOrderList); } aliOrderList = ExeclUtil.query_order(cmsForm, cmsForm.appBean.taoke_cookie, 2); if (aliOrderList.Count > 0) { AliOrderUtil.put_order_items(cmsForm, aliOrderList); } aliOrderList = ExeclUtil.query_order(cmsForm, cmsForm.appBean.taoke_cookie, 3); if (aliOrderList.Count > 0) { AliOrderUtil.put_order_items(cmsForm, aliOrderList); } aliOrderList = ExeclUtil.query_order(cmsForm, cmsForm.appBean.taoke_cookie, 4); if (aliOrderList.Count > 0) { AliOrderUtil.put_order_items(cmsForm, aliOrderList); } aliOrderList = ExeclUtil.query_order(cmsForm, cmsForm.appBean.taoke_cookie, 5); if (aliOrderList.Count > 0) { AliOrderUtil.put_order_items(cmsForm, aliOrderList); } }
public static ArrayList query_order_list(CmsForm cmsForm, string string_0, out string out_log) { out_log = ""; ArrayList arrayLists = new ArrayList(); HSSFWorkbook hSSFWorkbook = null; try { try { FileStream fileStream = new FileStream(string_0, FileMode.Open, FileAccess.Read); hSSFWorkbook = new HSSFWorkbook(fileStream); ISheet sheetAt = hSSFWorkbook.GetSheetAt(0); if (File.Exists(string_0)) { IRow row = sheetAt.GetRow(0); //读取当前行数据 //LastRowNum 是当前表的总行数-1(注意) //int offset = 0; for (int i = 0; i <= sheetAt.LastRowNum; i++) { row = sheetAt.GetRow(i); //读取当前行数据 if (row != null) { AliOrderBean aliOrderBean = new AliOrderBean(); aliOrderBean.order_time = ExeclUtil.read_cell(row.GetCell(0)); aliOrderBean.click_time = ExeclUtil.read_cell(row.GetCell(1)); aliOrderBean.title = ExeclUtil.read_cell(row.GetCell(2)); aliOrderBean.num_iid = ExeclUtil.read_cell(row.GetCell(3)); aliOrderBean.nick = ExeclUtil.read_cell(row.GetCell(4)); aliOrderBean.shop_title = ExeclUtil.read_cell(row.GetCell(5)); aliOrderBean.product_num = ExeclUtil.read_cell(row.GetCell(6)); aliOrderBean.product_price = ExeclUtil.read_cell(row.GetCell(7)); aliOrderBean.status = ExeclUtil.read_cell(row.GetCell(8)); aliOrderBean.order_type = ExeclUtil.read_cell(row.GetCell(9)); aliOrderBean.commission_rate = ExeclUtil.read_cell(row.GetCell(10)); aliOrderBean.fen_rate = ExeclUtil.read_cell(row.GetCell(11)); aliOrderBean.price = ExeclUtil.read_cell(row.GetCell(12)); aliOrderBean.commission = ExeclUtil.read_cell(row.GetCell(13)); aliOrderBean.settlement_price = ExeclUtil.read_cell(row.GetCell(14)); aliOrderBean.settlement_money = ExeclUtil.read_cell(row.GetCell(15)); aliOrderBean.settlement_date = ExeclUtil.read_cell(row.GetCell(16)); aliOrderBean.product_rate = ExeclUtil.read_cell(row.GetCell(17)); aliOrderBean.product_money = ExeclUtil.read_cell(row.GetCell(18)); aliOrderBean.benefit_rate = ExeclUtil.read_cell(row.GetCell(19)); aliOrderBean.benefit_money = ExeclUtil.read_cell(row.GetCell(20)); aliOrderBean.benefit_type = ExeclUtil.read_cell(row.GetCell(21)); aliOrderBean.order_platform = ExeclUtil.read_cell(row.GetCell(22)); aliOrderBean.third_party_service = ExeclUtil.read_cell(row.GetCell(23)); aliOrderBean.order_no = ExeclUtil.read_cell(row.GetCell(24)); aliOrderBean.cate_name = ExeclUtil.read_cell(row.GetCell(25)); aliOrderBean.site_id = ExeclUtil.read_cell(row.GetCell(26)); aliOrderBean.site_name = ExeclUtil.read_cell(row.GetCell(27)); aliOrderBean.zone_id = ExeclUtil.read_cell(row.GetCell(28)); aliOrderBean.zone_name = ExeclUtil.read_cell(row.GetCell(29)); //LastCellNum 是当前行的总列数 //for (int j = 0; j < row.LastCellNum; j++) //{ // //读取该行的第j列数据 // string value = row.GetCell(j).ToString(); // LogUtil.log_call(cmsForm, "value" + value.ToString()); //} arrayLists.Add(aliOrderBean); //LogUtil.log_call(cmsForm, "zone_name:" + aliOrderBean.zone_name.ToString()); } } } fileStream.Close(); } catch (Exception exception) { LogUtil.log_call(cmsForm, "exception" + exception.ToString()); } } finally { ExeclUtil.close(hSSFWorkbook); } return(arrayLists); }
public static ArrayList query_order(CmsForm cmsForm, string cookie, int queryType) { ArrayList arrayLists = new ArrayList(); try { int days = 2; days = cmsForm.appBean.ali_order_days; string startTime = DateTime.Now.AddDays(-days).ToString("yyyy-MM-dd"); string endTime = DateTime.Now.ToString("yyyy-MM-dd"); DateTime now = DateTime.Now; string str = string.Concat("temp", now.ToString("yyyyMMddHHmmss"), ".xls"); string str1 = string.Concat(cmsForm.app_path, "\\config\\", str); if (File.Exists(str1)) { File.Delete(str1); } string str2 = "http://pub.alimama.com/report/getTbkPaymentDetails.json?queryType=1&payStatus=&DownloadID=DOWNLOAD_REPORT_INCOME_NEW&startTime={startTime}&endTime={endTime}"; if (queryType == 1) { str2 = "http://pub.alimama.com/report/getTbkPaymentDetails.json?queryType=3&payStatus=3&DownloadID=DOWNLOAD_REPORT_INCOME_NEW&startTime={startTime}&endTime={endTime}"; } if (queryType == 2) { str2 = "http://pub.alimama.com/report/getTbkThirdPaymentDetails.json?queryType=2&payStatus=&DownloadID=DOWNLOAD_REPORT_TK3_PUB&startTime={startTime}&endTime={endTime}"; } if (queryType == 3) { str2 = "http://pub.alimama.com/report/getTbkThirdPaymentDetails.json?queryType=4&payStatus=3&DownloadID=DOWNLOAD_REPORT_TK3_PUB&startTime={startTime}&endTime={endTime}"; } if (queryType == 4) { str2 = "http://pub.alimama.com/report/getElitePaymentDetails.json?queryType=5&payStatus=&DownloadID=DOWNLOAD_REPORT_ELITE&startTime={startTime}&endTime={endTime}"; } if (queryType == 5) { str2 = "http://pub.alimama.com/report/getElitePaymentDetails.json?queryType=6&payStatus=3&DownloadID=DOWNLOAD_REPORT_ELITE&startTime={startTime}&endTime={endTime}"; } str2 = str2.Replace("{startTime}", startTime).Replace("{endTime}", endTime); WebClient webClient = new WebClient(); webClient.Headers.Add("Accept", "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8"); webClient.Headers.Add("User-Agent", "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36"); webClient.Headers.Add("Content-Type", "application/x-www-form-urlencoded; charset=UTF-8"); webClient.Headers.Add("Referer", "http://pub.alimama.com/myunion.htm"); webClient.Headers.Add("Accept-Encoding", "gzip,deflate,sdch"); webClient.Headers.Add("Accept-Language", "zh-CN,zh;q=0.8"); webClient.Headers.Add("Cookie", cookie); webClient.DownloadFile(str2, str1); //LogUtil.log_call(cmsForm, "str1" + str1.ToString()); try { string out_log; arrayLists = ExeclUtil.query_order_list(cmsForm, str1, out out_log); //System.Data.DataTable dt = ExeclUtil.GetExcelData(str1); //LogUtil.log_call(cmsForm, "dt.Rows.Count:" + dt.Rows.Count); //foreach(DataRow dr in dt.Rows) //{ // object value = dr["ColumnsName"]; // LogUtil.log_call(cmsForm,"value"+ value.ToString()); //} } catch (Exception exception) { LogUtil.log_call(cmsForm, "[DataTable]出错!" + exception.ToString()); } File.Delete(str1); } catch (Exception) { } return(arrayLists); }