236 lines
11 KiB
C#
236 lines
11 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Web;
|
|||
|
|
using System.Web.UI;
|
|||
|
|
using System.Web.UI.WebControls;
|
|||
|
|
using System.Text;
|
|||
|
|
using System.Data;
|
|||
|
|
namespace Mtxfw.VipSite
|
|||
|
|
{
|
|||
|
|
public partial class Admin_Member_zbjy_pp : Mtxfw.Utility.MemberBase
|
|||
|
|
{
|
|||
|
|
Mtxfw.DAL.user_bank daoBank = new Mtxfw.DAL.user_bank();
|
|||
|
|
Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info();
|
|||
|
|
Mtxfw.DAL.user_Results daoResults = new Mtxfw.DAL.user_Results();
|
|||
|
|
Mtxfw.DAL.user_Results_jl2 daojl2 = new Mtxfw.DAL.user_Results_jl2();
|
|||
|
|
public Mtxfw.Utility.Config config = new Mtxfw.Utility.Config("");
|
|||
|
|
Mtxfw.DAL.Article daoArt = new Mtxfw.DAL.Article();
|
|||
|
|
public string strTitle = "预约未匹配列表",strids="";
|
|||
|
|
DAL.user_YZMs daoYZMs = new DAL.user_YZMs();
|
|||
|
|
protected override void OnLoad(EventArgs e)
|
|||
|
|
{
|
|||
|
|
base.OnLoad(e);
|
|||
|
|
if (!String.IsNullOrEmpty(Request.QueryString["ids"]))
|
|||
|
|
{
|
|||
|
|
strids = Request.QueryString["ids"].ToString();
|
|||
|
|
}
|
|||
|
|
if (!IsPostBack)
|
|||
|
|
{
|
|||
|
|
if (Session["IFPassword"] == null)
|
|||
|
|
{
|
|||
|
|
Response.Redirect("/Member_IFPassword.aspx?Url=/Admin_Member_zbjy0.aspx");
|
|||
|
|
}
|
|||
|
|
if (IFStores != 1)
|
|||
|
|
{
|
|||
|
|
Mtxfw.Utility.Tools.Message("您没有权限!", "/gl.aspx");
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
Page.Title = strTitle + " - " + GetWebName;
|
|||
|
|
|
|||
|
|
Data_Bind();
|
|||
|
|
}
|
|||
|
|
MyPager.PageChanged += delegate(object s, EventArgs ex)
|
|||
|
|
{
|
|||
|
|
Data_Bind();
|
|||
|
|
};
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
protected void Data_Bind()
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
System.Text.StringBuilder sb = new System.Text.StringBuilder();
|
|||
|
|
|
|||
|
|
sb.Append("utype=12");
|
|||
|
|
sb.Append(" and IFDelete=0");
|
|||
|
|
sb.Append(" and seef=0 And b8=1 And b16=1");
|
|||
|
|
if (strids != "")
|
|||
|
|
{
|
|||
|
|
sb.Append(" And id in(" + strids + ")");
|
|||
|
|
}
|
|||
|
|
string groupby = "";
|
|||
|
|
string strOrder = "addtime desc";
|
|||
|
|
|
|||
|
|
int Start = 0;
|
|||
|
|
int Limit = 0;
|
|||
|
|
Int32 Recount = 0;
|
|||
|
|
MyPager.PageSize = 100;
|
|||
|
|
Start = MyPager.PageSize * (MyPager.CurrentPageIndex - 1);
|
|||
|
|
Limit = MyPager.PageSize;
|
|||
|
|
DataSet dss = daoResults.GetDataSet(groupby, strOrder, "*,(Select UserName From user_info b Where b.Id=MemberId) as MemberName,(Select realname From user_info b Where b.Id=MemberId) as realname,(Select uLevel8 From user_info b Where b.Id=MemberId) as uLevel8", "", sb.ToString(), Start, Limit, out Recount);
|
|||
|
|
Mtxfw.Utility.Tools.ToBind(Repeater1, dss.Tables[1]);
|
|||
|
|
MyPager.RecordCount = Recount;
|
|||
|
|
if (MyPager.RecordCount == 0)
|
|||
|
|
{
|
|||
|
|
MyPager.Visible = false;
|
|||
|
|
}
|
|||
|
|
DataSet ds = daoResults.GetList1("sum(b0) as b0,sum(b2) as b2", sb.ToString());
|
|||
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|||
|
|
{
|
|||
|
|
string b0 = ds.Tables[0].Rows[0]["b0"].ToString();
|
|||
|
|
if (b0 != "")
|
|||
|
|
{
|
|||
|
|
Label0.Text = Convert.ToDouble(b0).ToString("f2");
|
|||
|
|
}
|
|||
|
|
string b2 = ds.Tables[0].Rows[0]["b2"].ToString();
|
|||
|
|
if (b2 != "")
|
|||
|
|
{
|
|||
|
|
Label1.Text = Convert.ToDouble(b2).ToString("f2");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
ds.Clear();
|
|||
|
|
}
|
|||
|
|
protected void Run_Click(object s, System.EventArgs e)
|
|||
|
|
{
|
|||
|
|
string strSQL = "";
|
|||
|
|
string strIds = "";
|
|||
|
|
if (txtUserID.Text != "")
|
|||
|
|
{
|
|||
|
|
string[] strA = txtUserID.Text.Split('|');
|
|||
|
|
foreach (string str in strA)
|
|||
|
|
{
|
|||
|
|
if (str != "")
|
|||
|
|
{
|
|||
|
|
string strid = daoUser.Getzd("id", "IFStores=0 and uLevel8=0 and UserName Like '%" + str + "%'").ToString();
|
|||
|
|
if (strid != "")
|
|||
|
|
{
|
|||
|
|
if (strIds == "")
|
|||
|
|
{
|
|||
|
|
strIds = strid;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
strIds += "," + strid;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
if (strIds != "")
|
|||
|
|
{
|
|||
|
|
strSQL = " and MemberId in(" + strIds + ")";
|
|||
|
|
|
|||
|
|
string[] astr = strids.Split(',');
|
|||
|
|
bool b = true;
|
|||
|
|
foreach (string Item in astr)
|
|||
|
|
{
|
|||
|
|
if (Item != "")
|
|||
|
|
{
|
|||
|
|
Int64 strID = Int64.Parse(Item);
|
|||
|
|
|
|||
|
|
Mtxfw.Model.user_Results rmodel = daoResults.GetModel(strID);
|
|||
|
|
if (rmodel != null)
|
|||
|
|
{
|
|||
|
|
if (rmodel.IFDelete == 0 && rmodel.Seef == 0)
|
|||
|
|
{
|
|||
|
|
Int64 TResultId = rmodel.Id;
|
|||
|
|
Int32 TMemberId = rmodel.MemberId;
|
|||
|
|
Double Tb0 = rmodel.b0;
|
|||
|
|
Double Tb1 = rmodel.b1;
|
|||
|
|
Double Tb2 = rmodel.b2;
|
|||
|
|
string Managers = rmodel.Managers;
|
|||
|
|
Mtxfw.Model.user_info umodel = daoUser.GetModel(rmodel.MemberId);
|
|||
|
|
if (umodel != null)
|
|||
|
|
{
|
|||
|
|
string TUserName = umodel.UserName;
|
|||
|
|
string TRealName = umodel.RealName;
|
|||
|
|
string TPhone = umodel.Phone;
|
|||
|
|
DateTime dt = DateTime.Now;
|
|||
|
|
|
|||
|
|
strSQL += " and (Select c.uLevel8 from user_info c where c.id=a.MemberId)=0 and a.MemberId<>" + TMemberId;
|
|||
|
|
|
|||
|
|
DataSet ds0 = daoResults.GetList1(" top 1 a.id,a.MemberId,a.b0,a.b1,a.b2,a.addtime", "a.utype=12 And a.IFDelete=0 And a.b2=1 And a.b8=0 And a.b12=0 And a.b14=0" + strSQL + " Order By a.b0 asc,a.addtime Asc");
|
|||
|
|
|
|||
|
|
if (ds0.Tables[0].Rows.Count > 0)
|
|||
|
|
{
|
|||
|
|
Int64 JResultId = Convert.ToInt64(ds0.Tables[0].Rows[0]["id"]);
|
|||
|
|
Int32 JMemberId = Convert.ToInt32(ds0.Tables[0].Rows[0]["MemberId"]);
|
|||
|
|
Double Jb0 = Convert.ToDouble(Convert.ToDouble(ds0.Tables[0].Rows[0]["b0"]).ToString("f2"));
|
|||
|
|
Double Jb1 = Convert.ToDouble(Convert.ToDouble(ds0.Tables[0].Rows[0]["b1"]).ToString("f2"));
|
|||
|
|
Double Jb2 = Convert.ToDouble(Convert.ToDouble(ds0.Tables[0].Rows[0]["b2"]).ToString("f2"));
|
|||
|
|
DateTime Jaddtime = Convert.ToDateTime(ds0.Tables[0].Rows[0]["addtime"]);
|
|||
|
|
Mtxfw.Model.user_info umodel0 = daoUser.GetModel(JMemberId);
|
|||
|
|
if (umodel0 != null)
|
|||
|
|
{
|
|||
|
|
Double money = Tb0;
|
|||
|
|
|
|||
|
|
string JUserName = umodel0.UserName;
|
|||
|
|
string JRealName = umodel0.RealName;
|
|||
|
|
string JPhone = umodel0.Phone;
|
|||
|
|
daoResults.Updatejdtime(1, dt, Jaddtime, JMemberId, JResultId.ToString(), TResultId);
|
|||
|
|
int yyq = Convert.ToInt32(config.webMoney69);
|
|||
|
|
if (yyq == 0)
|
|||
|
|
{
|
|||
|
|
daoResults.Updatemoney("b11", 1, "id=" + TResultId);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
daoResults.Updatemoney("b11", 0, "id=" + TResultId);
|
|||
|
|
DateTime yyqdt = dt.AddMinutes(yyq);
|
|||
|
|
if (config.webMoney70 == "hour")
|
|||
|
|
{
|
|||
|
|
yyqdt = dt.AddHours(yyq);
|
|||
|
|
}
|
|||
|
|
else if (config.webMoney70 == "day")
|
|||
|
|
{
|
|||
|
|
yyqdt = dt.AddDays(yyq);
|
|||
|
|
}
|
|||
|
|
daoResults.Updatepaytime(yyqdt, TResultId);
|
|||
|
|
}
|
|||
|
|
daoResults.Updatemoney("b5", 0, "id=" + TResultId);
|
|||
|
|
daoResults.Updatemoney("b14", 1, "id=" + JResultId);//更新已匹配标志
|
|||
|
|
if (Managers != "")
|
|||
|
|
{
|
|||
|
|
daoResults.UpdateSeef(1, dt, Convert.ToInt64(Managers));
|
|||
|
|
}
|
|||
|
|
Model.User_CZ_log logmodel = new Model.User_CZ_log();
|
|||
|
|
logmodel.MemberId = Card;
|
|||
|
|
logmodel.AddTime = DateTime.Now;
|
|||
|
|
logmodel.IP = Mtxfw.Utility.Common.GetIP;
|
|||
|
|
logmodel.Body = "手动匹配订单，ID：" + TResultId + "，买家为" + JUserName + "[" + JRealName + "]，卖家为" + TUserName + "[" + TRealName + "],金额为" + Tb0.ToString();
|
|||
|
|
logmodel.UType = 0;
|
|||
|
|
new DAL.User_CZ_log().Add(logmodel);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
|
|||
|
|
b = false;
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('找不到比" + umodel.UserName + "卖出" + Tb0.ToString() + "更大或相等的预约单！');</script>");
|
|||
|
|
}
|
|||
|
|
ds0.Clear();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if (b)
|
|||
|
|
{
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('匹配成功！');location.href='Admin_Member_zbjy_seef.aspx'</script>");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>alert('找不到会员！');</script>");
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|