public ArrayList query_order_sql(string sql, out string out_log)
{
try
{
ArrayList list = new ArrayList();
SQLiteDBHelper db = new SQLiteDBHelper(this.app_path + @"\config\" + this.db_name);
using (SQLiteDataReader reader = db.ExecuteReader(sql, null))
{
while (reader.Read())
{
AliOrderBean aliOrderBean = new AliOrderBean();
try
{
aliOrderBean.order_no = reader.GetString(1);
}
catch (Exception) { }
try
{
aliOrderBean.num_iid = reader.GetString(2);
}
catch (Exception) { }
try
{
aliOrderBean.status = reader.GetString(3);
}
catch (Exception) { }
list.Add(aliOrderBean);
}
}
out_log = "";
return(list);
}
catch (Exception exception)
{
out_log = "出错啦：" + exception.ToString();
return(new ArrayList());
}
}
public static bool submit_order_items(CmsForm cmsForm, ArrayList items)
{
HttpService httpservice = cmsForm.httpService;
long user_id = cmsForm.appBean.user_id;
string app_id = cmsForm.appBean.cms_app_id;
String user_key = cmsForm.appBean.user_key;
String user_name = cmsForm.appBean.user_name;
String member_id = cmsForm.appBean.member_id;
String user_taoke_create_url = Constants.user_ali_order_create_url;
string datastr = String.Concat(
"user_id=" + user_id
, "&user_key=" + user_key
, "&user_token="
, "&app_id=" + app_id
, "&alimama_id=" + member_id
);
ArrayList update_arrayLists = new ArrayList();
for (int i = 1; i < items.Count; i++)
{
AliOrderBean item = (AliOrderBean)items[i];
String out_log;
ArrayList sql_list = cmsForm.sendSqlUtil.query_order(item.num_iid, item.order_no, out out_log);
if (sql_list.Count <= 0 ||
!((AliOrderBean)sql_list[0]).status.Equals(item.status + item.settlement_date)
)
{
datastr = String.Concat(
datastr
, "&order_time[]=" + HttpUtility.UrlEncode(item.order_time)
, "&click_time[]=" + HttpUtility.UrlEncode(item.click_time)
, "&title[]=" + HttpUtility.UrlEncode(item.title)
, "&num_iid[]=" + HttpUtility.UrlEncode(item.num_iid)
, "&nick[]=" + HttpUtility.UrlEncode(item.nick)
, "&shop_title[]=" + HttpUtility.UrlEncode(item.shop_title)
, "&product_num[]=" + HttpUtility.UrlEncode(item.product_num)
, "&product_price[]=" + HttpUtility.UrlEncode(item.product_price)
, "&status[]=" + HttpUtility.UrlEncode(item.status)
, "&order_type[]=" + HttpUtility.UrlEncode(item.order_type)
, "&commission_rate[]=" + HttpUtility.UrlEncode(item.commission_rate)
, "&fen_rate[]=" + HttpUtility.UrlEncode(item.fen_rate)
, "&price[]=" + HttpUtility.UrlEncode(item.price)
, "&commission[]=" + HttpUtility.UrlEncode(item.commission)
, "&settlement_price[]=" + HttpUtility.UrlEncode(item.settlement_price)
, "&settlement_money[]=" + HttpUtility.UrlEncode(item.settlement_money)
, "&settlement_date[]=" + HttpUtility.UrlEncode(item.settlement_date)
, "&product_rate[]=" + HttpUtility.UrlEncode(item.product_rate)
, "&product_money[]=" + HttpUtility.UrlEncode(item.product_money)
, "&benefit_rate[]=" + HttpUtility.UrlEncode(item.benefit_rate)
, "&benefit_money[]=" + HttpUtility.UrlEncode(item.benefit_money)
, "&benefit_type[]=" + HttpUtility.UrlEncode(item.benefit_type)
, "&order_platform[]=" + HttpUtility.UrlEncode(item.order_platform)
, "&third_party_service[]=" + HttpUtility.UrlEncode(item.third_party_service)
, "&order_no[]=" + HttpUtility.UrlEncode(item.order_no)
, "&cate_name[]=" + HttpUtility.UrlEncode(item.cate_name)
, "&site_id[]=" + HttpUtility.UrlEncode(item.site_id)
, "&site_name[]=" + HttpUtility.UrlEncode(item.site_name)
, "&zone_id[]=" + HttpUtility.UrlEncode(item.zone_id)
, "&zone_name[]=" + HttpUtility.UrlEncode(item.zone_name)
//, "&num_iid[]=" + item.num_iid
//, "&url[]=" + item.url
//, "&coupon_url[]=" + item.coupon_url
//, "&short_url[]=" + item.short_url
//, "&tao_token[]=" + item.tao_token
//, "&coupon_link_tao_token[]=" + item.coupon_link_tao_token
);
LogUtil.log_cms_call(cmsForm, item.num_iid);
update_arrayLists.Add(item);
}
}
String body = httpservice.post_http(user_taoke_create_url, datastr, null);
LogUtil.log_cms_call(cmsForm, body);
if (body.IndexOf("success") >= 0)
{
for (int i = 0; i < update_arrayLists.Count; i++)
{
AliOrderBean item = (AliOrderBean)update_arrayLists[i];
String out_log;
bool s = cmsForm.sendSqlUtil.insert_order_item(item.order_no, item.num_iid, item.status + item.settlement_date, out out_log);
//LogUtil.log_cms_call(cmsForm, "" + s);
}
}
//LogUtil.log_cms_call(cmsForm, body);
return(true);
}
public static bool put_order_items(CmsForm cmsForm, ArrayList items)
{
long user_id = cmsForm.appBean.user_id;
string app_id = cmsForm.appBean.cms_app_id;
String user_key = cmsForm.appBean.user_key;
String user_name = cmsForm.appBean.user_name;
String member_id = cmsForm.appBean.member_id;
ArrayList update_arrayLists = new ArrayList();
if (!Directory.Exists(cmsForm.app_path + "/config/upload"))
{
Directory.CreateDirectory(cmsForm.app_path + "/config/upload");
}
string upload_file_name = DateTime.Now.ToString("yyMMddhhmmss") + DateTime.Now.Millisecond.ToString() + ".txt";
string upload_file = cmsForm.app_path + "/config/upload/" + upload_file_name;
FileStream stream = new FileStream(upload_file, FileMode.Create);
StreamWriter writer = new StreamWriter(stream, Encoding.GetEncoding("utf-8"));
writer.WriteLine("");
for (int i = 1; i < items.Count; i++)
{
AliOrderBean item = (AliOrderBean)items[i];
String out_log;
ArrayList sql_list = cmsForm.sendSqlUtil.query_order(item.num_iid, item.order_no, out out_log);
if (sql_list.Count <= 0 ||
!((AliOrderBean)sql_list[0]).status.Equals(item.status + item.settlement_date)
)
{
string datastr = String.Concat(
"order_time[]=" + item.order_time
, "&click_time[]=" + item.click_time
, "&title[]=" + item.title
, "&num_iid[]=" + item.num_iid
, "&nick[]=" + item.nick
, "&shop_title[]=" + item.shop_title
, "&product_num[]=" + item.product_num
, "&product_price[]=" + item.product_price
, "&status[]=" + item.status
, "&order_type[]=" + item.order_type
, "&commission_rate[]=" + item.commission_rate
, "&fen_rate[]=" + item.fen_rate
, "&price[]=" + item.price
, "&commission[]=" + item.commission
, "&settlement_price[]=" + item.settlement_price
, "&settlement_money[]=" + item.settlement_money
, "&settlement_date[]=" + item.settlement_date
, "&product_rate[]=" + item.product_rate
, "&product_money[]=" + item.product_money
, "&benefit_rate[]=" + item.benefit_rate
, "&benefit_money[]=" + item.benefit_money
, "&benefit_type[]=" + item.benefit_type
, "&order_platform[]=" + item.order_platform
, "&third_party_service[]=" + item.third_party_service
, "&order_no[]=" + item.order_no
, "&cate_name[]=" + item.cate_name
, "&site_id[]=" + item.site_id
, "&site_name[]=" + item.site_name
, "&zone_id[]=" + item.zone_id
, "&zone_name[]=" + item.zone_name
, "&user_id[]=" + user_id
, "&user_key[]=" + user_key
, "&user_token[]="
, "&app_id[]=" + app_id
, "&alimama_id[]=" + member_id
//, "&num_iid[]=" + item.num_iid
//, "&url[]=" + item.url
//, "&coupon_url[]=" + item.coupon_url
//, "&short_url[]=" + item.short_url
//, "&tao_token[]=" + item.tao_token
//, "&coupon_link_tao_token[]=" + item.coupon_link_tao_token
);
writer.WriteLine(datastr);
LogUtil.log_cms_call(cmsForm, item.num_iid);
update_arrayLists.Add(item);
}
}
writer.Flush();
writer.Close();
writer.Dispose();
stream.Close();
stream.Dispose();
string uriString = Constants.put_tools_url + "/" + upload_file_name;
new WinFileTransporter().UpLoadFile(upload_file, uriString);
File.Delete(upload_file);
for (int i = 0; i < update_arrayLists.Count; i++)
{
AliOrderBean item = (AliOrderBean)update_arrayLists[i];
String out_log;
bool s = cmsForm.sendSqlUtil.insert_order_item(item.order_no, item.num_iid, item.status + item.settlement_date, out out_log);
//LogUtil.log_cms_call(cmsForm, "" + s);
}
return(true);
}
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);
}