Ejemplo n.º 1
0
        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);
        }
Ejemplo n.º 2
0
        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);
        }
Ejemplo n.º 3
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);
        }
Ejemplo n.º 4
0
        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);
            }
        }
Ejemplo n.º 5
0
        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);
        }
Ejemplo n.º 6
0
        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);
        }