199 lines
9.5 KiB
C#
199 lines
9.5 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Web;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Data;
|
|
namespace Mtxfw.VipSite
|
|
{
|
|
public partial class Admin_Member_Commission2 : Mtxfw.Utility.MemberBase
|
|
{
|
|
public Mtxfw.DAL.user_Results daoResults = new Mtxfw.DAL.user_Results();
|
|
public Mtxfw.DAL.user_Results_jl2 daojl2 = new Mtxfw.DAL.user_Results_jl2();
|
|
public Mtxfw.Utility.Config config = new Mtxfw.Utility.Config("");
|
|
Mtxfw.DAL.user_info daoUser = new Mtxfw.DAL.user_info();
|
|
public string[] bonuscategory = null;
|
|
public int gtype = 0, t = 0;
|
|
protected override void OnLoad(EventArgs e)
|
|
{
|
|
base.OnLoad(e);
|
|
string hostname = Request.Url.Host;
|
|
|
|
bonuscategory = config.webbonuscategory.Split('|');
|
|
if (!String.IsNullOrEmpty(Request.QueryString["t"]))
|
|
{
|
|
t = Convert.ToInt32(Request.QueryString["t"].ToString());
|
|
}
|
|
if (!IsPostBack)
|
|
{
|
|
if (Session["IFPassword"] == null)
|
|
{
|
|
Response.Redirect("/Member_IFPassword.aspx?Url=/Admin_Member_Commission2.aspx");
|
|
}
|
|
if (IFStores != 1)
|
|
{
|
|
Mtxfw.Utility.Tools.Message("您没有权限!", "/gl.aspx");
|
|
}
|
|
if (MemberJS.IndexOf("奖金详情") == -1)
|
|
{
|
|
Mtxfw.Utility.Tools.Message("您没有权限!", "/gl.aspx");
|
|
}
|
|
Page.Title = "奖金详情 - " + GetWebName;
|
|
Data_Bind();
|
|
|
|
}
|
|
|
|
MyPager.PageChanged += delegate(object s, EventArgs ex)
|
|
{
|
|
Data_Bind();
|
|
};
|
|
}
|
|
|
|
protected void Data_Bind()
|
|
{
|
|
System.Text.StringBuilder sb = new System.Text.StringBuilder();
|
|
String SJ = Request.QueryString["SJ"];
|
|
String SJ2 = Request.QueryString["SJ2"];
|
|
String addtime = Request.QueryString["addtime"];
|
|
String week = Request.QueryString["week"];
|
|
String MemberId = Request.QueryString["MemberId"];
|
|
String TGID = Request.QueryString["TGID"];
|
|
String OrderId = Request.QueryString["OrderId"];
|
|
String key = Request.QueryString["key"];
|
|
if (MemberuLevel29 > 0)
|
|
{
|
|
sb.Append(" And MemberId in(Select b.id from user_info b where b.IFStores=0 And b.ContactIDS like '" + MemberContactIDS + "%')");
|
|
}
|
|
if (t == 5)
|
|
{
|
|
sb.Append(" And seef=0");
|
|
}
|
|
else
|
|
{
|
|
sb.Append(" And seef=1");
|
|
}
|
|
if (!String.IsNullOrEmpty(SJ) && !String.IsNullOrEmpty(SJ2))
|
|
{
|
|
sb.Append("and (addtime between '" + SJ + " 00:00:00' and '" + SJ2 + " 23:59:59') ");
|
|
//sb.Append("and (CONVERT(varchar(100),DATEADD(mm,DATEDIFF(mm,0,dateadd(month,-1,addtime)),0),120)>=CONVERT(varchar(100),cast('" + SJ + " 00:00:00' as datetime),120) And CONVERT(varchar(100),dateadd(ms,-3,DATEADD(mm,DATEDIFF(m,0,dateadd(month,-1,addtime))+1,0)),120)<=CONVERT(varchar(100),cast('" + SJ2 + " 23:59:59' as datetime),120))");
|
|
}
|
|
if (!String.IsNullOrEmpty(MemberId))
|
|
{
|
|
sb.Append(" and MemberId=" + MemberId);
|
|
}
|
|
if (!String.IsNullOrEmpty(TGID))
|
|
{
|
|
sb.Append(" and UserId=" + TGID);
|
|
}
|
|
if (!String.IsNullOrEmpty(OrderId))
|
|
{
|
|
sb.Append(" and ListNumber='" + OrderId + "'");
|
|
}
|
|
if (!String.IsNullOrEmpty(key))
|
|
{
|
|
key = key.Trim();
|
|
sb.Append(" and MemberId=(Select id from user_info b where b.UserName='" + key + "')");
|
|
}
|
|
if (!String.IsNullOrEmpty(addtime))
|
|
{
|
|
sb.Append(" and DateDiff(day,addtime,'" + addtime + "')=0");
|
|
}
|
|
if (!String.IsNullOrEmpty(week))
|
|
{
|
|
sb.Append(" and datepart(week,addtime)=" + week);
|
|
}
|
|
string strOrder = " Order By addtime desc";
|
|
MyPager.PageSize = 50;
|
|
MyPager.RecordCount = daoResults.GetCount("gtype=" + gtype + " and utype=0" + sb.ToString());
|
|
if (MyPager.RecordCount == 0)
|
|
{
|
|
MyPager.Visible = false;
|
|
}
|
|
Mtxfw.Utility.Tools.ToBind(Repeater1, daoResults.GetPager(MyPager, "(Select UserName From user_info b Where b.Id=a.MemberId) as UserName,(Select RealName From user_info b Where b.Id=a.MemberId) as RealName,", "gtype=" + gtype + " and utype=0 And IFDelete=0" + sb.ToString() + strOrder));
|
|
DataSet ds = daoResults.GetResultsSumList0("gtype=" + gtype + " and utype=0 And IFDelete=0" + sb.ToString() + " group by utype");
|
|
ds.Tables[0].DefaultView.Sort = "Totalmoney desc";
|
|
if (ds.Tables[0].Rows.Count > 0)
|
|
{
|
|
Label_b1.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b1"]).ToString("f2");
|
|
Label_b2.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b2"]).ToString("f2");
|
|
Label_b3.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b3"]).ToString("f2");
|
|
Label_b4.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b4"]).ToString("f2");
|
|
Label_b5.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b5"]).ToString("f2");
|
|
Label_b6.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b6"]).ToString("f2");
|
|
Label_b7.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b7"]).ToString("f2");
|
|
Label_b8.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b8"]).ToString("f2");
|
|
Label_b9.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b9"]).ToString("f2");
|
|
Label_b10.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b10"]).ToString("f2");
|
|
Label_b11.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b11"]).ToString("f2");
|
|
Label_b12.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b12"]).ToString("f2");
|
|
Label_b13.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b13"]).ToString("f2");
|
|
Label_b14.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b14"]).ToString("f2");
|
|
Label_b18.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["b18"]).ToString("f2");
|
|
Label_Totalmoney.Text = Convert.ToDouble(ds.Tables[0].Rows[0]["Totalmoney"]).ToString("f2");
|
|
}
|
|
}
|
|
protected void Delete_Click(object s, CommandEventArgs ex)
|
|
{
|
|
Int64 ID = Int64.Parse(ex.CommandName);
|
|
Mtxfw.Model.user_Results model = daoResults.GetModel(ID);
|
|
if (model != null)
|
|
{
|
|
Mtxfw.Model.user_info umodel = daoUser.GetModel(model.MemberId);
|
|
if (umodel != null)
|
|
{
|
|
daoResults.UpdateIFDelete(1, DateTime.Now.ToString(), ID);
|
|
if (Convert.ToDouble(model.b2.ToString("f2")) > 0.00)
|
|
{
|
|
Model.user_Results_jl2 mjl2 = new Model.user_Results_jl2();
|
|
mjl2.MemberId = umodel.Id;
|
|
mjl2.MemberId2 = 0;
|
|
mjl2.Addmoney = model.b0;
|
|
mjl2.Cutmoney = 0;
|
|
mjl2.Totalmoney = umodel.umoney41 + model.b0;
|
|
mjl2.addtime = DateTime.Now;
|
|
mjl2.BZContent = "明细记录";
|
|
mjl2.PayID = "";
|
|
mjl2.OrdersIDs = "";
|
|
mjl2.OrdersID = 0;
|
|
mjl2.utype = 12;
|
|
mjl2.utype2 = 0;
|
|
mjl2.Seef = -1;
|
|
mjl2.seeftime = DateTime.Now;
|
|
mjl2.gtype = gtype;
|
|
daojl2.Add(mjl2);
|
|
daoUser.UpdateMoney("umoney41", model.b0, umodel.Id);
|
|
}
|
|
else
|
|
{
|
|
Model.user_Results_jl2 mjl2 = new Model.user_Results_jl2();
|
|
mjl2.MemberId = umodel.Id;
|
|
mjl2.MemberId2 = 0;
|
|
mjl2.Addmoney = model.b0;
|
|
mjl2.Cutmoney = 0;
|
|
mjl2.Totalmoney = umodel.umoney40 + model.b0;
|
|
mjl2.addtime = DateTime.Now;
|
|
mjl2.BZContent = "明细记录";
|
|
mjl2.PayID = "";
|
|
mjl2.OrdersIDs = "";
|
|
mjl2.OrdersID = 0;
|
|
mjl2.utype = 11;
|
|
mjl2.utype2 = 0;
|
|
mjl2.Seef = -1;
|
|
mjl2.seeftime = DateTime.Now;
|
|
mjl2.gtype = gtype;
|
|
daojl2.Add(mjl2);
|
|
daoUser.UpdateMoney("umoney40", model.b0, umodel.Id);
|
|
}
|
|
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 = "删除奖金明细，会员：" + umodel.UserName + "，金额：" + model.Totalmoney.ToString() + "，原因：" + model.conent;
|
|
logmodel.UType = 0;
|
|
new DAL.User_CZ_log().Add(logmodel);
|
|
}
|
|
}
|
|
Data_Bind();
|
|
}
|
|
}
|
|
} |