protected void Page_Load(object sender, EventArgs e) { NowDate = DateTime.Now.ToString(); BLL.UserBLL ubll = new BLL.UserBLL(); BLL.MerchantBLL mbll = new BLL.MerchantBLL(); Model.CurrentMerModel cm = BLL.MerchantBLL.CurrentModel(); CurrentUserId = cm.CurrentUserId; IsAdmin = ubll.IsAdministrator(); if (CurrentUserId.Trim() == "" || CurrentUserId == null) { IsLogin = false; Response.Write("<script src=\"/Script/jquery-1.8.2.js\"></script><script src = \"/Script/ZYUiPub.js\" ></script> "); Response.Write("<script>window.parent.LoginCookie(); setTimeout(function(){ shuaxin(); },1000) </script>"); Response.End(); // throw new Exception("您还没有登录!"); } else { IsLogin = true; } StringBuilder s = new StringBuilder(); s.Append(" var CurrentUserId='" + CurrentUserId + "'; "); s.Append(" var IsAdmin=" + IsAdmin.ToString().ToLower() + "; "); s.Append(" var IsLogin="******"; "); try { decimal MerId = Convert.ToDecimal(Request.QueryString["MerId"]); if (MerId == 0) { MerId = BLL.MerchantBLL.CurrentModel().CurrentMerId; } if (MerId == 0) { } else { mbll.CheckChangeMerPower(MerId); } MerJson = Common.JsonHelper.ToJsonNo1(mbll.GetMerInfoFaseById(MerId)); s.Append(" var MerJson=" + MerJson + "; "); } catch { } ScriptStr = s.ToString(); }
private void GetMerListData() { BLL.MerchantBLL bllMer = new BLL.MerchantBLL(); DataTable dt = bllMer.GetMerList(" FlagInvalid=0 "); ReDict.Add("MerListData", Common.JsonHelper.ToJson(dt)); ReTrue(); }
private void GetMerList() { string CurrentUserId = ReStr("CurrentUserId"); BLL.MerchantBLL bll = new BLL.MerchantBLL(); try { DataTable dt = bll.GetMerList(" "); } catch (Exception) { throw; } }
private void SaveUser() { Model.UserInfoModel model = new Model.UserInfoModel(); model.Birthday = ReTime("Birthday", DateTime.Parse("1900-01-01")); model.CreateTime = DateTime.Now; model.Currency = 0; model.Email = ReStr("Email", ""); model.FlagMerchant = true; model.IdNo = ReStr("IdNo", ""); model.Memo = ReStr("Memo", ""); model.Phone = ReStr("Phone", ""); model.PicBig = ReStr("PicBig", ""); model.PicMid = ReStr("PicMid", ""); model.PicSmall = ReStr("PicSmall", ""); model.Power = 0; model.Pwd = ReStr("Pwd", ""); model.PwdMd5 = ReStr("PwdMd5", ""); model.qq = ReStr("qq", ""); model.RealName = ReStr("RealName", ""); model.Sex = ReStr("sex", "未知"); model.StreetId = 0; model.Tell = ReStr("Tell", ""); model.TownId = 1; model.UserCode = ReInt("UserCode", 0); model.UserId = ReStr("uid", ""); if (model.UserId.Trim() == "") { throw new Exception("不能为空!"); } model.UserLv = ReInt("UserLv", 90); model.UserTitle = ReStr("UserTitle", ""); model.UserTypeId = 3; model.Validated = ReBool("Validated", true); model.WxOpenID = ReStr("WxOpenID", ""); BLL.MerchantBLL mbll = new BLL.MerchantBLL(); BLL.UserBLL ubll = new BLL.UserBLL(); if (model.UserId == "小王") { if (ubll.CurrentUserId() != "小王") { throw new Exception("小王不是一般人能改的!-_-!"); } } ubll.SaveMyUserInfo(model); ReTrue(); }
private void GetMerData() { try { BLL.TownBLL bll = new BLL.TownBLL(); BLL.MerchantBLL bllMer = new BLL.MerchantBLL(); DataTable dt = bll.GetTownList(); string json = Common.JsonHelper.ToJson(dt); DataTable dtMerType = bllMer.GetMerTypeList(""); string jsonMerType = Common.JsonHelper.ToJson(dtMerType); ReDict.Add("TownList", json); //乡镇类别 ReDict.Add("jsonMerType", jsonMerType); //商家类别 ReTrue(); } catch (Exception ex) { ReThrow(ex); } }
private void AddUser() { BLL.MerchantBLL mbll = new BLL.MerchantBLL(); BLL.UserBLL ubll = new BLL.UserBLL(); Model.UserInfoModel model = new Model.UserInfoModel(); Model.MerRoleVsUserModel vsModel = new Model.MerRoleVsUserModel(); model.UserId = ReStr("uid", ""); if (model.UserId.Length < 5) { throw new Exception("用户名不能小于5个字符!"); } model.CreateTime = DateTime.Now; model.Birthday = DateTime.Parse("1900-01-01"); #region 事务开启 TransactionOptions transactionOption = new TransactionOptions(); transactionOption.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionOption)) { #endregion ubll.AddUser(model); vsModel.UserId = model.UserId; vsModel.BranchId = ReStr("BranchId", ""); vsModel.MerRoleId = ReDecimal("MerRoleId", 0); mbll.SaveMerRoleVsUser(vsModel); #region 事务关闭 transactionScope.Complete(); } #endregion ReTrue(); }
protected void Page_Load(object sender, EventArgs e) { Model.CurrentMerModel cm = BLL.MerchantBLL.CurrentModel(); BLL.MerchantBLL mBll = new BLL.MerchantBLL(); StringBuilder s = new StringBuilder(); s.Append(" select * from dbo.MerRole with(nolock) where MerId='" + cm.CurrentMerId + "' "); //0 s.Append(" select * from CORE.dbo.MenuVsMerRole with(nolock) "); //1 s.Append(" select * from CORE.dbo.MenuInfo with(nolock) where AdminPower!=100 "); //2 s.Append(" select * from CORE.dbo.AppMenuVsMerRole with(nolock) "); //3 s.Append(" select * from CORE.dbo.AppMenuInfo with(nolock) "); //4 s.Append(" SELECT * FROM DBMSG.dbo.MsgType with(nolock) WHERE TargetLv BETWEEN 10 AND 20 "); DataSet ds = DAL.DalComm.BackData(s.ToString()); DataTable dtMerRole = ds.Tables[0]; DataTable dtMerMenuVsMerRole = ds.Tables[1]; DataTable dtMernu = ds.Tables[2]; DataTable dtAppMenu = ds.Tables[4]; DataTable dtAppMerMenuVsMerRole = ds.Tables[3]; DataTable dtMsgType = ds.Tables[5]; StringBuilder w = new StringBuilder(); foreach (DataRow dr in dtMerRole.Rows) { w.Append(" <li MerRoleId='" + dr["MerRoleId"] + "'>" + dr["MerRoleName"] + "</li>"); } MerRoleListHtml = w.ToString(); w.Clear(); #region PC菜单开始 DataTable dtParentMenu = Common.DataSetting.TableSelect(" ParentMenuId='' ", dtMernu); foreach (DataRow dr in dtParentMenu.Rows) { string MenuId = dr["MenuId"].ToString(); string MenuName = dr["MenuName"].ToString(); w.Append("<dl>"); w.Append("<dt MenuId='" + MenuId + "' >"); w.Append("<input class='cb_sel' type='checkbox' />"); w.Append(MenuName); w.Append("</dt>"); DataTable dtCldMenu = Common.DataSetting.TableSelect(" ParentMenuId='" + MenuId + "' ", dtMernu); if (dtCldMenu.Rows.Count > 0) { foreach (DataRow drCld in dtCldMenu.Rows) { string CldMenuId = drCld["MenuId"].ToString(); string CldMenuName = drCld["MenuName"].ToString(); w.Append("<dd MenuId='" + CldMenuId + "'>"); w.Append("<input class='cb_sel' type='checkbox' />"); w.Append(CldMenuName); w.Append("</dd>"); } } w.Append("</dl>"); } MenuListHtml = w.ToString(); w.Clear(); #endregion #region 手机菜单开始 //手机菜单开始 DataTable dtParentAppMenu = Common.DataSetting.TableSelect(" ParentAppMenuId='' ", dtAppMenu); foreach (DataRow dr in dtParentAppMenu.Rows) { string AppMenuId = dr["AppMenuId"].ToString(); string AppMenuName = dr["AppMenuName"].ToString(); w.Append("<dl>"); w.Append("<dt AppMenuId='" + AppMenuId + "' >"); w.Append("<input class='cb_sel' type='checkbox' />"); w.Append(AppMenuName); w.Append("</dt>"); DataTable dtCldAppMenu = Common.DataSetting.TableSelect(" ParentAppMenuId='" + AppMenuId + "' ", dtAppMenu); if (dtCldAppMenu.Rows.Count > 0) { foreach (DataRow drCld in dtCldAppMenu.Rows) { string CldAppMenuId = drCld["AppMenuId"].ToString(); string CldAppMenuName = drCld["AppMenuName"].ToString(); w.Append("<dd AppMenuId='" + CldAppMenuId + "'>"); w.Append("<input class='cb_sel' type='checkbox' />"); w.Append(CldAppMenuName); w.Append("</dd>"); } } w.Append("</dl>"); } AppMenuListHtml = w.ToString(); #endregion #region 消息侦听开始 w.Clear(); if (dtMsgType.Rows.Count > 0) { foreach (DataRow drMsgType in dtMsgType.Rows) { w.Append("<a class='a_MsgType' id='a_" + drMsgType["MsgTypeId"] + "' MsgTypeId='" + drMsgType["MsgTypeId"] + "' >"); w.Append(drMsgType["MsgTypeName"].ToString()); w.Append("</a>"); } MsgTypeHtml = w.ToString(); } #endregion }
private void SendPeiHuoRemind() //配货人员提醒 { BLL.WxBLL wbll = new BLL.WxBLL(); string DingDanId = ReStr("DingDanId", ""); DataTable dtUser = ReTable("UserList"); string SendMemo = ReStr("SendMemo", ""); decimal QyWxPtAppId = ReDecimal("QyWxPtAppId", 0); StringBuilder w = new StringBuilder(); StringBuilder s = new StringBuilder(); List <string> ToUserList = new List <string>(); #region 事务开启 TransactionOptions transactionOption = new TransactionOptions(); transactionOption.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required, transactionOption)) { #endregion BLL.MerchantBLL mbll = new BLL.MerchantBLL(); mbll.ShenHeDingdan(DingDanId, 1, "通过审核"); s.Append("SELECT * FROM dbo.DingDanDetailView WITH(NOLOCK) WHERE DingDanId='" + DingDanId + "' ORDER BY DingDanDetailTypeId "); s.Append(" SELECT * FROM dbo.DingDanView WITH(NOLOCK) WHERE DingDanId='" + DingDanId + "' "); DataSet ds = DAL.DalComm.BackData(s.ToString()); DataTable dtDetail = ds.Tables[0]; DataTable dtInfo = ds.Tables[1]; if (dtInfo.Rows.Count != 1) { throw new Exception("这是个什么订单?"); } DataRow drInfo = dtInfo.Rows[0]; decimal MerId = decimal.Parse(drInfo["MerchantId"].ToString()); decimal amount = decimal.Parse(drInfo["Amount"].ToString()); DateTime PeiSongTime1 = DateTime.Parse(drInfo["PeiSongTime1"].ToString()); DateTime PeiSongTime2 = DateTime.Parse(drInfo["PeiSongTime2"].ToString()); amount = Math.Round(amount, 2); w.Append("编号:\n " + DingDanId + " \n"); if (SendMemo.Trim() != "") { w.Append("调度备注:" + SendMemo + " \n"); } w.Append("总金额:" + amount + " \n"); w.Append("物流:" + PeiSongTime1.ToString("yy年MM月dd日 hh时mm分") + "-" + PeiSongTime2.ToString("yy年MM月dd日 hh时mm分") + ""); w.Append("(" + drInfo["PeiSongTypeName"] + ") \n"); var url = "http://www.sjdfcs.com/App/AppDingDanList_PeiHuo.aspx?DingDanId=" + DingDanId + ""; w.Append("<a href='" + wbll.QyWxUrl(url, MerId) + "' >查看详细</a> \n"); if (dtDetail.Rows.Count == 0) { throw new Exception("这个订单[" + DingDanId + "]没有明细吗?"); } s.Clear(); foreach (DataRow drUser in dtUser.Rows) { ToUserList.Add(drUser["QyWxPtUserId"].ToString()); s.Append(" UPDATE dbo.DingDanInfo SET PeiHuoUserId='" + drUser["UserId"].ToString() + "',Status=20 WHERE DingDanId='" + DingDanId + "' "); } DAL.DalComm.ExReInt(s.ToString()); #region 暂时无用 //foreach (DataRow drDetail in dtDetail.Rows) //{ // decimal Price = decimal.Parse(drDetail["Price"].ToString()); // Price = Math.Round(Price, 2); // decimal Quantity = decimal.Parse(drDetail["Quantity"].ToString()); // Quantity = Math.Round(Quantity); // string 规格 = drDetail["规格"].ToString().Trim(); // int DingDanDetailTypeId = int.Parse(drDetail["DingDanDetailTypeId"].ToString()); // if (DingDanDetailTypeId == 10) // { // w.Append("配送费:" + Price + "元 \n"); // } // else // { // //如果是产品 // w.Append("[" + drDetail["产品编号"] + "]"); // w.Append("" + drDetail["产品名称"] + ","); // if (规格 != "") // { // w.Append("规格:" + drDetail["规格"] + ","); // } // w.Append("单价:" + Price + "元,"); // w.Append("数量:" + Quantity + "" + drDetail["计量单位"] + ""); // w.Append(" \n "); // } //} #endregion #region 事务关闭 transactionScope.Complete(); } #endregion string jsonStr = wbll.SendQyTextMsg(ToUserList, w.ToString(), QyWxPtAppId); ReDict.Add("ReJson", jsonStr); ReTrue(); }