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(), "", "");
}
ds0.Clear();
}
}
}
}
}
if (b)
{
ClientScript.RegisterStartupScript(this.GetType(), "", "");
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "");
}
}
}
}