protected override void SetValue(string id)
{
Sys_BankInfoBLL sbiBLL = new Sys_BankInfoBLL();
txtBank.DataSource = sbiBLL.GetList(" 1 = 1 and IsDeleted = 0 order by Code");
txtBank.DataTextField = "Name";
txtBank.DataValueField = "Name";
txtBank.DataBind();
BindDdlPwdQuestion(ddlQuestion);
foreach (Model.Roles item in BLL.Roles.RolsList.Values.ToList().Where(emp => emp.VState).ToList())
{
ddlMemberType.Items.Add(new ListItem(item.RName, item.RType));//角色
}
////会员级别
//ddlSHMoney.DataSource = BLL.Configuration.Model.SHMoneyTable;
//ddlSHMoney.DataTextField = "MAgencyName";
//ddlSHMoney.DataValueField = "MAgencyType";
//ddlSHMoney.DataBind();
string mid = HttpUtility.UrlDecode(Request["id"].Trim());
model = BllModel.GetModel(mid);
MemberModel = model;
}
protected override string btnModify_Click()
{
lock (obj)
{
decimal count = 0;
try
{
//count = decimal.Parse(Request.Form["txtAddCount"]);
//if (count < BLL.Configuration.Model.ActivateMinMoney || count > BLL.Configuration.Model.ActivateMaxMoney)
//{
// return "投资金额必须在" + BLL.Configuration.Model.ActivateMinMoney + "-" + BLL.Configuration.Model.ActivateMaxMoney + "之间";
//}
//if (count + TModel.MConfig.SHMoney > BLL.Configuration.Model.ActivateMaxMoney)
//{
// return "累计投资金额不能超过" + BLL.Configuration.Model.ActivateMaxMoney;
//}
}
catch
{
throw new Exception("投资金额必须为整数大于0的数");
}
if (BLL.ChangeMoney.EnoughChange(TModel.MID, count, "MHB"))
{
return(BllModel.UpMAgencyType(BLL.Configuration.Model.SHMoneyList["002"], TModel.MID, "MHB", TModel, count));
}
else
{
return("您的股权不足，无法追加投资");
}
}
}
private void GetStructure(string mid, int level, StringBuilder sb)
{
List <Model.Member> ListMember = BllModel.GetMemberEntityList(string.Format("MSH='{0}' and MID<>'{0}' and RoleCode = 'VIP' order by MCreateDate", mid));
if (level > 0)
{
sb.Append("<ul>");
for (int i = 0; i < ListMember.Count; i++)
{
string colors = "";
if (ListMember[i].MState)
{
colors = ListMember[i].MAgencyType.MColor;
}
else
{
colors = "#FF5151";
}
sb.AppendFormat(tempMysb, ListMember[i].MID, ListMember[i].MID, ListMember[i].Role.RName, colors, BLL.Member.GetOnlineInfo(ListMember[i].MID), GetMemberType(ListMember[i]));
GetStructure(ListMember[i].MID, level - 1, sb);
sb.Append("</li>");
}
sb.Append("</ul>");
}
}
private int GetLevel(int level, ref string mkey, bool IsMBD)
{
Model.Member memberModel = (TModel == null ? BllModel.TModel : TModel);
if (!memberModel.Role.Super)
{
if (mkey == memberModel.MID)
{
if (level > memberModel.MAgencyType.ViewLevel)
{
level = memberModel.MAgencyType.ViewLevel;
}
}
else
{
int levelCount = BllModel.GetLevelForView(mkey, IsMBD);
if (levelCount > 0)
{
if (level + levelCount > memberModel.MAgencyType.ViewLevel)
{
level = memberModel.MAgencyType.ViewLevel - levelCount > level ? level : memberModel.MAgencyType.ViewLevel - levelCount;
}
}
else
{
mkey = memberModel.MID;
}
}
}
return(level);
}
protected override void SetValue(string id)
{
url = "Member/SHListSJ.aspx";
sjmodel = BllModel.GetModel(id);
hdmid.Value = sjmodel.MID;
if (TModel.Role.IsAdmin && !sjmodel.MState)
{
//填写接点人
isNew = false;
}
foreach (Model.SHMoney item in BLL.Configuration.Model.SHMoneyList.Values.Where(emp => emp.MAgencyType != "001"))
{
MAgencyTypeColor += "<td style='width:60px;color:#00CCFF;'>" + item.MAgencyName + "<br />[" + item.Money + "]</td>";
if (item.Money <= sjmodel.MAgencyType.Money || !BLL.ChangeMoney.EnoughChange(TModel.MID, item.Money - sjmodel.MAgencyType.Money, "MJB"))
{
continue;
}
else
{
MyMAgencyTypeRdo += "<input name='AgencyTypeList' id='" + item.MAgencyType + "' value='" + item.MAgencyType + "' type='radio' />" + item.MAgencyName + "[" + (item.Money - sjmodel.MAgencyType.Money) + "] ";
}
}
if (string.IsNullOrEmpty(MyMAgencyTypeRdo))
{
MyMAgencyTypeRdo += "暂不可升级";
}
}
protected override void SetPowerZone()
{
bankauto.Value = string.IsNullOrEmpty(TModel.BankNumber) ? "0" : "1";
getsuiji.Value = GetRanLJ();
mantissa = GetMantissa();
Session["mantissa"] = mantissa;
//code = GetHKCode();
//Session["code"] = code;
//txtTel.Value = TModel.Tel;
//RioMJB.Checked = true;
//foreach (Model.BankModel item in BLL.Member.ManageMember.GetMyBankInfo())
//{
// ddlToBank.Items.Add(item.Bank);
//}
//Model.Member model = TModel;
//txtBankName.Value = model.BankCardName;
//txtFromBank.Value = model.Bank;
//txtHKDate.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
Model.Member manage = BllModel.GetModel(BLL.Member.ManageMember.TModel.MID);
try
{
adminBank = manage.Bank;
adminBranch = manage.Branch;
adminBankNumber = manage.BankNumber;
adminBankCardName = manage.BankCardName;
alipayname = manage.QRCode;
alipay = manage.Alipay;
weixin = manage.WeChat;
}
catch
{
}
}
public override void ProcessRequest(HttpContext context)
{
base.ProcessRequest(context);
pageSize = 200;
string strWhere = "";
string mType = "";
if (!string.IsNullOrEmpty(context.Request["txtKey"]))
{
mType = context.Request["txtKey"];
}
else
{
return;
}
if (!string.IsNullOrEmpty(context.Request["startDate"]))
{
strWhere += " and Contents.CTitle like '%" + context.Request["startDate"] + "%' ";
}
if (!string.IsNullOrEmpty(context.Request["tState"]))
{
if (bool.Parse(context.Request["tState"]))
{
strWhere += " and RType is not null";
}
else
{
strWhere += " and RType is null";
}
}
DataTable ListContents = BllModel.GetPowers(strWhere, mType);
StringBuilder sb = new StringBuilder();
for (int i = (pageIndex - 1) * pageSize; i < pageIndex * pageSize && i < ListContents.Rows.Count; i++)
{
sb.Append(ListContents.Rows[i]["CID"].ToString() + "~");
sb.Append(i + 1 + "~");
sb.Append(ListContents.Rows[i]["CID"].ToString() + "~");
sb.Append(ListContents.Rows[i]["CTitle"].ToString() + "~");
if (!string.IsNullOrEmpty(ListContents.Rows[i]["RType"].ToString()))
{
sb.Append("<span style='color:Blue;'>已授权</span>#T" + "~");
}
else
{
sb.Append("<span style='color:Red;'>未授权</span>" + "~");
}
//sb.Append(Convert.ToBoolean(ListContents.Rows[i]["IsQuickMenu"]) ? "<span style='color:Blue;'>是</span>~" : "<span style='color:Red;'>否</span>~");
//sb.Append("<i class='fa "+ListContents.Rows[i]["CImage"]+"'></i>" + "~");
sb.Append("<a href='javascript:void(0)' onclick=\"callhtml('SysManage/MenuEdit.aspx?Id=" + ListContents.Rows[i]["CID"] + "','菜单编辑')\">修改</a>");
sb.Append("≌");
}
var info = new { PageData = Traditionalized(sb), TotalCount = 0 };
//var json = new { PageData = sb.ToString(), TotalCount = count };匿名类
context.Response.Write(JavaScriptConvert.SerializeObject(info));
}
protected override void SetPowerZone()
{
RioMJB.Checked = true;
foreach (Model.BankModel item in BLL.Member.ManageMember.GetMyBankInfo())
{
ddlToBank.Items.Add(item.Bank);
}
Model.Member model = TModel;
txtBankName.Value = model.BankCardName;
txtFromBank.Value = model.Bank;
txtHKDate.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
Model.Member manage = BllModel.GetModel(BLL.Member.ManageMember.TModel.MID);
adminBank = manage.Bank;
try
{
//adminBank = new CommonBLL.Sys_BankInfoBLL().GetModel(manage.Bank).Name;
adminBranch = manage.Branch;
adminBankNumber = manage.BankNumber;
adminBankCardName = manage.BankCardName;
alipay = manage.Alipay;
weixin = manage.WeChat;
}
catch
{
}
}
protected override string btnAdd_Click()
{
string offer = Request.Form["txtoffer"].Trim();
string get = Request.Form["txtget"].Trim();
if (string.IsNullOrEmpty(offer))
{
return("买入许愿果会员帐号不能为空");
}
else
{
if (BllModel.GetModel(offer) == null)
{
return("买入许愿果会员帐号不存在");
}
}
if (string.IsNullOrEmpty(get))
{
return("卖出许愿果会员帐号不能为空");
}
else
{
if (BllModel.GetModel(get) == null)
{
return("卖出许愿果会员帐号不存在");
}
}
return(BLL.MHelpMatch.MatchingHelp3(offer, get));
}
/// <summary>
/// 更新基本资料
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected override string btnModify_Click()
{
Hashtable MyHs = new Hashtable();
if (Request.Form["chkCloseAll"] == "on" || Request.Form["chkClockAll"] == "on")
{
List <Model.Member> list = BllModel.GetMemberEntityList("MID in (select mid from getTreeBuyMID('" + MemberModel.MID + "'))");
foreach (Model.Member item in list)
{
if (Request.Form["chkCloseAll"] == "on")
{
item.IsClose = MemberModel.IsClose;
item.IsClock = MemberModel.IsClock;
}
if (Request.Form["chkClockAll"] == "on")
{
item.IsClock = MemberModel.IsClock;
}
BllModel.Update(item, MyHs);
}
}
BllModel.Update(MemberModel, MyHs);
BLL.Member.UpdateConfigTran(MemberModel.MID, "EPXingCount", MemberModel.MConfig.EPXingCount.ToString(), null, true, System.Data.SqlDbType.Int, MyHs);
//更新会员的密保问题
UpdateQuestion(MemberModel.ID.ToString(), MyHs);
if (BLL.CommonBase.RunHashtable(MyHs))
{
return("操作成功");
}
return("操作失败");
}
protected override string btnAdd_Click()
{
if (BllModel.ReSetSys())
{
return("操作成功");
}
return("操作失败");
}
public override void ProcessRequest(HttpContext context)
{
base.ProcessRequest(context);
string strWhere = "'1'='1' AND ROLECODE='SiJi' ";
if (!string.IsNullOrEmpty(context.Request["mKey"]))
{
strWhere += string.Format(" and ( MID='{0}' ) ", (context.Request["mKey"]));
}
if (!string.IsNullOrEmpty(context.Request["SiJiType"]))
{
strWhere += string.Format(" and FMID={0} ", (context.Request["SiJiType"]));
}
string SQL2 = " ";
if (!string.IsNullOrEmpty(context.Request["startDate"]))
{
SQL2 += " and CreateDate>'" + context.Request["startDate"] + " 00:00:00' ";
}
if (!string.IsNullOrEmpty(context.Request["endDate"]))
{
SQL2 += " and CreateDate<'" + context.Request["endDate"] + " 23:59:59' ";
}
string TState = "";
if (!string.IsNullOrEmpty(context.Request["TType"]))
{
if (context.Request["TType"] == "1")
{
TState = " and TState=1 ";
}
else
{
TState = " and TState in(-1,0) ";
}
}
int count;
List <Model.Member> ListMember = BllModel.GetMemberEntityList(strWhere, pageIndex, pageSize, out count);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < ListMember.Count; i++)
{
sb.Append(ListMember[i].MID + "~");
sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~");
sb.Append(ListMember[i].MID + "~");
sb.Append(ListMember[i].MName + "~");
sb.Append(GetCountByCPCode(SQL2, ListMember[i].MID, 1, TState) + "~");
sb.Append(GetCountByCPCode(SQL2, ListMember[i].MID, 2, TState) + "");
sb.Append("≌");
}
var info = new { PageData = Traditionalized(sb), TotalCount = count };
context.Response.Write(JavaScriptConvert.SerializeObject(info));
}
public override void ProcessRequest(HttpContext context)
{
base.ProcessRequest(context);
List <string> typeList = new List <string>()
{
"SH"
};
List <string> mType = new List <string> {
"MJB"
};
string mKey = "";
string strWhere = " '1'='1' ";
if (!string.IsNullOrEmpty(context.Request["mKey"]))
{
mKey = context.Request["mKey"];
}
if (!string.IsNullOrEmpty(context.Request["startDate"]))
{
strWhere += " and changedate>'" + context.Request["startDate"] + " 00:00:00' ";
}
if (!string.IsNullOrEmpty(context.Request["endDate"]))
{
strWhere += " and changedate<'" + context.Request["endDate"] + " 23:59:59' ";
}
Model.Member memberModel = (TModel == null ? BllModel.TModel : TModel);
if (!memberModel.Role.Super)
{
mKey = memberModel.MID;
}
int count;
List <Model.ChangeMoney> ListChangeMoney = BllModel.GetChangeMoneyEntityList(mKey, BLL.Member.ManageMember.TModel.MID, "", "true", typeList, mType, pageIndex, pageSize, strWhere, out count);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < ListChangeMoney.Count; i++)
{
Model.Member member = BllModel.GetModel(ListChangeMoney[i].SHMID);
sb.Append(ListChangeMoney[i].CID + "~");
sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~");
sb.Append(member.MID + "~");
sb.Append(member.MName + "~");
sb.Append(member.Tel + "~");
sb.Append(member.MAgencyType.MAgencyName + "~");
sb.Append(ListChangeMoney[i].Money.ToFixedDecimal() + "~");
sb.Append(ListChangeMoney[i].CRemarks + "~");
sb.Append((ListChangeMoney[i].CState ? "已生效" : "未生效") + "~");
sb.Append(ListChangeMoney[i].ChangeDate.ToString("yyyy-MM-dd HH:mm"));
sb.Append("≌");
}
var info = new { PageData = Traditionalized(sb), TotalCount = count };
context.Response.Write(JavaScriptConvert.SerializeObject(info));
}
/// <summary>
/// 货币转移
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected override string btnAdd_Click()
{
if (!string.IsNullOrEmpty(Request.Form["txtMID"]))
{
if (BllModel.GetModel(Request.Form["txtMID"]) == null)
{
return("会员不存在");
}
}
return(BLL.Task.Add(TaskModel));
}
protected override string btnOther_Click()
{
if (BllModel.ReSetSys())
{
return("操作成功");
}
else
{
return("操作失败");
}
}
public override void ProcessRequest(HttpContext context)
{
base.ProcessRequest(context);
string strWhere = "MState='1'";
string mKey = "";
if (!string.IsNullOrEmpty(context.Request["mKey"]))
{
mKey = context.Request["mKey"];
}
if (!string.IsNullOrEmpty(context.Request["startDate"]))
{
strWhere += " and MDate>'" + context.Request["startDate"] + " 00:00:00' ";
}
if (!string.IsNullOrEmpty(context.Request["endDate"]))
{
strWhere += " and MDate<'" + context.Request["endDate"] + " 23:59:59' ";
}
if (!TModel.Role.IsAdmin)
{
mKey = TModel.MID;
}
if (!string.IsNullOrEmpty(mKey))
{
strWhere += string.Format(" and FMID='{0}' ", mKey);
}
int count;
List <Model.Member> ListMember = BllModel.GetMemberEntityList(strWhere, pageIndex, pageSize, out count);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < ListMember.Count; i++)
{
sb.Append(ListMember[i].MID + "~");
sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~");
sb.Append(ListMember[i].MID + "~");
sb.Append(ListMember[i].MAgencyType.MAgencyName + "~");
sb.Append(ListMember[i].SHMoney + "~");
sb.Append(ListMember[i].MConfig.MJJ + "~");
sb.Append(ListMember[i].MConfig.MJB + "~");
sb.Append(ListMember[i].MConfig.MCW + "~");
sb.Append((ListMember[i].IsClose ? "已锁定" : "未锁定") + "~");
sb.Append((ListMember[i].IsClock ? "已冻结" : "未冻结") + "~");
sb.Append(ListMember[i].MDate.ToString("yyyy-MM-dd HH:mm") + "~");
sb.Append("<a href='" + HttpContext.Current.Request.Url.AbsoluteUri.Replace(HttpContext.Current.Request.Url.PathAndQuery, "/Default.aspx") + "?id=" + ListMember[i].MID + "'>进入系统</a>");
sb.Append("≌");
}
var info = new { PageData = sb.ToString(), TotalCount = count };
//var json = new { PageData = sb.ToString(), TotalCount = count };匿名类
context.Response.Write(JavaScriptConvert.SerializeObject(info));
}
protected override void SetValue(string id)
{
string mid = HttpUtility.UrlDecode(Request["id"].Trim());
model = BllModel.GetModel(mid);
if (model != null)
{
txtMID.Value = model.MID;
txtMName.Value = model.MName;
txtTel.Value = model.Tel;
}
}
protected override string btnAdd_Click()
{
if (!TModel.Role.IsAdmin)
{
return("您没有权限");
}
Model.Member model = BllModel.GetModel(Request.Form["txtMID"]);
if (model == null)
{
return("会员帐号不存在");
}
string moneyType = "MHB";
switch (Request.Form["kfType"])
{
case "MJB":
moneyType = "MJB";
break;
case "MHB":
moneyType = "MHB";
break;
default:
return("参数异常");
}
if (!string.IsNullOrEmpty(Request.Form["txtMHB"]))
{
int money = int.Parse(Request.Form["txtMHB"]);
if (money > 0)
{
Hashtable MyHs = new Hashtable();
BLL.ChangeMoney.HBChangeTran(money, model.MID, BLL.Member.ManageMember.TModel.MID, "KF", null, moneyType, Request.Form["txtRemark"], MyHs);
if (BLL.CommonBase.RunHashtable(MyHs))
{
return("扣费成功");
}
else
{
return("扣费失败");
}
}
else
{
return("扣费金额必须大于0");
}
}
else
{
return("参数异常");
}
}
private void GetStructure(string mid, List <sys_Tree> tree)
{
List <Model.Member> ListMember = BllModel.GetMemberEntityList(string.Format("MTJ='{0}' and MID<>'{0}' order by MDate", mid));
for (int i = 0; i < ListMember.Count; i++)
{
//string colors = "";
//colors = ListMember[i].MAgencyType.MColor;
//bool parent = isParent(ListMember[i].MID);
tree.Add(GetTreeByMember(ListMember[i], isParent(ListMember[i].MID)));
}
}
/// <summary>
/// 货币转移
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected override string btnAdd_Click()
{
//验证身份证号
//if (Request.Form["txtNumID"].Trim() != TModel.NumID)
//{
// return "身份证号校验失败！";
//}
//if (Check_SQ_Answer())
{
string MType = "MGP";
//if (Request.Form["RioHK"] == "1")
//{
// MType = "MJB";
//}
//else
//{
// MType = "MGP";
//}
Model.Member fmodel = null;
Model.Member tmodel = null;
if (!TModel.Role.IsAdmin)
{
fmodel = TModel;
}
else
{
fmodel = BllModel.GetModel(Request.Form["txtFromMID"]);
}
tmodel = BllModel.GetModel(Request.Form["txtMID"]);
if (fmodel == null || tmodel == null)
{
return("转入或转出会员不存在！");
}
if (tmodel.IsClock)
{
return("对方账户已冻结,无法转账！");
}
if (!string.IsNullOrEmpty(Request.Form["txtMHB"]))
{
int money = int.Parse(Request.Form["txtMHB"]);
return(BLL.ChangeMoney.ZZMoneyChange(money, fmodel.MID, Request.Form["txtMID"], "ZZ", MType));
}
else
{
return("转账金额不能为空");
}
}
//else
// return "密保问题错误";
}
private bool isParent(string mid)
{
List <Model.Member> ListMember = BllModel.GetMemberEntityList(string.Format("MTJ='{0}' and MID<>'{0}' order by MDate", mid));
if (ListMember != null && ListMember.Any())
{
return(true);
}
else
{
return(false);
}
}
protected override void SetValue(string id)
{
Model.Member model = BllModel.GetModel(id);
if (model != null)
{
if (TModel.MID == model.FMID || TModel.FMID == model.MID || TModel.Role.IsAdmin)
{
BllModel.TModel = model;
FormsAuthentication.SetAuthCookie(model.MID, true);
}
}
Response.Redirect("Default.aspx");
}
protected override string btnModify_Click()
{
//判断是否信息完整
if (string.IsNullOrEmpty(TModel.BankCardName) || (string.IsNullOrEmpty(TModel.BankNumber) && string.IsNullOrEmpty(TModel.NumID)))
{
return("请先完善资料");
}
//校验激活码
string activeCode = Request.Form["txtActiveCode"];
Model.ActiveCode list = BLL.ActiveCode.GetList("Code='" + activeCode + "' and UseState not in (2,4)").FirstOrDefault();
if (list == null)
{
return("激活码无效");
}
Model.SHMoney shmoney = BLL.Configuration.Model.SHMoneyList["002"];//默认002
//if (BLL.ChangeMoney.EnoughChange(TModel.MID, BLL.Configuration.Model.YLMoney, "MHB"))
//{
try
{
if (BLL.Member.upmidlist.Contains(TModel.MID))
{
return("2");
}
else
{
BLL.Member.upmidlist.Add(TModel.MID);
}
Hashtable MyHs = new Hashtable();
list.UseMID = TModel.MID;
list.UseState = 2;
list.UseTime = DateTime.Now;
BLL.ActiveCode.Update(list, MyHs);
return(BllModel.UpMAgencyType(shmoney, TModel.MID, TModel, 0, MyHs));
}
finally
{
if (BLL.Member.upmidlist.Contains(TModel.MID))
{
BLL.Member.upmidlist.Remove(TModel.MID);
}
}
//}
//else
//{
// return "您的激活币账号余额不足";
//}
}
public override void ProcessRequest(HttpContext context)
{
base.ProcessRequest(context);
string RoleCode = "";
foreach (Model.Roles item in BLL.Roles.RolsList.Values.ToList().Where(emp => !emp.IsAdmin && emp.VState).ToList())
{
RoleCode += "'" + item.RType + "',";
}
RoleCode = RoleCode.Substring(0, RoleCode.Length - 1);
string strWhere = " RoleCode in (" + RoleCode + ")";
strWhere += " and '1'='1' ";
Model.Member memberModel = (TModel == null ? BllModel.TModel : TModel);
if (!string.IsNullOrEmpty(context.Request["tState"]))
{
if (context.Request["tState"] == "001")
{
strWhere += " and AgencyCode='" + context.Request["tState"] + "' and MTJ='" + memberModel.MID + "' ";
}
else
{
strWhere += " and AgencyCode<>'001' and MTJ='" + memberModel.MID + "' ";
}
}
int count;
List <Model.Member> ListMember = BllModel.GetMemberEntityList(strWhere, pageIndex, pageSize, out count);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < ListMember.Count; i++)
{
sb.Append(ListMember[i].MID + "~");
sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~");
sb.Append(ListMember[i].MID + BLL.Member.GetOnlineInfo(ListMember[i].MID) + "~");
sb.Append(ListMember[i].MName + "~");
sb.Append(ListMember[i].MAgencyType.MAgencyName + "~");
sb.Append(ListMember[i].NewSHMoney.NName + "~");
sb.Append(ListMember[i].QQ + "~");
//sb.Append(ListMember[i].Email + "~");
sb.Append(ListMember[i].Tel + "~");
sb.Append(ListMember[i].MCreateDate.ToString("yyyy-MM-dd HH:mm") + "~");
sb.Append(ListMember[i].MDate.Year == DateTime.MaxValue.Year ? "未升级" : ListMember[i].MDate.ToString("yyyy-MM-dd HH:mm"));
sb.Append("≌");
}
var info = new { PageData = Traditionalized(sb), TotalCount = count };
//var json = new { PageData = sb.ToString(), TotalCount = count };匿名类
context.Response.Write(JavaScriptConvert.SerializeObject(info));
}
protected override string btnOther_Click()
{
string where = " 1=1 ";
//string where = string.Format(" MID = '{0}' ", TModel.MID);
//var txtCode = Request["txtCode"];
//if (!string.IsNullOrEmpty(txtCode))
//{
// where += string.Format(" and Code = '{0}'", txtCode);
//}
string mkey = "";
string state = Request.Form["state"];
if (!string.IsNullOrEmpty(state))
{
if (state == "FJ")
{
where += " and TFromMID='" + TModel.MID + "' ";
}
else
{
where += " and TToMID='" + TModel.MID + "' ";
}
}
else
{
where += " and TFromMID='" + TModel.MID + "' ";
}
mkey = TModel.MID;
//if (!string.IsNullOrEmpty(Request["begin_time"]))
//{
// where += " and ChangeDate>'" + Request["begin_time"] + " 00:00:00' ";
//}
//if (!string.IsNullOrEmpty(Request["end_time"]))
//{
// where += " and ChangeDate<'" + Request["end_time"] + " 23:59:59' ";
//}
List <Model.Task> listchange = BllModel.GetTaskEntityList(where, CurrentPage, ItemsPerPage, out totalCount);
var list = listchange.Select(item => new
{
content = item.TContent,
//type = item.TTypeStr,
date = item.TDateTime.ToString()
});
return(jss.Serialize(new { Items = list, TotalCount = totalCount }));
}
protected string GetBankInfo(object mid)
{
string result = string.Empty;
if (!string.IsNullOrEmpty(mid.ToString()))
{
Model.Member mem = BllModel.GetModel(mid.ToString());
if (mem != null)
{
result = "开户银行：" + mem.Bank + " 开户名：" + mem.BankCardName + "<br/>开户支行：" + mem.Branch + "<br/>银行账号：" + mem.BankNumber + "<br/>手机号码：" + mem.Tel;
}
}
return(result);
}
public override void ProcessRequest(HttpContext context)
{
base.ProcessRequest(context);
string mKey = "";
string strWhere = " '1'='1' ";
if (!string.IsNullOrEmpty(context.Request["mKey"]))
{
mKey = context.Request["mKey"];
}
if (!string.IsNullOrEmpty(context.Request["startDate"]))
{
strWhere += " and changedate>'" + context.Request["startDate"] + " 00:00:00' ";
}
if (!string.IsNullOrEmpty(context.Request["endDate"]))
{
strWhere += " and changedate<'" + context.Request["endDate"] + " 23:59:59' ";
}
Model.Member memberModel = (TModel == null ? BllModel.TModel : TModel);
if (!memberModel.Role.Super)
{
mKey = memberModel.MID;
}
strWhere += string.Format(" and (FromMID='{0}' or ToMID='{0}') ", mKey);
List <Model.ChangeMoney> ListChangeMoney = BllModel.GetChangeMoneyEntityList(strWhere + " order by ChangeDate desc");
StringBuilder sb = new StringBuilder();
for (int i = (pageIndex - 1) * pageSize; i < ListChangeMoney.Count && i < pageIndex * pageSize; i++)
{
Model.Member member = BllModel.GetModel(mKey);
sb.Append(ListChangeMoney[i].CID + "~");
sb.Append(i + 1 + "~");
sb.Append(member.MID + "~");
sb.Append(member.MName + "~");
sb.Append((ListChangeMoney[i].FromMID == member.MID ? "<b style='color:red;'>支出</b>" : "<b style='blue'>收入</b>") + "~");
sb.Append(ListChangeMoney[i].Money.ToFixedDecimal() + "~");
sb.Append((ListChangeMoney[i].CState ? "已生效" : "未生效") + "~");
sb.Append(ListChangeMoney[i].ChangeTypeStr + "~");
sb.Append(ListChangeMoney[i].ChangeDate.ToString("yyyy-MM-dd HH:mm"));
sb.Append("≌");
}
var info = new { PageData = Traditionalized(sb), TotalCount = ListChangeMoney.Count };
context.Response.Write(JavaScriptConvert.SerializeObject(info));
}
public override void ProcessRequest(HttpContext context)
{
base.ProcessRequest(context);
string strWhere = " MID<>''";
string sh = " and IsValid=0 ";
if (!string.IsNullOrEmpty(context.Request["tState"]))
{
if (context.Request["tState"] == "true")
{
sh = " and IsValid=1 ";
}
}
if (!string.IsNullOrEmpty(context.Request["mKey"]))
{
strWhere += string.Format(" and MID='{0}' ", (context.Request["mKey"]));
}
if (!string.IsNullOrEmpty(context.Request["startDate"]))
{
strWhere += " and CreateTime>'" + context.Request["startDate"] + " 00:00:00' ";
}
if (!string.IsNullOrEmpty(context.Request["endDate"]))
{
strWhere += " and CreateTime<'" + context.Request["endDate"] + " 23:59:59' ";
}
int count;
List <Model.Agents> ListMember = BLL.Agents.GetBCenterEntityList(strWhere + sh, pageIndex, pageSize, out count);
StringBuilder sb = new StringBuilder();
for (int i = 0; i < ListMember.Count; i++)
{
Model.Member model = BllModel.GetModel(ListMember[i].MID);
sb.Append(ListMember[i].ID + "~");
sb.Append((i + 1) + (pageIndex - 1) * pageSize + "~");
sb.Append(ListMember[i].MID + "~");
sb.Append(model.MName + "~");
sb.Append(model.Tel + "~");
sb.Append(ListMember[i].CreateTime.ToString("yyyy-MM-dd HH:mm") + "~");
sb.Append(BLL.Roles.RolsList[ListMember[i].Type].RName + "~");
sb.Append(ListMember[i].Province + ListMember[i].City + ListMember[i].Zone + "~");
sb.Append(ListMember[i].IsValidStr);
sb.Append("≌");
}
var info = new { PageData = Traditionalized(sb), TotalCount = count };
context.Response.Write(JavaScriptConvert.SerializeObject(info));
}
protected override string btnOther_Click()
{
string where = " 1=1 ";
//string where = string.Format(" MID = '{0}' ", TModel.MID);
//var txtCode = Request["txtCode"];
//if (!string.IsNullOrEmpty(txtCode))
//{
// where += string.Format(" and Code = '{0}'", txtCode);
//}
string mkeyfrom = "";
string mkeyto = "";
string state = Request.Form["state"];
if (!string.IsNullOrEmpty(state))
{
if (state == "ZC")
{
where += " and FromMID='" + TModel.MID + "' ";
mkeyfrom = TModel.MID;
}
else
{
where += " and ToMID='" + TModel.MID + "' ";
mkeyto = TModel.MID;
}
}
else
{
where += " and FromMID='" + TModel.MID + "' ";
mkeyfrom = TModel.MID;
}
List <Model.ChangeMoney> listchange = null;
listchange = BllModel.GetChangeMoneyEntityList(mkeyfrom, mkeyto, "", "true", new List <string> {
"ZZ"
}, new List <string> {
"MHB", "MJB", "MGP", "MCW", "TotalYFHMoney"
}, CurrentPage, ItemsPerPage, where, out totalCount);
var list = listchange.Select(item => new
{
MID = !string.IsNullOrEmpty(mkeyfrom)?item.ToMID:item.FromMID,
Money = item.Money,
MoneyType = item.MoneyTypeStr,
ChangeDate = item.ChangeDate.ToString()
});
return(jss.Serialize(new { Items = list, TotalCount = totalCount }));
}
/// <summary>
/// 更新基本资料
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected override string btnModify_Click()
{
Hashtable MyHs = new Hashtable();
if (Request.Form["chkCloseAll"] == "on" || Request.Form["chkClockAll"] == "on")
{
string where = "";
if (Request.Form["chkCloseAll"] == "on")
{
where += string.Format(" IsClose = {0} ", (MemberModel.IsClose ? 1 : 0));
}
if (Request.Form["chkClockAll"] == "on")
{
where += string.Format(" IsClock = {0} ", (MemberModel.IsClock ? 1 : 0));
}
if (!string.IsNullOrEmpty(where))
{
MyHs.Add(string.Format("update Member set {0} where MID in (select mid from [dbo].[getSubBDMember]('{1}'))", where, MemberModel.MID), null);
}
//List<Model.Member> list = BllModel.GetMemberEntityList("MID in (select mid from getTreeBuyMID('" + MemberModel.MID + "'))");
//foreach (Model.Member item in list)
//{
// if (Request.Form["chkCloseAll"] == "on")
// item.IsClose = MemberModel.IsClose;
// if (Request.Form["chkClockAll"] == "on")
// item.IsClock = MemberModel.IsClock;
// BllModel.Update(item, MyHs);
//}
}
BllModel.Update(MemberModel, MyHs);
//string error = BLL.Member.CanSetAgency(MemberModel);
//if (!string.IsNullOrEmpty(error))
//{
// return error;
//}
//MyHs.Add(" update member set MSH = '" + MemberModel.MID + "' where " + BLL.Member.GetLeaderCondition(MemberModel) + " and MID <> '" + MemberModel.MID + "'", null);
if (MemberModel.Role.IsAdmin)
{
UpdateQuestion(MemberModel.ID, MyHs);
}
if (BLL.CommonBase.RunHashtable(MyHs))
{
BLL.OperationRecordBLL.Add(TModel.MID, ChangeType.O_XGHYZL, string.Format("修改{0}的资料", MemberModel.MID));
return("操作成功");
}
return("操作失败");
}
