/// <summary>
/// 根据ISBN查找书号，单价，折扣
/// </summary>
/// <param name="ISBN">ISBN</param>
/// <returns></returns>
public DataSet SelectByIsbn(string ISBN)
{
MySqlHelp db = new MySqlHelp();
string comTexts = "select count(bookNum) from T_BookBasicData where ISBN=@ISBN";
string[] parames = { "@ISBN" };
object[] value = { ISBN };
int row = Convert.ToInt32(db.ExecuteScalar(comTexts, parames, value));
if (row == 0)
{
return(null);
}
else
{
string comText = "select bookNum,ISBN,price,author,bookName,supplier from T_BookBasicData where ISBN=@ISBN";
string[] param = { "@ISBN" };
object[] values = { ISBN };
DataSet ds = db.FillDataSet(comText, param, values);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
return(null);
}
}
}
/// <summary>
/// 根据书号查找isbn，单价，折扣
/// </summary>
/// <param name="bookNum">书号</param>
/// <returns></returns>
public BookBasicData SelectById(string bookNum)
{
MySqlHelp db = new MySqlHelp();
string comText = "select ISBN,price,bookName,supplier,remarks,author from T_BookBasicData where bookNum=@bookNum";
string[] param = { "@bookNum" };
object[] values = { bookNum };
DataSet ds = db.FillDataSet(comText, param, values);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
string isbn = ds.Tables[0].Rows[0]["isbn"].ToString();
string price = ds.Tables[0].Rows[0]["price"].ToString();
string remarks = ds.Tables[0].Rows[0]["remarks"].ToString();
string bookName = ds.Tables[0].Rows[0]["bookName"].ToString();
string supplier = ds.Tables[0].Rows[0]["supplier"].ToString();
string author = ds.Tables[0].Rows[0]["author"].ToString();
BookBasicData bookBasic = new BookBasicData();
bookBasic.Isbn = isbn;
bookBasic.Price = Convert.ToDouble(price);
bookBasic.Remarks = remarks;
bookBasic.BookName = bookName;
bookBasic.Publisher = supplier;
bookBasic.Author = author;
return(bookBasic);
}
else
{
return(null);
}
}
/// <summary>
///
/// </summary>
/// <param name="spiderinfo"></param>
/// <returns></returns>
public bool Control(Spiderinfo spiderinfo)
{
bool flg = false;
#region 爬虫监控系统
string insertSql = string.Format("insert ignore into spiderinfo(SpiderProgramName,TaskName,SiteName,TemplateName,StartDT,EndDT,RequestMount,CatchMount,StoreMount,ProxyRequestMount,ProxyPercent,VertifyMount,VertifyPercent,TotalMount,TotalLength,IPAddress,Ext) values('{0}','{1}','{2}','{3}','{4}','{5}',{6},{7},{8},{9},{10},{11},{12},{13},{14},'{15}','{16}')", spiderinfo.SpiderProgramName, spiderinfo.TaskName, spiderinfo.SiteName, spiderinfo.TemplateName, spiderinfo.StartDT, spiderinfo.EndDT, spiderinfo.RequestMount, spiderinfo.CatchMount, spiderinfo.StoreMount, spiderinfo.ProxyRequestMount, spiderinfo.ProxyPercent, spiderinfo.VertifyMount, spiderinfo.VertifyPercent, spiderinfo.TotalMount, spiderinfo.TotalLength, spiderinfo.IPAddress, spiderinfo.Ext);
int itryMax = 3;
while (itryMax > 0)
{
int iflg = MySqlHelp.Insert(AliyunConn, insertSql, spiderinfo.TaskName + "插入数据失败记录.txt");
if (iflg >= 0)
{
itryMax = 0;
flg = true;
}
else
{
itryMax--;
}
string checkInfo =
string.Format("爬虫:{0} 请求量:{1} 抓取量:{2} 入库量:{3} 代理请求量:{4} 代理成功率:{5} 打码次数:{6} 成功打码:{7} 打码成功率:{8} 总抓取量:{9} 时间:{10}",
spiderinfo.TaskName,
spiderinfo.RequestMount, spiderinfo.CatchMount, spiderinfo.StoreMount, spiderinfo.ProxyRequestMount,
spiderinfo.ProxyPercent, spiderinfo.VertifyMount, spiderinfo.VertifyTrueMount, spiderinfo.VertifyPercent,
spiderinfo.TotalMount, DateTime.Now);
Console.WriteLine("【{0}】{1}", iflg, checkInfo);
CLog.DiaryLog(checkInfo, spiderinfo.TaskName + "(每半小时统计一次)_" + DateTime.Now.ToString("yyyyMMdd") + ".txt");
}
#endregion
return(flg);
}
/// <summary>
/// 根据书号查找ISBN，单价，折扣
/// </summary>
/// <param name="ISBN">ISBN</param>
/// <returns></returns>
public DataSet SelectByBookNum(string bookNum)
{
MySqlHelp db = new MySqlHelp();
string comTexts = "select count(bookNum) from T_BookBasicData where bookNum=@bookNum";
string[] parames = { "@bookNum" };
object[] value = { bookNum };
int row = Convert.ToInt32(db.ExecuteScalar(comTexts, parames, value));
if (row == 0)
{
return(null);
}
else
{
string comText = "select bookNum,ISBN,price,remarks as discount,bookName from T_BookBasicData where bookNum=@bookNum";
string[] param = { "@bookNum" };
object[] values = { bookNum };
DataSet ds = db.FillDataSet(comText, param, values);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
return(null);
}
}
}
static void Main(string[] args)
{
// 请根据实际 appid 和 appkey 进行开发，以下只作为演示 sdk 使用
// appid,appkey,templId申请方式可参考接入指南 https://www.qcloud.com/document/product/382/3785#5-.E7.9F.AD.E4.BF.A1.E5.86.85.E5.AE.B9.E9.85.8D.E7.BD.AE
int sdkappid = 1400096240;
string appkey = "409fa0923289125b7b12025b0b281535";
string phoneNumber1 = "15221336036";
string phoneNumber2 = "15221336036";
string phoneNumber3 = "15221336036";
int tmplId = 128733;
try
{
//SmsSingleSenderResult singleResult;
//SmsSingleSender singleSender = new SmsSingleSender(sdkappid, appkey);
//singleResult = singleSender.Send(0, "86", phoneNumber2, "测试短信，普通单发，深圳，小明，上学。", "", "");
//Console.WriteLine(singleResult);
List <string> templParams = new List <string>();
templParams.Add("7876");
//// 指定模板单发
//// 假设短信模板内容为：测试短信，{1}，{2}，{3}，上学。
//singleResult = singleSender.SendWithParam("86", phoneNumber2, tmplId, templParams, "", "", "");
//Console.WriteLine(singleResult);
//return;
SmsMultiSenderResult multiResult;
SmsMultiSender multiSender = new SmsMultiSender(sdkappid, appkey);
List <string> phoneNumbers = new List <string>();
//phoneNumbers.Add(phoneNumber1);
//phoneNumbers.Add(phoneNumber2);
//phoneNumbers.Add(phoneNumber3);
DataTable dt = MySqlHelp.ExecuteDataTable("select * from t_customers");
foreach (DataRow dr in dt.Rows)
{
phoneNumbers.Add(dr["CellNumber"].ToString());
}
// 普通群发
// 下面是 3 个假设的号码
multiResult = multiSender.Send(0, "86", phoneNumbers, "测试短信，普通群发，深圳，小明，上学。", "", "");
Console.WriteLine(multiResult);
return;
// 指定模板群发
// 假设短信模板内容为：测试短信，{1}，{2}，{3}，上学。
templParams.Clear();
templParams.Add("指定模板群发");
templParams.Add("深圳");
templParams.Add("小明");
multiResult = multiSender.SendWithParam("86", phoneNumbers, tmplId, templParams, "", "", "");
Console.WriteLine(multiResult);
}
catch (Exception e)
{
Console.WriteLine(e);
}
Console.Read();
}
/// <summary>
/// 取行数
/// </summary>
/// <returns></returns>
public int SelectCount()
{
MySqlHelp db = new MySqlHelp();
string comText = "select count(bookNum) from T_BookBasicData";
int count = Convert.ToInt32(db.ExecuteScalar(comText, null, null));
return(count);
}
/// <summary>
/// 查询客户数据
/// </summary>
/// <returns></returns>
public DataSet getCustomer()
{
MySqlHelp db = new MySqlHelp();
string comText = "select customerName,customerID from T_Customer where deleteState=0 order by convert(customerName using gbk) collate gbk_chinese_ci";
DataSet ds = db.FillDataSet(comText, null, null);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
return(null);
}
}
/// <summary>
/// 查询供应商
/// </summary>
/// <returns></returns>
public DataTable selectSupplier()
{
MySqlHelp db = new MySqlHelp();
string comText = "select distinct supplier from T_BookBasicData order by convert(supplier using gbk) collate gbk_chinese_ci";
DataSet ds = db.FillDataSet(comText, null, null);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
return(dt);
}
else
{
return(null);
}
}
/// <summary>
/// 获取所有书本基础数据的ISBN，单价，书名
/// </summary>
/// <returns></returns>
public DataTable Select()
{
MySqlHelp db = new MySqlHelp();
string comText = "select ISBN,price,bookName,supplier,author,remarks from T_BookBasicData order by convert(supplier using gbk) collate gbk_chinese_ci";
DataSet ds = db.FillDataSet(comText, null, null);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
return(dt);
}
else
{
return(null);
}
}
/// <summary>
/// 获取来源组织/收货组织
/// </summary>
/// <returns></returns>
public DataTable selectSource()
{
MySqlHelp db = new MySqlHelp();
string comText = "select distinct regionName from v_stockstatistics order by convert(regionName using gbk) collate gbk_chinese_ci";
DataSet ds = db.FillDataSet(comText, null, null);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
return(dt);
}
else
{
return(null);
}
}
/// <summary>
/// 通过地区获取客户姓名和ID
/// </summary>
/// <returns></returns>
public DataSet getCustomerByReg(int regionId)
{
MySqlHelp db = new MySqlHelp();
string comText = "select customerName,customerID from T_Customer where regionId=@regionId";
string[] param = { "@regionId" };
string[] values = { regionId.ToString() };
DataSet ds = db.FillDataSet(comText, param, values);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
return(null);
}
}
/// <summary>
/// 通过书号 获取单价 进货折扣
/// </summary>
/// <param name="booknum"></param>
/// <returns></returns>
public DataTable getBookNumByNum(string booknum)
{
MySqlHelp db = new MySqlHelp();
string comText = "select bookNum,price,author from T_BookBasicData where bookNum=@bookNum";
string[] parames = { "@bookNum" };
object[] value = { booknum };
DataSet ds = db.FillDataSet(comText, parames, value);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
return(dt);
}
else
{
return(null);
}
}
/// <summary>
/// 通过ISBN和书名获取书号 单价 进货折扣
/// </summary>
/// <param name="ISBN"></param>
/// <param name="bookName"></param>
/// <returns></returns>
public DataTable getBookNum(string ISBN, string bookName)
{
MySqlHelp db = new MySqlHelp();
string comText = "select bookNum,price,author from T_BookBasicData where ISBN=@ISBN and bookName=@bookName ";
string[] parames = { "@ISBN", "@bookName" };
object[] value = { ISBN, bookName };
DataSet ds = db.FillDataSet(comText, parames, value);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
return(dt);
}
else
{
return(null);
}
}
/// <summary>
/// 根据ISBN查找书号，单价，折扣
/// </summary>
/// <param name="ISBN">ISBN</param>
/// <returns></returns>
public DataTable SelectByIsbn(string ISBN)
{
MySqlHelp db = new MySqlHelp();
string comTexts = "select count(bookNum) from T_BookBasicData where ISBN=@ISBN";
string[] parames = { "@ISBN" };
object[] value = { ISBN };
int row = Convert.ToInt32(db.ExecuteScalar(comTexts, parames, value));
if (row == 0)
{
return(null);
}
else
{
string comText = "select bookNum,ISBN,price,remarks as discount,bookName from T_BookBasicData where ISBN=@ISBN";
string[] param = { "@ISBN" };
object[] values = { ISBN };
DataSet ds = db.FillDataSet(comText, param, values);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataTable excel = new DataTable();
excel.Columns.Add("bookNum");
excel.Columns.Add("ISBN");
excel.Columns.Add("price");
excel.Columns.Add("discount");
excel.Columns.Add("bookName");
DataRowCollection count = ds.Tables[0].Rows;
foreach (DataRow row1 in count)
{
string bookName = ToDBC(row1[4].ToString());
excel.Rows.Add(row1[0], row1[1], row1[2], row1[3], bookName);
}
return(excel);
}
else
{
return(null);
}
}
}
/// <summary>
/// 根据书号查找isbn，单价，折扣
/// </summary>
/// <param name="bookNum">书号</param>
/// <returns></returns>
public BookBasicData SelectByBookNum(long bookNum, string retailHeadId)
{
MySqlHelp db = new MySqlHelp();
string comTexts = "select count(id) from T_RetailMonomer where bookNum=@bookNum and retailHeadId=@retailHeadId";
string[] parames = { "@bookNum", "@retailHeadId" };
object[] value = { bookNum, retailHeadId };
int row = Convert.ToInt32(db.ExecuteScalar(comTexts, parames, value));
if (row == 0)
{
return(null);
}
else
{
string comText = "select ISBN,price,bookName,supplier,remarks from T_BookBasicData where bookNum=@bookNum";
string[] param = { "@bookNum" };
object[] values = { bookNum };
DataSet ds = db.FillDataSet(comText, param, values);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
string isbn = ds.Tables[0].Rows[0]["isbn"].ToString();
string price = ds.Tables[0].Rows[0]["price"].ToString();
string remarks = ds.Tables[0].Rows[0]["remarks"].ToString();
string bookName = ds.Tables[0].Rows[0]["bookName"].ToString();
string supplier = ds.Tables[0].Rows[0]["supplier"].ToString();
BookBasicData bookBasic = new BookBasicData();
bookBasic.Isbn = isbn;
bookBasic.Price = Convert.ToDouble(price);
bookBasic.Remarks = remarks;
bookBasic.BookName = bookName;
bookBasic.Publisher = supplier;
return(bookBasic);
}
else
{
return(null);
}
}
}
/// <summary>
/// 根据书号查找isbn，单价，折扣
/// </summary>
/// <param name="bookNum">书号</param>
/// <returns></returns>
public SaleMonomer SelectBookNum(string bookNum, string retailHeadId)
{
MySqlHelp db = new MySqlHelp();
string comTexts = "select count(*) from T_RetailMonomer where bookNum=@bookNum and retailHeadId=@retailHeadId";
string[] parames = { "@bookNum", "@retailHeadId" };
object[] value = { bookNum, retailHeadId };
int row = Convert.ToInt32(db.ExecuteScalar(comTexts, parames, value));
if (row == 0)
{
return(null);
}
else
{
string comText = "select bookName,bookNum,ISBN,number,unitPrice,realDiscount,totalPrice,realPrice from V_RetailMonomer where bookNum=@bookNum";
string[] param = { "@bookNum" };
object[] values = { bookNum };
DataSet ds = db.FillDataSet(comText, param, values);
if (ds != null || ds.Tables[0].Rows.Count > 0)
{
SaleMonomer retail = new SaleMonomer();
retail.ISBN1 = ds.Tables[0].Rows[0]["ISBN"].ToString();
retail.BookName = ds.Tables[0].Rows[0]["bookName"].ToString();
retail.BookNum = ds.Tables[0].Rows[0]["bookNum"].ToString();
retail.Number = Convert.ToInt32(ds.Tables[0].Rows[0]["number"]);
retail.UnitPrice = Convert.ToDouble(ds.Tables[0].Rows[0]["unitPrice"]);
retail.RealDiscount = Convert.ToDouble(ds.Tables[0].Rows[0]["realDiscount"]);
retail.TotalPrice = Convert.ToDouble(ds.Tables[0].Rows[0]["totalPrice"]);
retail.RealPrice = Convert.ToDouble(ds.Tables[0].Rows[0]["realPrice"]);
return(retail);
}
else
{
return(null);
}
}
}
/// <summary>
/// 数据库删除操作
/// </summary>
/// <param name="conn">数据库连接</param>
/// <param name="sql">删除语句</param>
/// <param name="parameters">参数列表化</param>
/// <returns>-101为删除失败</returns>
public int Delete(string conn, string sql, params MySqlParameter[] parameters)
{
return(MySqlHelp.Delete(conn, sql));
}
/// <summary>
/// 数据库插入操作
/// </summary>
/// <param name="conn">数据库连接</param>
/// <param name="sql">插入语句</param>
/// <param name="errorFile">错误记录的文件名</param>
/// <param name="parameters">参数列表化</param>
/// <returns>-101为插入失败</returns>
public int Insert(string conn, string sql, string errorFile, params MySqlParameter[] parameters)
{
return(MySqlHelp.Insert(conn, sql, errorFile));
}
public JsonResult UploadByAjax()
{
var allinsertsql = "";
var JsonString = "";
try
{
//取得目前 HTTP 要求的 HttpRequestBase 物件
foreach (string file in Request.Files)
{
var fileContent = Request.Files[file];
if (fileContent != null && fileContent.ContentLength > 0)
{
// 取得的檔案是stream
var stream = fileContent.InputStream;
var fileName = Path.GetFileName(file);
var path = Path.Combine(Request.MapPath("~/SaveFile"), fileName);
using (var fileStream = System.IO.File.Create(path))
{
stream.CopyTo(fileStream);
}
ExcelHelper excel_helper = new ExcelHelper(path);
DataTable dt = excel_helper.ExcelToDataTable("", true);
JsonString = "dt completed";
//List<string> tableList = GetColumnsByDataTable(dt);
foreach (DataRow dr in dt.Rows)
{
string insertSql = @"
insert into t_orders(ImportName,ProductName,Number,Spec,Price,OrderID,OrderDetailID,OrderDate,CustomerName,CellNumber,Province,City,District,Address)
values ("
+ "'" + fileName + "',"
+ "'" + dr[1].ToString() + "',"
+ "'" + dr[2].ToString() + "',"
+ "'" + dr[3].ToString() + "',"
+ "'" + dr[4].ToString() + "',"
+ "'" + dr[5].ToString() + "',"
+ "'" + dr[6].ToString() + "',"
+ "'" + dr[7].ToString() + "',"
+ "'" + dr[8].ToString() + "',"
+ "'" + dr[9].ToString() + "',"
+ "'" + dr[10].ToString() + "',"
+ "'" + dr[11].ToString() + "',"
+ "'" + dr[12].ToString() + "',"
+ "'" + dr[13].ToString() + "');";
allinsertsql += insertSql;
}
allinsertsql = "delete from t_orders where ImportName='" + fileName + "';" + allinsertsql;
JsonString = "allinsertsql completed" + allinsertsql;
MySqlHelp.ExecuteNonQuery(allinsertsql);
string selectsql = @"set @rowno := 0;select @rowno:=@rowno + 1 AS rowno,a.* from (
select CustomerName,CellNumber,
GROUP_CONCAT(CONCAT(ProductName,Spec, CAST(Number AS char),'份',CHAR(10) )) as 'Product',
CONCAT(Province,City,District,Address ) as 'Address'
from t_orders
where ImportName='" + fileName + @"'
GROUP BY CustomerName,CellNumber,Address
) a ,(SELECT @rowno:=0) b;
select ProductName,Spec,SUM(Number) as 'SUM'
from t_orders
where ImportName='" + fileName + @"'
GROUP BY ProductName,Spec
";
JsonString = "selectsql completed" + selectsql;
DataSet sdt = MySqlHelp.ExecuteDataSet(selectsql);
JsonString = DataTableToJsonWithJsonNet(sdt);
}
}
return(Json(JsonString));
}
catch (Exception ex)
{
return(Json(ex.Message + JsonString));
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Charset = "utf-8";
string Action = context.Request["Action"].ToString();
string result = "{\"result\":\"failed\"}";
string openid = "";
if (!string.IsNullOrEmpty(Action))
{
switch (Action)
{
case "order":
var orderdata = context.Request["orderdata"].ToString();
string _statusid = "1";
string _statusStr = "NotPaid";
AllTrustUs.SquirrelPocket.Entity.Order _o = JsonUtility.Deserialize <AllTrustUs.SquirrelPocket.Entity.Order>(orderdata);
if (Convert.ToDecimal(_o.actualprice) == 0)
{
_statusid = "2";
_statusStr = "PaidSuccessed";
}
string insjson = @"insert into t_order(openid,outtradeno,fruittype,unitprice,startdate,enddate,days,
count,deliveryaddr,user,mp,totalprice,status,createdate,statusid,deliverystatus,otheraddr,GiftCardCode,deduction,actualprice,agencylevel,discount) values({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21});select @@IDENTITY;";
insjson = string.Format(insjson,
UtilityFn.formatstring(_o.openid),
UtilityFn.formatstring(UtilityFn.GenerateOutTradeNo()),
UtilityFn.formatstring(_o.fruittype),
UtilityFn.formatstring(_o.unitprice),
UtilityFn.formatstring(_o.startdate),
UtilityFn.formatstring(_o.enddate),
UtilityFn.formatstring(_o.days),
UtilityFn.formatstring(_o.count),
UtilityFn.formatstring(_o.deliveryaddr),
UtilityFn.formatstring(_o.user),
UtilityFn.formatstring(_o.mp),
UtilityFn.formatstring(_o.totalprice),
UtilityFn.formatstring(_statusStr),
UtilityFn.formatstring(DateTime.Now.ToString("yyyy/MM/dd HH:mm")),
UtilityFn.formatstring(_statusid),
UtilityFn.formatstring("未配送"),
UtilityFn.formatstring(_o.otheraddr),
UtilityFn.formatstring(_o.GiftCardCode),
UtilityFn.formatstring(_o.deduction),
UtilityFn.formatstring(_o.actualprice),
UtilityFn.formatstring(_o.agencylevel),
UtilityFn.formatstring(_o.discount)
);
DataTable order = MySqlHelp.ExecuteDataTable(insjson);
if (order.Rows.Count > 0 && int.Parse(order.Rows[0][0].ToString()) > 0)
{
var orderid = order.Rows[0][0].ToString();
if (!string.IsNullOrEmpty(_o.GiftCardCode))
{
var updatecard = "update giftcard set isused='1',usedorderid='" + orderid + "',useddate='" + DateTime.Now.ToString("yyyy-MM-dd") + "' where giftcardcode='" + _o.GiftCardCode.Replace("-", "") + "'";
MySqlHelp.ExecuteNonQuery(updatecard);
}
foreach (AllTrustUs.SquirrelPocket.Entity.OrderFruit of in _o.fruits)
{
string insof = @"insert into t_orderfruts(orderid,fruitid,name,unit,unitprice,count,price,fruitNum,cost)
values({0},{1},{2},{3},{4},{5},{6},{7},{8});";
insof = string.Format(insof,
UtilityFn.formatstring(orderid),
UtilityFn.formatstring(of.FruitID),
UtilityFn.formatstring(of.Name),
UtilityFn.formatstring(string.IsNullOrEmpty(of.unit) ? "个" : of.unit),
UtilityFn.formatstring(of.unitprice),
UtilityFn.formatstring(string.IsNullOrEmpty(of.count) ? "1" : of.count),
UtilityFn.formatstring(of.price),
UtilityFn.formatstring(of.fruitNum),
UtilityFn.formatstring(of.cost)
);
MySqlHelp.ExecuteNonQuery(insof);
}
foreach (Entity.Delivery de in _o.deliverys)
{
string insdeli = @"insert into t_delivery(orderid,date,count,status)
values({0},{1},{2},{3});select @@IDENTITY;";
insdeli = string.Format(insdeli,
UtilityFn.formatstring(orderid),
UtilityFn.formatstring(de.Date),
UtilityFn.formatstring(de.Count),
UtilityFn.formatstring("未配送"));
DataTable deliDT = MySqlHelp.ExecuteDataTable(insdeli);
if (deliDT.Rows.Count > 0 && int.Parse(deliDT.Rows[0][0].ToString()) > 0)
{
var deliID = deliDT.Rows[0][0].ToString();
foreach (Entity.Deliveryfruits def in de.Deliveryfruits)
{
string insdelif = @"insert into t_deliveryfruits(deliveryid,fruitid,name)
values({0},{1},{2});";
insdelif = string.Format(insdelif,
UtilityFn.formatstring(deliID),
UtilityFn.formatstring(def.FruitID),
UtilityFn.formatstring(def.Name));
MySqlHelp.ExecuteNonQuery(insdelif);
}
}
}
EmailHelper eh = new EmailHelper();
eh.SendMail("Squirel New Order Create", UtilityFn.JsonToHTMLTable(_o.ToJSONString()));
result = "{\"result\":\"successed\",\"orderid\":\"" + orderid + "\"}";
}
break;
case "getorder":
openid = context.Request["openid"].ToString();
var status = context.Request["status"].ToString();
List <Entity.Order> _Orders = new List <Entity.Order>();
string getsql = "select * from t_order where openid=" + UtilityFn.formatstring(openid) + " and status=" + UtilityFn.formatstring(status) + " and status<>'deleted' order by statusid asc, createdate desc";
DataTable odDT = MySqlHelp.ExecuteDataTable(getsql);
for (int i = 0; i < odDT.Rows.Count; i++)
{
Entity.Order orderentity = new Entity.Order();
orderentity.openid = odDT.Rows[i]["openid"].ToString();
orderentity.fruittype = odDT.Rows[i]["fruittype"].ToString();
orderentity.startdate = odDT.Rows[i]["startdate"].ToString();
orderentity.enddate = odDT.Rows[i]["enddate"].ToString();
orderentity.days = odDT.Rows[i]["days"].ToString();
orderentity.count = odDT.Rows[i]["count"].ToString();
orderentity.deliveryaddr = odDT.Rows[i]["deliveryaddr"].ToString();
orderentity.user = odDT.Rows[i]["user"].ToString();
orderentity.mp = odDT.Rows[i]["mp"].ToString();
orderentity.totalprice = odDT.Rows[i]["totalprice"].ToString();
orderentity.outtradeno = odDT.Rows[i]["outtradeno"].ToString();
orderentity.status = odDT.Rows[i]["status"].ToString();
orderentity.orderid = odDT.Rows[i]["orderid"].ToString();
orderentity.createdate = odDT.Rows[i]["createdate"].ToString();
orderentity.unitprice = odDT.Rows[i]["unitprice"].ToString();
orderentity.otheraddr = odDT.Rows[i]["otheraddr"].ToString();
orderentity.deduction = odDT.Rows[i]["deduction"].ToString();
orderentity.actualprice = odDT.Rows[i]["actualprice"].ToString();
string getfruitssql = "select * from t_orderfruts where orderid=" + UtilityFn.formatstring(orderentity.orderid);
DataTable frDT = MySqlHelp.ExecuteDataTable(getfruitssql);
orderentity.fruits = new List <Entity.OrderFruit>();
for (int j = 0; j < frDT.Rows.Count; j++)
{
Entity.OrderFruit ordereFruitntity = new Entity.OrderFruit();
ordereFruitntity.FruitID = frDT.Rows[j]["fruitid"].ToString();
ordereFruitntity.Name = frDT.Rows[j]["name"].ToString();
orderentity.fruits.Add(ordereFruitntity);
}
_Orders.Add(orderentity);
}
result = "{\"result\":\"successed\",\"orders\":" + JsonUtility.ToJSONString(_Orders) + "}";
break;
case "cancelorder":
string cancelorderid = context.Request["orderid"].ToString();
MySqlHelp.ExecuteNonQuery("update t_order set status='Canceled',statusid='5' where orderid=" + UtilityFn.formatstring(cancelorderid));
result = "{\"result\":\"successed\"}";
break;
case "deleteorder":
string deleteorderorderid = context.Request["orderid"].ToString();
MySqlHelp.ExecuteNonQuery("update t_order set status='Deleted',statusid='4' where orderid=" + UtilityFn.formatstring(deleteorderorderid));
result = "{\"result\":\"successed\"}";
break;
case "saveuserinfo":
string userdata = context.Request["userdata"].ToString();
openid = context.Request["openid"].ToString();
Dictionary <string, object> Dic = JsonUtility.ToDictionary(userdata);
var nickname = Dic["nickname"].ToString();
var country = Dic["country"].ToString();
var province = Dic["province"].ToString();
var city = Dic["city"].ToString();
var sex = "";
if (!string.IsNullOrEmpty(Dic["sex"].ToString()))
{
if (Dic["sex"].ToString().Contains("男"))
{
sex = "1";
}
else
{
sex = "2";
}
}
else
{
sex = "1";
}
var mp = Dic["mp"].ToString();
((WeXUser)context.Session["CurrentWeXUser"]).MP = mp;
((WeXUser)context.Session["CurrentWeXUser"]).city = city;
((WeXUser)context.Session["CurrentWeXUser"]).country = country;
((WeXUser)context.Session["CurrentWeXUser"]).nickname = nickname;
((WeXUser)context.Session["CurrentWeXUser"]).sex = sex;
((WeXUser)context.Session["CurrentWeXUser"]).province = province;
MySqlHelp.ExecuteNonQuery("update t_user set mp=" + UtilityFn.formatstring(mp)
+ ",nickname=" + UtilityFn.formatstring(nickname)
+ ",country=" + UtilityFn.formatstring(country)
+ ",province=" + UtilityFn.formatstring(province)
+ ",city=" + UtilityFn.formatstring(city)
+ ",sex=" + UtilityFn.formatstring(sex)
+ " where openid=" + UtilityFn.formatstring(openid));
//((WeXUser)context.Session["CurrentWeXUser"]).MP = mp;
result = "{\"result\":\"successed\"}";
break;
case "getDeliveryDetail":
var Deliveryorderid = context.Request["orderid"].ToString();
List <Entity.Delivery> deli = new List <Entity.Delivery>();
string Deligetsql = "select * from t_delivery where orderid=" + UtilityFn.formatstring(Deliveryorderid);
DataTable DeliDT = MySqlHelp.ExecuteDataTable(Deligetsql);
for (int i = 0; i < DeliDT.Rows.Count; i++)
{
Entity.Delivery ent = new Entity.Delivery();
ent.ID = DeliDT.Rows[i]["ID"].ToString();
ent.OrderID = Deliveryorderid;
ent.Date = DeliDT.Rows[i]["Date"].ToString();
ent.Count = DeliDT.Rows[i]["Count"].ToString();
ent.deliverystatus = DeliDT.Rows[i]["status"].ToString();
deli.Add(ent);
}
result = "{\"result\":\"successed\",\"deliverys\":" + JsonUtility.ToJSONString(deli) + "}";
break;
case "orderRefund":
string orderRefundorderid = context.Request["orderid"].ToString();
DataTable orderDT = MySqlHelp.ExecuteDataTable(string.Format("select * from t_order where orderid={0}", orderRefundorderid));
var outtradeno = orderDT.Rows[0]["outtradeno"].ToString();
var transaction_id = orderDT.Rows[0]["transaction_id"].ToString();
var totalprice = orderDT.Rows[0]["totalprice"].ToString();
var actualprice = orderDT.Rows[0]["actualprice"].ToString();
try
{
string Refundresult = Refund.Run(transaction_id, outtradeno, (int.Parse(actualprice) * 100).ToString(), (int.Parse(actualprice) * 100).ToString());
Dictionary <string, object> di = JsonUtility.ToDictionary(Refundresult);
EmailHelper eh = new EmailHelper();
if (di["result_code"].ToString().ToUpper() == "FAIL")
{
result = "{\"result\":\"failed\"}";
eh.SendMail("Squirel Refunded Order failed[" + orderRefundorderid + "]", UtilityFn.JsonToHTMLTable(Refundresult));
}
else
{
result = "{\"result\":\"successed\"}";
MySqlHelp.ExecuteNonQuery(string.Format("update t_order set status='Refunded',statusid='100' where orderid={0}", orderRefundorderid));
eh.SendMail("Squirel Refunded Order Successed[" + orderRefundorderid + "]", UtilityFn.JsonToHTMLTable(Refundresult));
}
Log.Info(this.GetType().ToString(), Refundresult);
//Response.Write("<span style='color:#00CD00;font-size:20px'>" + result + "</span>");
}
catch (WxPayException ex)
{
result = "{\"result\":\"failed\"}";
//Response.Write("<span style='color:#FF0000;font-size:20px'>" + ex.ToString() + "</span>");
}
catch (Exception ex)
{
result = "{\"result\":\"failed\"}";
//Response.Write("<span style='color:#FF0000;font-size:20px'>" + ex.ToString() + "</span>");
}
break;
case "getgiftcode":
string giftcode = context.Request["giftcode"].ToString().Replace("-", "");
DataTable giftcodeDT = MySqlHelp.ExecuteDataTable(string.Format("select * from giftcard where isused='0' and giftcardcode='{0}'", giftcode));
if (giftcodeDT.Rows.Count > 0)
{
Giftcard gc = new Giftcard();
gc.id = Convert.ToInt32(giftcodeDT.Rows[0]["id"]);
gc.giftcardcode = giftcodeDT.Rows[0]["giftcardcode"].ToString();
gc.amount = giftcodeDT.Rows[0]["amount"].ToString();
gc.generatedate = giftcodeDT.Rows[0]["generatedate"].ToString();
gc.isused = giftcodeDT.Rows[0]["isused"].ToString();
gc.usedorderid = giftcodeDT.Rows[0]["usedorderid"].ToString();
gc.useddate = giftcodeDT.Rows[0]["useddate"].ToString();
gc.forcompany = giftcodeDT.Rows[0]["forcompany"].ToString();
gc.expireddate = giftcodeDT.Rows[0]["expireddate"].ToString();
result = "{\"result\":\"successed\",\"giftcard\":" + JsonUtility.ToJSONString(gc) + "}";
}
else
{
result = "{\"result\":\"failed\"}";
}
break;
default:
break;
}
}
context.Response.Write(result);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Charset = "utf-8";
string Action = context.Request["Action"].ToString();
var conditions = context.Request["conditions"];
var deliveryid = context.Request["deliveryid"];
var orderid = context.Request["orderid"];
string result = string.Empty;
var querySQL = string.Empty;
List <Entity.DeliveryReport> _DeliveryReport = new List <Entity.DeliveryReport>();
DataTable odDT = new DataTable();
if (!string.IsNullOrEmpty(Action))
{
switch (Action.ToLower())
{
case "getdeliverys":
querySQL = @"select
tor.outtradeno as 'orderid',
td.id as 'deliveryid',
td.status as 'deliverystatus',
tor.openid,
tu.nickname,
tor.fruittype,
tor.count,
tor.deliveryaddr,
tor.user,
tor.mp,
td.date,
GROUP_CONCAT(tdf.name) as 'fruits'
from t_order tor
inner join t_delivery td
on tor.orderid=td.orderid and tor.status='PaidSuccessed'
inner join t_deliveryfruits tdf
on tdf.deliveryid=td.id
inner join t_user tu
on tu.openid=tor.openid
group by
tor.outtradeno,
tor.openid,
tu.nickname,
tor.fruittype,
tor.count,
tor.deliveryaddr,
tor.user,
tor.mp,
td.date
order by td.date
";
odDT = MySqlHelp.ExecuteDataTable(querySQL);
for (int i = 0; i < odDT.Rows.Count; i++)
{
Entity.DeliveryReport orderentity = new Entity.DeliveryReport();
orderentity.orderid = odDT.Rows[i]["orderid"].ToString();
orderentity.openid = odDT.Rows[i]["openid"].ToString();
orderentity.nickname = odDT.Rows[i]["nickname"].ToString();
orderentity.fruittype = odDT.Rows[i]["fruittype"].ToString();
orderentity.count = odDT.Rows[i]["count"].ToString();
orderentity.deliveryaddr = odDT.Rows[i]["deliveryaddr"].ToString();
orderentity.user = odDT.Rows[i]["user"].ToString();
orderentity.date = odDT.Rows[i]["date"].ToString();
orderentity.mp = odDT.Rows[i]["mp"].ToString();
orderentity.fruits = odDT.Rows[i]["fruits"].ToString();
orderentity.deliveryid = odDT.Rows[i]["deliveryid"].ToString();
orderentity.deliverystatus = odDT.Rows[i]["deliverystatus"].ToString();
_DeliveryReport.Add(orderentity);
}
result = "{\"result\":\"successed\",\"orders\":" + JsonUtility.ToJSONString(_DeliveryReport) + "}";
break;
case "getgiftboxdelivery":
querySQL = @"select
tor.outtradeno as 'orderid',
tor.openid,
tu.nickname,
tor.fruittype,
tor.startdate,
tor.count,
tor.deliveryaddr,
tor.user,
tor.mp,
tor.deliverystatus,
GROUP_CONCAT(CONCAT(tof.name,tof.fruitNum * tof.count ,tof.unit,' (',CAST(tof.count AS char),'份)' ) )as 'fruits',
tor.GiftCardCode,
tor.ExpressNumber
from t_order tor
inner join t_orderfruts tof
on tof.orderid=tor.orderid and tor.status in('PaidSuccessed','Completed') and fruittype like '%礼盒%'
inner join t_user tu
on tu.openid=tor.openid
group by
tor.outtradeno
order by startdate
";
odDT = MySqlHelp.ExecuteDataTable(querySQL);
for (int i = 0; i < odDT.Rows.Count; i++)
{
Entity.DeliveryReport orderentity = new Entity.DeliveryReport();
orderentity.orderid = odDT.Rows[i]["orderid"].ToString();
orderentity.openid = odDT.Rows[i]["openid"].ToString();
orderentity.nickname = odDT.Rows[i]["nickname"].ToString();
orderentity.fruittype = odDT.Rows[i]["fruittype"].ToString();
orderentity.date = odDT.Rows[i]["startdate"].ToString();
orderentity.count = odDT.Rows[i]["count"].ToString();
orderentity.deliveryaddr = odDT.Rows[i]["deliveryaddr"].ToString();
orderentity.user = odDT.Rows[i]["user"].ToString();
orderentity.mp = odDT.Rows[i]["mp"].ToString();
orderentity.fruits = odDT.Rows[i]["fruits"].ToString();
orderentity.deliverystatus = odDT.Rows[i]["deliverystatus"].ToString();
orderentity.ExpressNumber = odDT.Rows[i]["ExpressNumber"].ToString();
orderentity.GiftCardCode = odDT.Rows[i]["GiftCardCode"].ToString();
_DeliveryReport.Add(orderentity);
}
result = "{\"result\":\"successed\",\"orders\":" + JsonUtility.ToJSONString(_DeliveryReport) + "}";
break;
case "getcommunitydelivery":
querySQL = @"select
tor.outtradeno as 'orderid',
tor.openid,
tu.nickname,
tor.fruittype,
tor.startdate,
tor.count,
tor.deliveryaddr,
tor.user,
tor.mp,
tor.deliverystatus,
GROUP_CONCAT(CONCAT(tof.name,tof.fruitNum * tof.count ,tof.unit ) ) as 'fruits',
tor.GiftCardCode,
tor.ExpressNumber,
tor.actualprice,
tor.status,
tor.agencylevel,
tor.discount,
tor.rebate
from t_order tor
inner join t_orderfruts tof
on tof.orderid=tor.orderid and tor.status in('PaidSuccessed','Completed','NotPaid') and fruittype like '%社区%'
inner join t_user tu
on tu.openid=tor.openid
group by
tor.outtradeno
order by startdate
";
odDT = MySqlHelp.ExecuteDataTable(querySQL);
for (int i = 0; i < odDT.Rows.Count; i++)
{
Entity.DeliveryReport orderentity = new Entity.DeliveryReport();
orderentity.orderid = odDT.Rows[i]["orderid"].ToString();
orderentity.openid = odDT.Rows[i]["openid"].ToString();
orderentity.nickname = odDT.Rows[i]["nickname"].ToString();
orderentity.fruittype = odDT.Rows[i]["fruittype"].ToString();
orderentity.date = odDT.Rows[i]["startdate"].ToString();
orderentity.count = odDT.Rows[i]["count"].ToString();
orderentity.deliveryaddr = odDT.Rows[i]["deliveryaddr"].ToString();
orderentity.user = odDT.Rows[i]["user"].ToString();
orderentity.mp = odDT.Rows[i]["mp"].ToString();
orderentity.fruits = odDT.Rows[i]["fruits"].ToString();
orderentity.deliverystatus = odDT.Rows[i]["deliverystatus"].ToString();
orderentity.ExpressNumber = odDT.Rows[i]["ExpressNumber"].ToString();
orderentity.GiftCardCode = odDT.Rows[i]["GiftCardCode"].ToString();
orderentity.actualprice = odDT.Rows[i]["actualprice"].ToString();
orderentity.status = odDT.Rows[i]["status"].ToString();
orderentity.agencylevel = odDT.Rows[i]["agencylevel"].ToString();
orderentity.discount = odDT.Rows[i]["discount"].ToString();
orderentity.rebate = odDT.Rows[i]["rebate"].ToString();
_DeliveryReport.Add(orderentity);
}
result = "{\"result\":\"successed\",\"orders\":" + JsonUtility.ToJSONString(_DeliveryReport) + "}";
break;
case "getfruitsestimate":
querySQL = @"
select * from
(
select
td.date,
tdf.name as fruits,
sum(tor.count*150) as count,
'g' as unit
from t_order tor
inner join t_delivery td
on tor.orderid=td.orderid and tor.status='PaidSuccessed' and tor.fruittype<>'精品礼盒DIY'
inner join t_deliveryfruits tdf
on td.id=tdf.deliveryid
group by
td.date,
tdf.name
union
select
tor.startdate as 'date',
tof.name as fruits,
sum(tof.fruitNum * tof.count* tor.count) as 'count',
tof.unit
from t_order tor
inner join t_orderfruts tof
on tof.orderid=tor.orderid and tor.status='PaidSuccessed' and fruittype='精品礼盒DIY'
inner join t_user tu
on tu.openid=tor.openid
group by
tor.startdate,
tof.name,
tof.unit
)T
order by date";
odDT = MySqlHelp.ExecuteDataTable(querySQL);
for (int i = 0; i < odDT.Rows.Count; i++)
{
Entity.DeliveryReport orderentity = new Entity.DeliveryReport();
orderentity.date = odDT.Rows[i]["date"].ToString();
orderentity.fruits = odDT.Rows[i]["fruits"].ToString();
orderentity.count = odDT.Rows[i]["count"].ToString();
orderentity.unit = odDT.Rows[i]["unit"].ToString();
_DeliveryReport.Add(orderentity);
}
result = "{\"result\":\"successed\",\"orders\":" + JsonUtility.ToJSONString(_DeliveryReport) + "}";
break;
case "getcommunityfruitsestimate":
querySQL = @"select * from
(
select
tor.status,
tor.deliveryaddr,
tor.startdate as 'date',
tof.name as fruits,
sum(tof.fruitNum * tof.count* tor.count) as 'count',
tof.unit
from t_order tor
inner join t_orderfruts tof
on tof.orderid=tor.orderid and fruittype like '%社区%'
inner join t_user tu
on tu.openid=tor.openid
group by
tor.status,
tor.startdate,
tof.name,
tof.unit,
deliveryaddr
)T
order by date";
odDT = MySqlHelp.ExecuteDataTable(querySQL);
for (int i = 0; i < odDT.Rows.Count; i++)
{
Entity.DeliveryReport orderentity = new Entity.DeliveryReport();
orderentity.date = odDT.Rows[i]["date"].ToString();
orderentity.fruits = odDT.Rows[i]["fruits"].ToString();
orderentity.count = odDT.Rows[i]["count"].ToString();
orderentity.unit = odDT.Rows[i]["unit"].ToString();
orderentity.deliveryaddr = odDT.Rows[i]["deliveryaddr"].ToString();
orderentity.status = odDT.Rows[i]["status"].ToString();
_DeliveryReport.Add(orderentity);
}
result = "{\"result\":\"successed\",\"orders\":" + JsonUtility.ToJSONString(_DeliveryReport) + "}";
break;
case "singledelivery":
DataTable checkdt = MySqlHelp.ExecuteDataTable(string.Format(@"update t_delivery set status='已配送'
where id={0};
select 1 from t_order tor
inner join t_delivery td
on td.orderid=tor.orderid
where td.status='未配送' and tor.outtradeno='{1}'", deliveryid, orderid));
if (checkdt.Rows.Count <= 0)
{
MySqlHelp.ExecuteNonQuery("update t_order set status='Completed',statusid='3' where outtradeno=" + UtilityFn.formatstring(orderid));
}
result = "{\"result\":\"successed\"}";
break;
case "bodelivery":
MySqlHelp.ExecuteNonQuery("update t_order set deliverystatus='已配送',status='Completed',statusid='3' where outtradeno=" + UtilityFn.formatstring(deliveryid));
result = "{\"result\":\"successed\"}";
break;
case "changeexpressnumber":
var ExpressNumber = context.Request["ExpressNumber"];
MySqlHelp.ExecuteNonQuery("update t_order set ExpressNumber=" + UtilityFn.formatstring(ExpressNumber) + " where outtradeno=" + UtilityFn.formatstring(orderid));
result = "{\"result\":\"successed\"}";
break;
default:
break;
}
}
context.Response.Write(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
canRefund = false;
order_id = Request.QueryString["order_id"];
OrderPay = new Entity.Order();
DataSet orderDS = MySqlHelp.ExecuteDataSet(string.Format("select * from t_order where orderid={0};select * from t_orderfruts where orderid={0};", order_id));
if (orderDS.Tables.Count == 2)
{
OrderPay.openid = orderDS.Tables[0].Rows[0]["openid"].ToString();
OrderPay.fruittype = orderDS.Tables[0].Rows[0]["fruittype"].ToString();
OrderPay.startdate = orderDS.Tables[0].Rows[0]["startdate"].ToString();
OrderPay.enddate = orderDS.Tables[0].Rows[0]["enddate"].ToString();
OrderPay.days = orderDS.Tables[0].Rows[0]["days"].ToString();
OrderPay.count = orderDS.Tables[0].Rows[0]["count"].ToString();
OrderPay.deliveryaddr = orderDS.Tables[0].Rows[0]["deliveryaddr"].ToString();
OrderPay.user = orderDS.Tables[0].Rows[0]["user"].ToString();
OrderPay.mp = orderDS.Tables[0].Rows[0]["mp"].ToString();
OrderPay.totalprice = orderDS.Tables[0].Rows[0]["totalprice"].ToString();
OrderPay.outtradeno = orderDS.Tables[0].Rows[0]["outtradeno"].ToString();
OrderPay.createdate = orderDS.Tables[0].Rows[0]["createdate"].ToString();
OrderPay.unitprice = orderDS.Tables[0].Rows[0]["unitprice"].ToString();
OrderPay.deliverystatus = orderDS.Tables[0].Rows[0]["deliverystatus"].ToString();
OrderPay.otheraddr = orderDS.Tables[0].Rows[0]["otheraddr"].ToString();
OrderPay.deduction = orderDS.Tables[0].Rows[0]["deduction"].ToString();
OrderPay.actualprice = orderDS.Tables[0].Rows[0]["actualprice"].ToString();
OrderPay.ExpressNumber = orderDS.Tables[0].Rows[0]["ExpressNumber"].ToString();
switch (orderDS.Tables[0].Rows[0]["status"].ToString())
{
case "NotPaid":
OrderPay.status = "未支付";
break;
case "PaidSuccessed":
OrderPay.status = "已支付";
if (DateTime.Compare(DateTime.Now, Convert.ToDateTime(OrderPay.startdate)) < 0)
{
canRefund = true;
}
break;
case "Completed":
OrderPay.status = "已完成";
break;
case "Canceled":
OrderPay.status = "已取消";
break;
case "Expiry":
OrderPay.status = "已过期";
break;
case "Refunded":
OrderPay.status = "已退款";
break;
default:
break;
}
for (int i = 0; i < orderDS.Tables[1].Rows.Count; i++)
{
if (OrderPay.fruittype.Contains("社区预定"))
//{
// Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString() + ";";
//}
//else
{
Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString()
+ (Convert.ToInt32(orderDS.Tables[1].Rows[i]["fruitNum"]) * Convert.ToInt32(orderDS.Tables[1].Rows[i]["count"])).ToString()
+ orderDS.Tables[1].Rows[i]["unit"] + ";";
divunit.Visible = false;
divdelivery.Visible = false;
divdeliverystatus.Visible = true;
}
}
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string code = context.Request.QueryString["code"];
context.Response.AddHeader("Access-Control-Allow-Origin", "*");
//context.Response.Write("AuthorizationCheckByCodeHandler:" + code);
string RedirectPage = "";
string returnresult = "{\"result:\":\"{0}\",\"RedirectPage\":\"{1}\"}";
try
{
//构造获取openid及access_token的url
WxPayData data = new WxPayData();
data.SetValue("appid", WxPayConfig.APPID);
data.SetValue("secret", WxPayConfig.APPSECRET);
data.SetValue("code", code);
data.SetValue("grant_type", "authorization_code");
string url = "https://api.weixin.qq.com/sns/oauth2/access_token?" + data.ToUrl();
Log.Debug(this.GetType().ToString(), "GetOpenidAndAccessTokenFromCode url : " + url);
//请求url以获取数据
string result = HttpService.Get(url);
Log.Debug(this.GetType().ToString(), "GetOpenidAndAccessTokenFromCode response : " + result);
//保存access_token，用于收货地址获取
JsonData jd = JsonMapper.ToObject(result);
Log.Debug(this.GetType().ToString(), "GetOpenidAndAccessTokenFromCode Result : " + result);
var access_token = (string)jd["access_token"];
//Response.Write(result);
//获取用户openid
var openid = (string)jd["openid"];
WxPayData dataUserInfo = new WxPayData();
dataUserInfo.SetValue("access_token", access_token);
dataUserInfo.SetValue("openid", openid);
DataTable checkuserDT = MySqlHelp.ExecuteDataTable(@"select tu.*
,
CASE
WHEN la.agencylevel is null THEN 'L0'
ELSE la.agencylevel
END as 'agencylevel',
CASE
WHEN la.agencylevel is null THEN '1'
ELSE la.discount
END as 'discount'
from t_user tu
left join t_agencylevel la
on tu.id=la.userid and la.enabled='1'
where tu.openid=" + UtilityFn.formatstring(openid));
//数据库里是否有用户信息
if (checkuserDT.Rows.Count > 0)
{
if (FormatWeXUser(checkuserDT, context))
{
var ActionPage = context.Request.QueryString["ActionPage"];
if (!string.IsNullOrEmpty(ActionPage))
{
//Response.Redirect(ActionPage, false);
RedirectPage = ActionPage;
}
else
{
//Response.Redirect("home.aspx", false);
RedirectPage = "home.aspx";
}
}
else
{
//Response.Redirect("/Order/MyInfoPage.aspx", false);
RedirectPage = "/Order/MyInfoPage.aspx";
}
//Log.Info("Get User End", "=========" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
//Response.Redirect("home.aspx", false);
}
else
{
//Response.Redirect("login.aspx", false);
RedirectPage = "login.aspx";
}
//Response.Write(result);
//Log.Debug(this.GetType().ToString(), "Get openid : " + openid);
//Log.Debug(this.GetType().ToString(), "Get access_token : " + access_token);
context.Response.Write("{\"result:\":\"success\",\"RedirectPage\":\"" + RedirectPage + "\"}");
}
catch (Exception ex)
{
Log.Error(this.GetType().ToString(), ex.ToString());
//throw new WxPayException(ex.ToString());
context.Response.Write("{\"result:\":\"failed\",\"RedirectPage\":\"\"}");
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Charset = "utf-8";
string Action = context.Request["Action"].ToString();
string result = "{\"result\":\"failed\"}";
if (!string.IsNullOrEmpty(Action))
{
Auth auth = new Token(CurToken); // Auth auth = new Sign("app_id", "app_secret");
YZClient yzClient = new DefaultYZClient(auth);
Dictionary <string, object> dict;
switch (Action)
{
case "getgiftcard":
dict = new System.Collections.Generic.Dictionary <string, object>();
dict.Add("page_no", 1);
dict.Add("page_size", 100);
//dict.Add("status", "ON");
dict.Add("group_type", "PROMOCODE");
result = yzClient.Invoke("youzan.ump.coupon.search", "3.0.0", "POST", dict, null);
break;
case "giftcardtake":
string _openid = context.Request["openid"].ToString();
string _mobile = context.Request["mobile"].ToString();
string _name = context.Request["name"].ToString();
string _cardcode = context.Request["cardcode"].ToString();
int _PROMOCODEid;
string getsql = "select * from giftcard where giftcardcode = '" + _cardcode + "'";
DataTable odDT = MySqlHelp.ExecuteDataTable(getsql);
if (odDT.Rows.Count > 0)
{
if (odDT.Rows[0]["enabled"].ToString() == "0")
{
result = "{\"response\": {\"issuccess\": 0,\"msg\": \"该礼品卡暂不可用，请联系公司负责人!\"}}";
}
else if (odDT.Rows[0]["isused"].ToString() == "1")
{
result = "{\"response\": {\"issuccess\": 0,\"msg\": \"该礼品卡已被领用，不能重复注册!\"}}";
}
else
{
try
{
_PROMOCODEid = Convert.ToInt32(odDT.Rows[0]["PromoId"]);
dict = new System.Collections.Generic.Dictionary <string, object>();
dict.Add("mobile", _mobile);
dict.Add("coupon_group_id", _PROMOCODEid);
result = yzClient.Invoke("youzan.ump.coupon.take", "3.0.0", "POST", dict, null);
InvokeResponse Response = JsonUtility.Deserialize <InvokeResponse>(result);
if (Response.error_response == null && Response.response != null && Response.response.coupon_type == "PROMOCODE")
{
var updatecard = "update giftcard set isused='1',useddate='" + DateTime.Now.ToString("yyyy-MM-dd") + "',usedmobile='" + _mobile + "',usedopenid='" + _openid + "',usedname='" + _name + "' where giftcardcode='" + _cardcode.Replace("-", "") + "'";
MySqlHelp.ExecuteNonQuery(updatecard);
DataTable dt = MySqlHelp.ExecuteDataTable("select jumpurl from giftcard where giftcardcode='" + _cardcode.Replace("-", "") + "'");
result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"验证成功!\",\"jumpurl\":\"" + dt.Rows[0]["jumpurl"].ToString() + "\"}}";
}
else
{
result = "{\"response\": {\"issuccess\": \"0\",\"msg\": \"" + Response.error_response.msg + "\"}}";
}
}
catch (Exception ex)
{
result = "{\"response\": {\"issuccess\": 0,\"msg\": \"" + ex.Message + "!\"}}";
}
}
}
else
{
result = "{\"response\": {\"issuccess\": 0,\"msg\": \"礼品卷不存在，请验证礼品卷码是否填写正确!\"}}";
}
break;
case "giftcardtakelist":
DataTable dttakelist = MySqlHelp.ExecuteDataTable("select * from giftcard");
result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"验证成功!\",\"giftcardlist\":" + formatgiftcard(dttakelist) + "}}";
break;
case "cardactive":
string _ids1 = context.Request["ids"].ToString();
MySqlHelp.ExecuteNonQuery("update giftcard set enabled=1 where id in (" + _ids1 + ")and isused = 0");
result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"验证成功!\"}}";
break;
case "cardinactive":
string _ids2 = context.Request["ids"].ToString();
MySqlHelp.ExecuteNonQuery("update giftcard set enabled=0 where id in (" + _ids2 + ") and isused = 0");
result = "{\"response\": {\"issuccess\": \"1\",\"msg\": \"验证成功!\"}}";
break;
default:
break;
}
}
context.Response.Write(result);
}
/// <summary>
/// 数据库查询操作
/// </summary>
/// <param name="conn">数据库连接</param>
/// <param name="sql">查询语句</param>
/// <param name="parameters">参数列表化</param>
/// <returns>DataTable结果集</returns>
public DataTable Select(string conn, string sql, params MySqlParameter[] parameters)
{
return(MySqlHelp.Select(conn, sql, parameters));
}
/// <summary>
/// 数据库查询操作，返回结果集第一行的第一列
/// </summary>
/// <param name="conn">数据库连接</param>
/// <param name="sql">查询语句</param>
/// <param name="parameters">参数列表化</param>
/// <returns>DataTable结果集</returns>
public object SelectOne(string conn, string sql, params MySqlParameter[] parameters)
{
return(MySqlHelp.SelectOne(conn, sql, parameters));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string openid = Request.QueryString["openid"];
string total_fee = Request.QueryString["total_fee"];
order_id = Request.QueryString["order_id"];
string ActualPay = ConfigurationManager.AppSettings["ActualPay"].ToString();
OrderPay = new Entity.Order();
DataSet orderDS = MySqlHelp.ExecuteDataSet(string.Format("select * from t_order where orderid={0};select * from t_orderfruts where orderid={0};", order_id));
if (orderDS.Tables.Count == 2)
{
if (orderDS.Tables[0].Rows[0]["status"].ToString() != "NotPaid")
{
return;
}
OrderPay.fruittype = orderDS.Tables[0].Rows[0]["fruittype"].ToString();
OrderPay.startdate = orderDS.Tables[0].Rows[0]["startdate"].ToString();
OrderPay.enddate = orderDS.Tables[0].Rows[0]["enddate"].ToString();
OrderPay.days = orderDS.Tables[0].Rows[0]["days"].ToString();
OrderPay.count = orderDS.Tables[0].Rows[0]["count"].ToString();
OrderPay.deliveryaddr = orderDS.Tables[0].Rows[0]["deliveryaddr"].ToString();
OrderPay.user = orderDS.Tables[0].Rows[0]["user"].ToString();
OrderPay.mp = orderDS.Tables[0].Rows[0]["mp"].ToString();
OrderPay.totalprice = orderDS.Tables[0].Rows[0]["totalprice"].ToString();
OrderPay.outtradeno = orderDS.Tables[0].Rows[0]["outtradeno"].ToString();
OrderPay.createdate = orderDS.Tables[0].Rows[0]["createdate"].ToString();
OrderPay.unitprice = orderDS.Tables[0].Rows[0]["unitprice"].ToString();
OrderPay.deduction = orderDS.Tables[0].Rows[0]["deduction"].ToString();
OrderPay.actualprice = orderDS.Tables[0].Rows[0]["actualprice"].ToString();
for (int i = 0; i < orderDS.Tables[1].Rows.Count; i++)
{
if (OrderPay.fruittype.Contains("社区预定"))
//{
// Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString() + ";";
//}
//else
{
Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString()
+ (Convert.ToInt32(orderDS.Tables[1].Rows[i]["fruitNum"]) * Convert.ToInt32(orderDS.Tables[1].Rows[i]["count"])).ToString()
+ orderDS.Tables[1].Rows[i]["unit"] + ";";
divunit.Visible = false;
divdelivery.Visible = false;
}
}
}
else
{
return;
}
//return;
//检测是否给当前页面传递了相关参数
if (string.IsNullOrEmpty(openid) || string.IsNullOrEmpty(total_fee) || string.IsNullOrEmpty(order_id))
{
Response.Write("<span style='color:#FF0000;font-size:20px'>" + "页面传参出错,请返回重试" + "</span>");
Log.Error(this.GetType().ToString(), "This page have not get params, cannot be inited, exit...");
//submit.Visible = false;
return;
}
//若传递了相关参数，则调统一下单接口，获得后续相关接口的入口参数
JsApiPay jsApiPay = new JsApiPay(this);
jsApiPay.openid = openid;
try
{
if (Convert.ToBoolean(ActualPay))
{
jsApiPay.total_fee = int.Parse(total_fee);
}
else
{
jsApiPay.total_fee = 1;
}
}
catch (Exception ex)
{
Response.Write(ex.Message + ex.StackTrace);
}
//jsApiPay.total_fee = 1;
//JSAPI支付预处理
WxPayData unifiedOrderResult = new WxPayData();
try
{
unifiedOrderResult = jsApiPay.GetUnifiedOrderResult(OrderPay.outtradeno);
wxJsApiParam = jsApiPay.GetJsApiParameters();//获取H5调起JS API参数
Log.Debug(this.GetType().ToString(), "wxJsApiParam : " + wxJsApiParam);
//在页面上显示订单信息
//Response.Write("<span style='color:#00CD00;font-size:20px'>订单详情：</span><br/>");
//Response.Write("<span style='color:#00CD00;font-size:20px'>" + unifiedOrderResult.ToPrintStr() + "</span>");
}
catch (Exception ex)
{
Response.Write("<span style='color:#FF0000;font-size:20px;margin-left:10px'>" + "初始化失败，无法支付，请返回重试。" + "</span>");
//Response.Write("<span style='color:#00CD00;font-size:20px'>" + unifiedOrderResult.ToPrintStr() + "</span>");
//Response.Write("wxJsApiParam : " + wxJsApiParam);
divbutton.Visible = false;
}
}
}
