public object GetUserOrderPayStatus(string orderno)
{
string errmsg = null;
if (userLoginManager.LoginUser == null || userLoginManager.LoginUser.UserID < 1)
{
return new { Rcode = -2, Rmsg = "未登录" }
}
;
if (string.IsNullOrEmpty(orderno))
{
return new { Rcode = 0, Rmsg = "参数错误" }
}
;
chosen_orderinfo orderinfo = OrderPayBLL.GetUserOrderInfo(orderno, out errmsg);
if (!string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "获取订单数据错误" + errmsg }
}
;
if (orderinfo == null)
{
return new { Rcode = -1, Rmsg = "订单号不存在" }
}
;
return(new { Rcode = 1, Rdata = orderinfo.status });
}
/// <summary>
/// 订单管理 添加数据
/// </summary>
/// <param name="chosen_orderinfo">要添加的订单管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(chosen_orderinfo info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("orderno", info.orderno));
pars.Add(new DataParameter("ordername", info.ordername));
pars.Add(new DataParameter("userid", info.userid));
pars.Add(new DataParameter("customerid", info.customerid));
pars.Add(new DataParameter("serviceno", info.serviceno));
pars.Add(new DataParameter("feetype", info.feetype));
pars.Add(new DataParameter("m_price", info.m_price));
pars.Add(new DataParameter("s_price", info.s_price));
pars.Add(new DataParameter("addressid", info.addressid));
pars.Add(new DataParameter("ctype", info.ctype));
pars.Add(new DataParameter("paytype", info.paytype));
pars.Add(new DataParameter("paybank", info.paybank));
pars.Add(new DataParameter("payno", info.payno));
pars.Add(new DataParameter("createdtime", info.createdtime));
pars.Add(new DataParameter("paytime", info.paytime));
pars.Add(new DataParameter("payresulttime", info.payresulttime));
pars.Add(new DataParameter("deliverytime", info.deliverytime));
pars.Add(new DataParameter("deliveryoktime", info.deliveryoktime));
pars.Add(new DataParameter("logisticaltype", info.logisticaltype));
pars.Add(new DataParameter("logisticalcode", info.logisticalcode));
pars.Add(new DataParameter("status", info.status));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("terminaltype", info.terminaltype));
string sqlstr = "insert into chosen_orderinfo (orderno,ordername,userid,customerid,serviceno,feetype,m_price,s_price,addressid,ctype,paytype,paybank,payno,createdtime,paytime,payresulttime,deliverytime,deliveryoktime,logisticaltype,logisticalcode,status,creator,terminaltype) values (@orderno,@ordername,@userid,@customerid,@serviceno,@feetype,@m_price,@s_price,@addressid,@ctype,@paytype,@paybank,@payno,@createdtime,@paytime,@payresulttime,@deliverytime,@deliveryoktime,@logisticaltype,@logisticalcode,@status,@creator,@terminaltype) ";
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 订单管理 更新数据
/// </summary>
/// <param name="chosen_orderinfo">要更新的订单管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(chosen_orderinfo info, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
//pars.Add(new DataParameter("orderno", info.orderno));
pars.Add(new DataParameter("ordername", info.ordername));
pars.Add(new DataParameter("userid", info.userid));
pars.Add(new DataParameter("customerid", info.customerid));
pars.Add(new DataParameter("serviceno", info.serviceno));
pars.Add(new DataParameter("feetype", info.feetype));
pars.Add(new DataParameter("m_price", info.m_price));
pars.Add(new DataParameter("s_price", info.s_price));
pars.Add(new DataParameter("addressid", info.addressid));
pars.Add(new DataParameter("ctype", info.ctype));
pars.Add(new DataParameter("paytype", info.paytype));
pars.Add(new DataParameter("paybank", info.paybank));
pars.Add(new DataParameter("payno", info.payno));
pars.Add(new DataParameter("createdtime", info.createdtime));
pars.Add(new DataParameter("paytime", info.paytime));
pars.Add(new DataParameter("payresulttime", info.payresulttime));
pars.Add(new DataParameter("deliverytime", info.deliverytime));
pars.Add(new DataParameter("deliveryoktime", info.deliveryoktime));
pars.Add(new DataParameter("logisticaltype", info.logisticaltype));
pars.Add(new DataParameter("logisticalcode", info.logisticalcode));
pars.Add(new DataParameter("status", info.status));
pars.Add(new DataParameter("creator", info.creator));
pars.Add(new DataParameter("terminaltype", info.terminaltype));
string sqlstr = "update chosen_orderinfo set orderno=@orderno,ordername=@ordername,userid=@userid,customerid=@customerid,serviceno=@serviceno,feetype=@feetype,m_price=@m_price,s_price=@s_price,addressid=@addressid,ctype=@ctype,paytype=@paytype,paybank=@paybank,payno=@payno,createdtime=@createdtime,paytime=@paytime,payresulttime=@payresulttime,deliverytime=@deliverytime,deliveryoktime=@deliveryoktime,logisticaltype=@logisticaltype,logisticalcode=@logisticalcode,status=@status,creator=@creator,terminaltype=@terminaltype where orderno=@orderno ";
pars.Add(new DataParameter("orderno", info.orderno));
return(MySqlHelper.ExecuteCommand(sqlstr, out errmsg, pars) > 0);
}
/// <summary>
/// 订单管理 添加数据
/// </summary>
public object Post([FromBody] chosen_orderinfo info)
{
string datenum = DateTime.Now.ToString("yyyyMMddhh24mmss");
Random rd = new Random();
string sjnum = rd.Next(1000000, 10000000).ToString();
string ordernum = datenum + sjnum;
info.orderno = ordernum;
info.createdtime = DateTime.Now;
info.creator = LoginUserData.UserID;
info.userid = LoginUserData.UserID;
info.feetype = "1";
info.ctype = 1;
info.status = 1;
info.terminaltype = 1;
info.addressid = 0;
bool success = orderinfoBLL.Add(info, out errmsg);
WriteSysLog(0, string.Format("添加订单{0}，返回{1} {2}", info.ordername, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "添加失败" }
}
;
return(new { Rcode = 1, Rmsg = "添加成功" });
}
/// <summary>
/// 订单管理 详情查询
/// </summary>
public object Get(string id)
{
chosen_orderinfo info = orderinfoBLL.GetInfo(id, out errmsg)
; if (!string.IsNullOrEmpty(errmsg))
{
return(new { Rcode = -1, Rmsg = "获取数据失败" });
}
return(new { Rcode = 1, Rdata = info });
}
/// <summary>
/// 订单管理 更新数据
/// </summary>
public object Put(string id, [FromBody] chosen_orderinfo info)
{
info.orderno = id;
info.createdtime = DateTime.Now;
info.creator = LoginUserData.UserID;
bool success = orderinfoBLL.Update(info, out errmsg);
WriteSysLog(1, string.Format("更新订单id为{0}，返回{1} {2}", id, success, errmsg));
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "更新失败" }
}
;
return(new { Rcode = 1, Rmsg = "更新成功" });
}
public object InsertOrdersInfo(int m_price, string title)
{
string errmsg = null;
chosen_orderinfo info = new chosen_orderinfo();
string datenum = DateTime.Now.ToString("yyyyMMddhh24mmss");
Random rd = new Random();
string sjnum = rd.Next(1000000, 10000000).ToString();
string ordernum = datenum + sjnum;
info.orderno = ordernum; //订单编号
info.ordername = title; //订单名称
info.createdtime = DateTime.Now; //下单时间
if (userLoginManager.LoginUser == null || userLoginManager.LoginUser.UserID < 1)
{
return new { Rcode = 0, Rmsg = "未登录" }
}
;
info.userid = userLoginManager.LoginUser.UserID; //用户账户
info.creator = userLoginManager.LoginUser.UserID; //客户账户
info.feetype = "1"; //货币类型
info.ctype = 1; //下单方式
info.status = 1; //支付状态
info.terminaltype = 1; //操作终端
info.addressid = 0; //收货地址编号
info.paybank = 0;
info.m_price = m_price;
info.s_price = m_price;
info.paytype = 2;
bool success = BLL.UserLoginManager.AdduserOrders(info, out errmsg);
if (!success || !string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "添加失败" }
}
;
return(new { Rcode = 1, Rmsg = "添加成功" });
}
internal static bool AdduserOrders(chosen_orderinfo info, out string errmsg)
{
return(DAL.UserAccountDAL.AdduserOrders(info, out errmsg));
}
/// <summary>
/// 订单管理 更新数据
/// </summary>
/// <param name="chosen_orderinfo">要更新的订单管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Update(chosen_orderinfo info, out string errmsg)
{
return(orderinfoDAL.Update(info, out errmsg));
}
/// <summary>
/// 订单管理 添加数据
/// </summary>
/// <param name="chosen_orderinfo">要添加的订单管理对象</param>
/// <param name="errmsg">错误信息</param>
/// <returns>返回对象</returns>
public static bool Add(chosen_orderinfo info, out string errmsg)
{
return(orderinfoDAL.Add(info, out errmsg));
}
/// <summary>
/// 订单管理 详情查询
/// </summary>
public static chosen_orderinfo GetInfo(string orderno, out string errmsg)
{
chosen_orderinfo info = orderinfoDAL.GetInfo(orderno, out errmsg);
return(info);
}
/// <summary>
/// 判断全文资源计费情况
/// </summary>
/// <param name="restype">资源库id</param>
/// <param name="seqid">资源id</param>
/// <param name="userid">用户id</param>
/// <param name="customerid">客户id</param>
/// <param name="userIp">用户ip</param>
/// <param name="tablename">资源库名</param>
/// <param name="costtype">计费类型 【0免费资源；1 客户计时订单；2 客户计量订单；3 用户订单；】</param>
/// <param name="m_price">单条价格</param>
/// <param name="m_discount">单条折扣</param>
/// <param name="serviceno">客户服务编号</param>
/// <param name="orderno">客户服务订单号</param>
/// <param name="errmsg"></param>
/// <returns></returns>
public static int GetFullPathResourceCheckCost(int restype, long seqid, int userid, int customerid, string userIp, out string tablename, out int costtype, out decimal m_price, out decimal m_discount, out string serviceno, out string orderno, out string errmsg)
{
errmsg = null;
tablename = null;
costtype = 0;
m_price = 0;
m_discount = 0;
serviceno = null;
orderno = null;
string sqlstr = string.Format("select mouldid,databasename,databasecname,isware from db_datalibrarys where databaseid={0}", restype);
db_datalibrarys dbinfo = MySqlHelper.GetDataInfo <db_datalibrarys>(sqlstr, out errmsg);
if (!string.IsNullOrEmpty(errmsg))
{
errmsg = "查询资源库出错" + errmsg;
return(-1);
}
if (dbinfo == null)
{
errmsg = "资源库参数错误";
return(-1);
}
tablename = dbinfo.databasename;
DataTable dt;
//首先判断是否商品库中的资源，如果是，判断单条资源是否收费 如果是，资源是否在用户已完成的订单中 （以前购买过，可以直接使用）
string shopname = null;
if (dbinfo.isware == 1 && userid > 0)
{
sqlstr = string.Format("select m_price,m_discount,title from {0} where seqid={1}", tablename, seqid);
dt = MySqlHelper.GetDataTable(sqlstr, out errmsg);
if (!string.IsNullOrEmpty(errmsg) || dt == null)
{
errmsg = "查询资源费用信息出错" + errmsg;
return(-1);
}
if (dt.Rows.Count == 0)
{
errmsg = "资源不存在";
return(-1);
}
if (!decimal.TryParse(dt.Rows[0][0].ToString(), out m_price) || !decimal.TryParse(dt.Rows[0][1].ToString(), out m_discount))
{
errmsg = "查询资源价格及折扣信息出错";
return(-1);
}
if (m_price * m_discount == 0) //免费资源，直接使用
{
costtype = 0;
return(1);
}
shopname = dt.Rows[0][2].ToString();
sqlstr = string.Format("select count(1) from chosen_orderinfo a,chosen_ordershop b where a.orderno=b.orderno and a.status=9 and a.userid={0} and b.restype='{1}' and rescode={2}", userid, tablename, seqid);
long count = MySqlHelper.GetRecCount(sqlstr, out errmsg);
if (!string.IsNullOrEmpty(errmsg))
{
errmsg = "查询用户订单信息出错" + errmsg;
return(-1);
}
if (count > 0) //用户购买过，直接使用
{
costtype = 3;
return(1);
}
}
// 用户是否在客户已购买并有效的授权服务当中
if (customerid > 0)
{
sqlstr = string.Format("select a.orderno,a.serviceno,b.stype,b.starttime,b.endtime,b.maxnum,b.leftnum,d.rulename,d.rulevalue from chosen_orderinfo a,chosen_serviceinfo b,chosen_servicepermit c,chosen_servicecont d where a.serviceno=b.serviceno and a.serviceno=c.serviceno and a.serviceno=d.serviceno and a.status=9 and a.customerid={0} and d.restype='{1}' ", customerid, tablename);
dt = MySqlHelper.GetDataTable(sqlstr, out errmsg);
if (!string.IsNullOrEmpty(errmsg))
{
errmsg = "查询资源服务信息出错" + errmsg;
return(-1);
}
if (dt != null && dt.Rows.Count > 0)
{
//资源是否在服务内容当中
orderno = dt.Rows[0]["orderno"].ToString();
serviceno = dt.Rows[0]["serviceno"].ToString();
costtype = int.Parse(dt.Rows[0]["stype"].ToString());
return(1);
}
}
//都不符合，生成用户订单，返回需要计费信息
if (m_price * m_discount > 0)
{
chosen_orderinfo order = new chosen_orderinfo();
order.GetNo();
order.ordername = string.Format("订购资源库 {0} 的资源 {1} 的全文", dbinfo.databasecname, seqid);
MySqlTransactionHelper tran = new MySqlTransactionHelper();
if (tran.TransactionBegin(out errmsg))
{
//写入用户订单
List <DataParameter> pars = new List <DataParameter>();
pars.Add(new DataParameter("orderno", order.orderno));
pars.Add(new DataParameter("ordername", order.ordername));
pars.Add(new DataParameter("userid", userid));
pars.Add(new DataParameter("m_price", m_price));
pars.Add(new DataParameter("s_price", m_price * m_discount));
pars.Add(new DataParameter("ctype", 1));
pars.Add(new DataParameter("paytype", 1));
pars.Add(new DataParameter("status", 1));
pars.Add(new DataParameter("Creator", userid));
pars.Add(new DataParameter("createdtime", DateTime.Now));
string sqlor = "insert into chosen_orderinfo (orderno,ordername,userid,m_price,s_price,ctype,paytype,status,creator,createdtime) values (orderno,ordername,userid,m_price,s_price,ctype,paytype,status,creator,createdtime) ";
tran.TransactionExecuteCommand(sqlor, out errmsg, pars);
if (!string.IsNullOrEmpty(errmsg))
{
string err;
tran.TransactionRollback(out err);
return(-1);
}
pars.Clear();
pars.Add(new DataParameter("shopname", string.IsNullOrEmpty(shopname) ? order.ordername : shopname));
pars.Add(new DataParameter("orderno", order.orderno));
pars.Add(new DataParameter("restype", restype));
pars.Add(new DataParameter("rescode", seqid));
pars.Add(new DataParameter("prices", m_price));
pars.Add(new DataParameter("thumbnail", null));
pars.Add(new DataParameter("shopnum", 1));
sqlstr = "insert into chosen_ordershop (shopname,orderno,restype,rescode,prices,thumbnail,shopnum) values (@shopname,@orderno,@restype,@rescode,@prices,@thumbnail,@shopnum) ";
tran.TransactionExecuteCommand(sqlstr, out errmsg, pars);
if (!string.IsNullOrEmpty(errmsg))
{
string err;
tran.TransactionRollback(out err);
return(-1);
}
bool issuc = tran.TransactionCommit(out errmsg);
if (!string.IsNullOrEmpty(errmsg) || !issuc)
{
errmsg = "提交订单出错：" + errmsg;
return(-1);
}
costtype = 3;
orderno = order.orderno;
return(0);
}
return(-1);
}
else //免费资源
{
costtype = 0;
return(1);
}
}
public object GetUserOrderPay(string orderno, int paytype)
{
string errmsg = null;
if (userLoginManager.LoginUser == null || userLoginManager.LoginUser.UserID < 1)
{
return new { Rcode = -2, Rmsg = "未登录" }
}
;
if (string.IsNullOrEmpty(orderno))
{
return new { Rcode = 0, Rmsg = "参数错误" }
}
;
chosen_orderinfo orderinfo = OrderPayBLL.GetUserOrderInfo(orderno, out errmsg);
if (!string.IsNullOrEmpty(errmsg))
{
return new { Rcode = -1, Rmsg = "获取订单数据错误" + errmsg }
}
;
if (orderinfo == null)
{
return new { Rcode = -1, Rmsg = "订单号不存在" }
}
;
if (orderinfo.status != 1 && orderinfo.status != 1)
{
return new { Rcode = -1, Rmsg = "订单不在待支付状态" }
}
;
string savename = string.Format("{0}_{1}", orderno, paytype);
string url = GetSavePayUrl(savename);
if (string.IsNullOrEmpty(url))
{
switch (paytype)
{
case 1:
url = WXPayBLL.GetPayUrl(orderinfo, out errmsg);
break;
case 2:
url = AliPayBLL.GetPayUrl(orderinfo, out errmsg);
break;
default:
errmsg = "错误的支付方式选择";
break;
}
}
if (string.IsNullOrEmpty(errmsg) && !string.IsNullOrEmpty(url))
{
SetSavePayUrl(savename, url);
return(new { Rcode = 1, Rdata = url, Rmsg = "ok" });
}
return(new { Rcode = -1, Rmsg = errmsg });
}