public void orderok_chuli(string dingdanhao, string tablename, float jine)
{
#region 如果tablename等于空
if (tablename == "")
{
if (my_c.GetTable("select * from sl_order where zhuangtai='未付款' and dingdanhao='" + dingdanhao + "'").Rows.Count > 0)
{
tablename = "order";
}
if (my_c.GetTable("select * from sl_caiwu where zhuangtai='未付款' and dingdanhao='" + dingdanhao + "'").Rows.Count > 0)
{
tablename = "caiwu";
}
}
#endregion
string yonghuming = "";
if (tablename == "caiwu")
{
DataTable sl_caiwu = my_c.GetTable("select * from sl_" + tablename + " where zhuangtai='未付款' and dingdanhao='" + dingdanhao + "'");
if (sl_caiwu.Rows.Count > 0)
{
if (jine < float.Parse(sl_caiwu.Rows[0]["jine"].ToString()))
{
HttpContext.Current.Response.Write("err");
HttpContext.Current.Response.End();
}
caiwu_pay(dingdanhao, tablename);
}
}
else if (tablename == "hedan")
{
#region 处理合单
DataTable sl_order = my_c.GetTable("select * from sl_" + tablename + " where zhuangtai='未付款' and dingdanhao='" + dingdanhao + "'");
if (sl_order.Rows.Count > 0)
{
if (jine < float.Parse(sl_order.Rows[0]["jine"].ToString()))
{
HttpContext.Current.Response.Write("err");
HttpContext.Current.Response.End();
}
#region 存在未付款的信息
my_c.genxin("insert into sl_system (u1,u2,u3,u4) values('" + sl_order.Rows[0]["yonghuming"].ToString() + "','" + dingdanhao + "','" + HttpContext.Current.Request.UserHostAddress.ToString() + "','会员订单')");
if (sl_order.Rows.Count > 0)
{
string zhanghu = "";
//加财务记录 start
my_c.genxin("insert into sl_caiwu(dingdanhao,zhifufangshi,yonghuming,zhuangtai,leixing,miaoshu,jine,zhanghu) values('" + sl_order.Rows[0]["dingdanhao"].ToString() + "','" + sl_order.Rows[0]["zhifufangshi"].ToString() + "','" + sl_order.Rows[0]["yonghuming"].ToString() + "','已付款','充值','支付订单:" + sl_order.Rows[0]["dingdanhao"].ToString() + "，先充值。'," + sl_order.Rows[0]["jine"].ToString() + ",'" + zhanghu + "')");
my_c.genxin("insert into sl_caiwu(dingdanhao,zhifufangshi,yonghuming,zhuangtai,leixing,miaoshu,jine,zhanghu) values('" + sl_order.Rows[0]["dingdanhao"].ToString() + "','" + sl_order.Rows[0]["zhifufangshi"].ToString() + "','" + sl_order.Rows[0]["yonghuming"].ToString() + "','已付款','消费','支付订单:" + sl_order.Rows[0]["dingdanhao"].ToString() + "，使用充值金额。',-" + sl_order.Rows[0]["jine"].ToString() + ",'" + zhanghu + "')");
//加财务记录 end
my_c.genxin("update sl_" + tablename + " set zhuangtai='已付款' where dingdanhao='" + dingdanhao + "'");
//订单
my_c.genxin("update sl_order set zhuangtai='已付款' where hebingdingdan='" + dingdanhao + "'");
my_order my_o = new my_order();
//end
}
my_c.genxin("update sl_caiwu set zhuangtai='已付款' where miaoshu like '%" + my_b.c_string(dingdanhao) + "%'");
my_c.genxin("update sl_jifen set zhuangtai='已处理' where shijian like '%" + my_b.c_string(dingdanhao) + "%'");
HttpContext.Current.Response.Redirect("/err.aspx?err=已经支付！&errurl=" + my_b.tihuan("/", "&", "fzw123") + "");
#endregion
}
#endregion
}
else
{
#region 其它订单类型
DataTable sl_order = my_c.GetTable("select * from sl_" + tablename + " where zhuangtai='未付款' and dingdanhao='" + dingdanhao + "'");
if (sl_order.Rows.Count > 0)
{
if (jine < float.Parse(sl_order.Rows[0]["jine"].ToString()))
{
HttpContext.Current.Response.Write("err");
HttpContext.Current.Response.End();
}
yonghuming = sl_order.Rows[0]["yonghuming"].ToString();
my_c.genxin("update sl_" + tablename + " set zhuangtai='已付款' where dingdanhao='" + dingdanhao + "'");
}
my_c.genxin("update sl_caiwu set zhuangtai='已付款' where miaoshu like '%" + my_b.c_string(dingdanhao) + "%'");
my_c.genxin("update sl_jifen set zhuangtai='已处理' where shijian like '%" + my_b.c_string(dingdanhao) + "%'");
#endregion
}
my_c.genxin("insert into sl_system (u1,u2,u3,u4) values('" + yonghuming + "','" + tablename + "订单号：" + dingdanhao + "','" + HttpContext.Current.Request.UserHostAddress.ToString() + "','会员订单')");
}
