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("操作失败"); }