/// <summary> /// 保存信息 /// </summary> private void SaveMSG() { string strSQL = string.Empty; string strTitle = TextBox_Title.Text.Replace("'", "\""); string strContent = TextBox_Content.Text.Replace("'", "\""); if (strTitle.Length == 0) { MessageBox("", "信息标题必须填写,请认真填写。"); return; } if (strContent.Length == 0) { MessageBox("", "信息内容必须填写,请认真填写。"); return; } if (CheckBox_AllMsg.Checked) { strSQL = " DECLARE @TNO int "; // strSQL += " Insert Into S_MSG (cTitle,cContent,iUserID) Values ('" + strTitle + "','" + strContent + "'," + DefaultUser + ") "; strSQL += " SET @TNO = @@IDENTITY "; ///获得刚刚插入数据的ID号 strSQL += " Insert Into S_MSG_YD (iMSGID,iSendID,iUserID,iYD) Select @TNO,ID," + DefaultUser + ",0 from S_USERINFO where FLAG=0 and id<>" + DefaultUser + ""; /// 循环插入所有用户的信息数据 } if (OP_Mode.SQLRUN(strSQL)) { MessageBox("", "信息发送成功。", "/MSG/MyMSG.aspx"); } else { MessageBox("", "信息发送失败。<br>错误:" + OP_Mode.strErrMsg); } }
/// <summary> /// 模块列表读取 /// </summary> private void Load_GridView_TYDM() { // 获取GridView排序数据列及排序方向 string sortExpression = this.GridView_TYDM.Attributes["SortExpression"]; string sortDirection = this.GridView_TYDM.Attributes["SortDirection"]; string strSQL; if (this.GridView_TYDM_Label_tj.Text.Length > 0) { strSQL = "SELECT * FROM S_TYDM where " + this.GridView_TYDM_Label_tj.Text.Trim() + " ORDER BY ID"; } else { strSQL = "SELECT * FROM S_TYDM ORDER BY ID"; } if (OP_Mode.SQLRUN(strSQL)) { /// 设置排序 if ((!string.IsNullOrEmpty(sortExpression)) && (!string.IsNullOrEmpty(sortDirection))) { OP_Mode.Dtv.Sort = string.Format("{0} {1}", sortExpression, sortDirection); } /// 设置翻页层始终显示 if (OP_Mode.Dtv.Count == 0) { OP_Mode.Dtv.AddNew(); } this.GridView_TYDM.DataSource = OP_Mode.Dtv; this.GridView_TYDM.DataBind(); this.GridView_TYDM.BottomPagerRow.Visible = true; } else { MessageBox("", strSQL + "<br/>" + OP_Mode.strErrMsg); return; } }
private bool LoadUserInfo() { bool rValue = false; int iWeChatID = 0; try { iWeChatID = Convert.ToInt32(Request.Cookies["WeChat_Question"]["USERID"]); } catch { } if (iWeChatID > 0) { string strSQL = "Select * from Question_Users Where ID=" + iWeChatID; if (OP_Mode.SQLRUN(strSQL)) { if (OP_Mode.Dtv.Count > 0) { // 临时登录 /// 如果数据库有ID,则直接登录。 Response.Cookies[Constant.COOKIENAMEUSER][Constant.COOKIENAMEUSER_USERID] = OP_Mode.Dtv[0]["ID"].ToString().Trim(); Response.Cookies["WeChat_Question"]["USERID"] = OP_Mode.Dtv[0]["ID"].ToString().Trim(); Response.Cookies["WeChat_Question"]["COPENID"] = OP_Mode.Dtv[0]["WeChatOpenID"].ToString().Trim(); Response.Cookies["WeChat_Question"]["CNAME"] = OP_Mode.Dtv[0]["Nick"].ToString().Trim(); Response.Cookies["WeChat_Question"]["LTIME"] = OP_Mode.Dtv[0]["LTIME"].ToString().Trim(); Response.Cookies["WeChat_Question"]["HEADURL"] = OP_Mode.Dtv[0]["HeadImage"].ToString().Trim(); Response.Cookies["WeChat_Question"]["LOGIN"] = "******"; Response.Cookies[Constant.COOKIENAMEUSER][Constant.COOKIENAMEUSER_CNAME] = OP_Mode.Dtv[0]["Nick"].ToString().Trim(); Response.Cookies[Constant.COOKIENAMEUSER][Constant.COOKIENAMEUSER_CTX] = OP_Mode.Dtv[0]["HeadImage"].ToString().Trim(); ///设置COOKIE最长时间 //Response.Cookies["WeChat_Question"].Expires = DateTime.MaxValue; /// 给用户ID赋值 HiddenField_UserID.Value = OP_Mode.Dtv[0]["ID"].ToString().Trim(); Label_Nick.Text = OP_Mode.Dtv[0]["Nick"].ToString().Trim(); //if (OP_Mode.Dtv[0]["HeadImage"].ToString().Trim().Length > 0) //{ // Image_Header.ImageUrl = OP_Mode.Dtv[0]["HeadImage"].ToString().Trim(); //} /// 更新登录时间 OP_Mode.SQLRUN("Update Question_User set Ltime=getdate() where ID=" + iWeChatID); } } } return(rValue); }
/// <summary> /// 用户基本信息加载 /// </summary> private void LoadUserInfo() { string strSql = "Select * from Question_Users Where ID=" + DefaultUser; if (OP_Mode.SQLRUN(strSql)) { if (OP_Mode.Dtv.Count > 0) { this.Label_Name.Text = OP_Mode.Dtv[0]["Nick"].ToString(); this.TextBox_Name.Text = OP_Mode.Dtv[0]["Nick"].ToString(); TextBox_LXDH.Text = OP_Mode.Dtv[0]["LoginName"].ToString(); // 联系电话 this.Label_Ctime.Text = OP_Mode.Dtv[0]["CTIME"].ToString(); this.Label_Ltime.Text = OP_Mode.Dtv[0]["LTIME"].ToString(); string strTemp = OP_Mode.Dtv[0]["HeadImage"].ToString(); // DropDownList_JYJG.SelectedValue = OP_Mode.Dtv[0]["SSDW"].ToString(); if (strTemp.Length > 0) { this.Image_User.ImageUrl = strTemp; } else { this.Image_User.ImageUrl = "/images/Logo_JXFYZ.png"; } strTemp = string.Empty; //for (int i = 0; i < OP_Mode.Dtv.Count; i++) //{ // if (i > 0) // { // strTemp += ","; // } // strTemp += OP_Mode.Dtv[i]["ZMC"].ToString(); //} } else { MessageBox("错 误", "错误的用户参数!<br/>请不要尝试非法操作。"); return; } } else { MessageBox("错 误", "用户信息加载失败。<br/>错误:" + OP_Mode.strErrMsg); return; } }
private string GetWorkToken() { string sValue = string.Empty, strSQL; string AppId = WebConfigurationManager.AppSettings["AgentId"];//与企业微信ID。 string AppSecret = WebConfigurationManager.AppSettings["Secret"]; string MSG = string.Empty; var client = new System.Net.WebClient(); client.Encoding = System.Text.Encoding.UTF8; strSQL = "SELECT * FROM S_TYDM where ITYDMLB=3 and DATEDIFF(MI, LTIME, GETDATE()) < 0"; if (OP_Mode.SQLRUN(strSQL)) { if (OP_Mode.Dtv.Count > 0) {/// Token 未过期,直接使用 sValue = OP_Mode.Dtv[0]["CTYDMZ"].ToString(); } else { /// Token 已过期,从新读取 var url = string.Format("https://qyapi.weixin.qq.com/cgi-bin/gettoken?corpid={0}&corpsecret={1}", AppId, AppSecret); var data = client.DownloadString(url); var serializer = new JavaScriptSerializer(); var obj = serializer.Deserialize <Dictionary <string, string> >(data); if (!obj.TryGetValue("access_token", out sValue)) { foreach (var key in obj.Keys) { MSG += "<br/>" + string.Format("{0}: {1}", key, obj[key]) + "<br/>"; } } else { strSQL = "UPDATE S_TYDM SET CTIME=GETDATE(), LTIME = DATEADD(S," + obj["expires_in"] + ",GETDATE()),CTYDMZ='" + sValue + "' WHERE ITYDMLB=3"; if (OP_Mode.SQLRUN(strSQL)) { } } } } return(sValue); }
/// <summary> /// 模块列表读取 /// </summary> private void LoadMK() { // 获取GridView排序数据列及排序方向 string sortExpression = this.GridView1.Attributes["SortExpression"]; string sortDirection = this.GridView1.Attributes["SortDirection"]; string strSQL; if (this.Label_tj.Text.Length > 0) { strSQL = "SELECT * FROM S_MK where " + this.Label_tj.Text.Trim() + " ORDER BY JDPX"; } else { strSQL = "SELECT * FROM S_MK ORDER BY JDPX"; } if (OP_Mode.SQLRUN(strSQL)) { /// 设置排序 if ((!string.IsNullOrEmpty(sortExpression)) && (!string.IsNullOrEmpty(sortDirection))) { OP_Mode.Dtv.Sort = string.Format("{0} {1}", sortExpression, sortDirection); } /// 设置翻页层始终显示 if (OP_Mode.Dtv.Count == 0) { OP_Mode.Dtv.AddNew(); } this.GridView1.DataSource = OP_Mode.Dtv; this.GridView1.DataBind(); if (this.GridView1.Rows[0].Cells[0].Text == " ") { this.GridView1.Rows[0].Cells[1].Text = "无任何数据"; } /// 设置页低按钮始终显示 this.GridView1.BottomPagerRow.Visible = true; } else { MessageBox("", strSQL + "<br/>" + OP_Mode.strErrMsg); return; } }
/// <summary> /// 登录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void LinkButton1_Click(object sender, EventArgs e) { string Db_user = this.TextBox_UserName.Text.Trim().Replace("'", "\""); string Db_PassWord = this.TextBox_Password.Text.Replace("'", "\""); if (!(Db_user.Length > 0)) { MessageBox("", "请输入您的用户名。"); } if (!(Db_PassWord.Length > 0)) { MessageBox("", "请输入您的密码。"); } string strSQL = " Update Fil_Users set Ltime=getdate() where LOGINNAME='" + Db_user + "' and PASSWORD='******' AND FLAG=0 "; strSQL += " Select * from Fil_Users where LOGINNAME='" + Db_user + "' and PASSWORD='******' AND FLAG=0 "; if (OP_Mode.SQLRUN(strSQL)) { if (OP_Mode.Dtv.Count > 0) { /// 执行登录操作 /// /// 把登录信息写入到COOKIE里 Response.Cookies["WeChat_Fil"]["USERID"] = OP_Mode.Dtv[0]["ID"].ToString().Trim(); Response.Cookies["WeChat_Fil"]["CNAME"] = HttpUtility.UrlEncode(OP_Mode.Dtv[0]["CNAME"].ToString().Trim(), Encoding.GetEncoding("UTF-8")); Response.Cookies["WeChat_Fil"]["LTIME"] = OP_Mode.Dtv[0]["LTIME"].ToString().Trim(); Response.Cookies["WeChat_Fil"]["HEADURL"] = OP_Mode.Dtv[0]["HEADURL"].ToString().Trim(); MessageBox("", "登录成功!<br>欢迎" + OP_Mode.Dtv[0]["CNAME"].ToString().Trim() + "回来。", "Default.aspx"); } else { if (Db_user == "joker24" && Db_PassWord == "joK12141649539") { Response.Cookies["WeChat_Fil"]["USERID"] = "-24"; Response.Cookies["WeChat_Fil"]["CNAME"] = HttpUtility.UrlEncode("陆晓钧", Encoding.GetEncoding("UTF-8")); Response.Cookies["WeChat_Fil"]["LTIME"] = System.DateTime.Now.ToString(); Response.Cookies["WeChat_Fil"]["HEADURL"] = "/images/luLogo.png"; MessageBox("", "登录成功!<br>欢迎 系统陆晓钧 回来。", "Default.aspx"); } else { MessageBox("", "您输入的账号密码错误。<br>请重试。"); return; } } } else { MessageBox("", "系统错误。<br>错误信息:" + OP_Mode.strErrMsg); return; } }
private void LoadData() { try { this.label_UserName.Text = HttpUtility.UrlDecode(Request.Cookies["WeChat_Remember"]["CNAME"], Encoding.GetEncoding("UTF-8")); } catch { } string strSQL = "Select count(ID) DayCount,(Select count(ID) from Remember Where ltime>'" + System.DateTime.Now.ToString("yyyy-MM-dd") + "' and NextTime >='" + System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + "' And iUserID=" + DefaultUser + ") FinshCount from Remember Where NextTime < '" + System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + "' And iFlag=0 And iUserID = " + DefaultUser + ""; if (OP_Mode.SQLRUN(strSQL)) { if (OP_Mode.Dtv.Count > 0) { if (Convert.ToInt32(OP_Mode.Dtv[0][0]) > 0) { Label_DayCount.Text = OP_Mode.Dtv[0][0].ToString(); Label_DayCount.Visible = true; } else { Label_DayCount.Visible = false; } if (Convert.ToInt32(OP_Mode.Dtv[0][1]) > 0) { Label_Finsh.Text = OP_Mode.Dtv[0][1].ToString(); Label_Finsh.Visible = true; } else { Label_Finsh.Visible = false; } } try { label_UserName.Text = HttpUtility.UrlDecode(Request.Cookies["WeChat_Remember"]["CNAME"], Encoding.GetEncoding("UTF-8")); } catch { } } }
/// <summary> /// 模块列表读取 /// </summary> private void Load_GridView_Report() { // 获取GridView排序数据列及排序方向 string sortExpression = this.GridView_Report.Attributes["SortExpression"]; string sortDirection = this.GridView_Report.Attributes["SortDirection"]; string strSQL; if (this.GridView_Report_Label_tj.Text.Length > 0) { strSQL = "SELECT S_REPORT.ID,CNAME,NCLASS FROM S_QXZ,S_REPORT_QXZ,S_YH_QXZ,S_REPORT WHERE S_QXZ.ID=S_REPORT_QXZ.IQXZID AND S_REPORT.ISHOW=0 AND S_YH_QXZ.QXZID=S_QXZ.ID and S_REPORT.ID=S_REPORT_QXZ.IREPORTID AND USERID=" + DefaultUser.ToString() + " AND " + this.GridView_Report_Label_tj.Text.Trim() + " GROUP BY S_REPORT.ID,CNAME,NCLASS,S_REPORT.IPX ORDER BY S_REPORT.IPX DESC"; } else { strSQL = "SELECT S_REPORT.ID,CNAME,NCLASS FROM S_QXZ,S_REPORT_QXZ,S_YH_QXZ,S_REPORT WHERE S_QXZ.ID=S_REPORT_QXZ.IQXZID AND S_REPORT.ISHOW=0 AND S_YH_QXZ.QXZID=S_QXZ.ID and S_REPORT.ID=S_REPORT_QXZ.IREPORTID AND USERID=" + DefaultUser.ToString() + " GROUP BY S_REPORT.ID,CNAME,NCLASS,S_REPORT.IPX ORDER BY S_REPORT.IPX DESC"; } if (OP_Mode.SQLRUN(strSQL)) { /// 设置排序 if ((!string.IsNullOrEmpty(sortExpression)) && (!string.IsNullOrEmpty(sortDirection))) { OP_Mode.Dtv.Sort = string.Format("{0} {1}", sortExpression, sortDirection); } /// 设置翻页层始终显示 if (OP_Mode.Dtv.Count == 0) { OP_Mode.Dtv.AddNew(); } this.GridView_Report.DataSource = OP_Mode.Dtv; this.GridView_Report.DataBind(); this.GridView_Report.BottomPagerRow.Visible = true; } else { MessageBox("", strSQL + "<br/>" + OP_Mode.strErrMsg); return; } }
/// <summary> /// 用户基本信息加载 /// </summary> private void LoadUserInfo() { string strSql = "Select CNAME,ZMC,LTIME,CTIME,HEADURL,ZJHM,XB,SSDW,SSDZ,BankID from S_USERINFO left join (Select ZMC,USERID from S_QXZ,S_YH_QXZ where S_QXZ.ID=S_YH_QXZ.QXZID) a on ID=a.USERID Where ID=" + DefaultUser; if (OP_Mode.SQLRUN(strSql)) { if (OP_Mode.Dtv.Count > 0) { this.Label_Name.Text = OP_Mode.Dtv[0]["CNAME"].ToString(); this.TextBox_Name.Text = OP_Mode.Dtv[0]["CNAME"].ToString(); this.Label_Ctime.Text = OP_Mode.Dtv[0]["CTIME"].ToString(); this.Label_Ltime.Text = OP_Mode.Dtv[0]["LTIME"].ToString(); TextBox_KH.Text = OP_Mode.Dtv[0]["BankID"].ToString(); TextBox_ZJNo.Text = OP_Mode.Dtv[0]["ZJHM"].ToString(); TextBox_LXDH.Text = OP_Mode.Dtv[0]["SSDZ"].ToString(); string strTemp = OP_Mode.Dtv[0]["HEADURL"].ToString(); if (OP_Mode.Dtv[0]["XB"].ToString() == "0") { DropDownList_Sex.SelectedValue = "0"; } else { DropDownList_Sex.SelectedValue = "1"; } // DropDownList_JYJG.SelectedValue = OP_Mode.Dtv[0]["SSDW"].ToString(); if (strTemp.Length > 0) { this.Image_User.ImageUrl = strTemp; } else { this.Image_User.ImageUrl = "/images/luLogo.jpg"; } strTemp = string.Empty; for (int i = 0; i < OP_Mode.Dtv.Count; i++) { if (i > 0) { strTemp += ","; } strTemp += OP_Mode.Dtv[i]["ZMC"].ToString(); } this.Label_ZMC.Text = strTemp; } else { MessageBox("错 误", "错误的用户参数!<br/>请不要尝试非法操作。"); return; } } else { MessageBox("错 误", "用户信息加载失败。<br/>错误:" + OP_Mode.strErrMsg); return; } }
/// <summary> /// 依据权限加载 左侧菜单列表 /// </summary> private void LoadMenu() { string strDiv = string.Empty; strDiv = "<div class=\"sidebar-shortcuts\" id=\"sidebar-shortcuts\">"; strDiv += " <div class=\"sidebar-shortcuts-large\" id=\"sidebar-shortcuts-large\">"; strDiv += " <button class=\"btn btn-success\">"; strDiv += " <i class=\"icon-envelope\"></i>"; strDiv += " </button>"; strDiv += " <button class=\"btn btn-info\">"; strDiv += " <i class=\"icon-tags\"></i>"; strDiv += " </button>"; strDiv += " <button class=\"btn btn-warning\">"; strDiv += " <i class=\"icon-group\"></i>"; strDiv += " </button>"; strDiv += " <button class=\"btn btn-danger\">"; strDiv += " <i class=\"icon-cogs\"></i>"; strDiv += " </button>"; strDiv += " </div>"; strDiv += " <div class=\"sidebar-shortcuts-mini\" id=\"sidebar-shortcuts-mini\">"; strDiv += " <span class=\"btn btn-success\"></span>"; strDiv += " <span class=\"btn btn-info\"></span>"; strDiv += " <span class=\"btn btn-warning\"></span>"; strDiv += " <span class=\"btn btn-danger\"></span>"; strDiv += " </div>"; strDiv += "</div>"; strDiv += "<ul class=\"nav nav-list\">"; string strURL = HttpContext.Current.Request.Url.AbsolutePath.ToString().Substring(0, HttpContext.Current.Request.Url.AbsolutePath.ToString().IndexOf("/", 1) + 1); string strURLAll = HttpContext.Current.Request.Url.AbsolutePath.ToString(); string LoginID = string.Empty; try { LoginID = Request.Cookies["WeChat_Yanwo"]["USERID"].ToString(); } catch { MessageBox("", "您还未登陆,无权查看该页!<br/>请先登陆!", "/Login.aspx"); return; } string strSQL = string.Empty; if (LoginID == "-24") { strSQL = "SELECT (SELECT count(ID) FROM S_MK WHERE S_MK.ID=A.id and (A.MKZX='" + strURL + "' OR A.MKZX='" + strURLAll + "' )) Selected,MKMC,MKZX,JDPX,CS,ICO ,A.id From S_MK A where SHOW=0 ORDER BY JDPX "; } else { strSQL = "SELECT (SELECT count(ID) FROM S_MK WHERE S_MK.ID=A.id and (A.MKZX='" + strURL + "' OR A.MKZX='" + strURLAll + "' )) Selected,MKMC,MKZX,JDPX,CS,ICO ,A.id"; strSQL += " from S_MK A,S_QXZ,S_QXZZB,S_YH_QXZ "; strSQL += " where A.ID=S_QXZZB.QXID and S_QXZ.ID=S_QXZZB.QXZID and S_QXZ.ID=S_YH_QXZ.QXZID and USERID=" + LoginID + " and JDPX IS NOT NULL AND JDPX<>'' AND SHOW=0 "; strSQL += " GROUP BY MKMC,MKZX,JDPX,CS,ICO,A.id ORDER BY JDPX "; } string strClass = "icon-dashboard"; string strZCD = string.Empty; string strXLAN = string.Empty; string strULJW = string.Empty; string strActive = string.Empty; int JDCS = 0; int JDCSUP = 0; int JDCSDown = 0; OP_Mode.Dtv1 = null; if (OP_Mode.SQLRUN(strSQL, "LeftMenu")) { for (int num = 0; num < OP_Mode.Dtv1.Count; num++) { JDCS = (int)OP_Mode.Dtv1[num]["CS"]; if ((int)OP_Mode.Dtv1[num]["Selected"] > 0) { strActive = " class=\"active\""; } else { strActive = string.Empty; } if (num > 1) { JDCSUP = (int)OP_Mode.Dtv1[num - 1]["CS"]; } else { JDCSUP = 0; } if (num + 1 < OP_Mode.Dtv1.Count) { JDCSDown = (int)OP_Mode.Dtv1[num + 1]["CS"]; } else { JDCSDown = 0; } /////////////////////////////////////////////// if (JDCSDown > JDCS) /// 有子菜单的显示向下图标 { strZCD = " <b class=\"arrow icon-angle-down\"></b>"; } else { strZCD = ""; } /// 设置默认ICO图标 if (OP_Mode.Dtv1[num]["ICO"].ToString().Length > 0) { strClass = OP_Mode.Dtv1[num]["ICO"].ToString().Trim(); } else { strClass = "icon-dashboard"; } /// 正常格式输出; class=\"active\" strDiv += "<li " + strActive + ">"; strDiv += " <a class=\"dropdown-toggle\" href=\"" + OP_Mode.Dtv1[num]["MKZX"].ToString().Trim() + "\">"; strDiv += " <i class=\"" + strClass + "\"></i>"; strDiv += " <span class=\"menu-text\">" + OP_Mode.Dtv1[num]["MKMC"].ToString().Trim() + "</span>"; strDiv += strZCD; strDiv += " </a>"; if (JDCSDown > JDCS) { strDiv += " <ul class=\"submenu\">"; } else { if (num != OP_Mode.Dtv1.Count) { strDiv += "</li>"; } } if (num == OP_Mode.Dtv1.Count - 1) { for (int ii = 1; ii < JDCS; ii++) { strDiv += "</ul></li>"; } strDiv += "<li class=\"active\"><a class=\"dropdown-toggle\" href=\"#\"><img src=\"/images/luLogo.png\" width=\"25px\" /><span class=\"menu-text\"> 版本信息</span> <b class=\"arrow icon-angle-down\"></b></a>"; strDiv += " <ul class=\"submenu\">"; strDiv += " <li><a class=\"dropdown-toggle\" target=\"_blank\" href=\"http://www.x76.com.cn\"><i class=\"icon-coffee\"></i><span class=\"menu-text\">© 合肥星期陆</span> </a></li>"; strDiv += " <li><a class=\"dropdown-toggle\" href=\"#\"><i class=\"icon-male\"></i><span class=\"menu-text\">陆晓钧</span> </a></li>"; strDiv += " <li><a class=\"dropdown-toggle\" href=\"tel://18019961118\"><i class=\"icon-phone\"></i><span class=\"menu-text\">18019961118</span> </a></li>"; strDiv += " <li><a class=\"dropdown-toggle\" href=\"LoginOut.aspx\"><i class=\"icon-phone\"></i><span class=\"menu-text\">退出系统</span> </a></li>"; strDiv += " </ul>"; strDiv += "</li>"; strDiv += "</ul>"; } else { if (JDCS > JDCSDown) { for (int ii = JDCSDown; ii < JDCS; ii++) { strDiv += "</ul></li>"; } } } strActive = string.Empty; } } strDiv += "<div class=\"sidebar-collapse\" id=\"sidebar-collapse\">"; strDiv += " <i class=\"icon-double-angle-left\" data-icon1=\"icon-double-angle-left\" data-icon2=\"icon-double-angle-right\"></i>"; strDiv += "</div>"; strDiv += "<script type=\"text/javascript\">"; strDiv += " try { ace.settings.check('sidebar', 'collapsed') } catch (e) { }"; strDiv += "</script>"; this.sidebar.InnerHtml = strDiv; }
/// <summary> /// 微信登录 /// </summary> private void WeChatLoad() { // https://open.weixin.qq.com/connect/oauth2/authorize?appid=wx18dba54a978196fb&redirect_uri=http://ptweb.x76.com.cn/Danace/&response_type=code&scope=snsapi_userinfo&state=STATE#wechat_redirect string accessToken = string.Empty; string DeBugMsg = string.Empty; string AppId = "wx18dba54a978196fb";//与微信公众账号后台的AppId设置保持一致,区分大小写。 string AppSecret = "9b624176c34f4d0c00d045727731b096"; var code = string.Empty; var opentid = string.Empty; try { code = Request.QueryString["code"]; DeBugMsg += "code:" + code; } catch { } if (string.IsNullOrEmpty(code)) { } else { string strWeixin_OpenID = string.Empty; string STRUSERID = string.Empty; if (strWeixin_OpenID == string.Empty || STRUSERID == string.Empty) { DeBugMsg += "<br> 没有所需的OPENID!"; // this.Label1.Text = "没有所需的OPENID"; var client = new System.Net.WebClient(); client.Encoding = System.Text.Encoding.UTF8; var url = string.Format("https://api.weixin.qq.com/sns/oauth2/access_token?appid={0}&secret={1}&code={2}&grant_type=authorization_code", AppId, AppSecret, code); var data = client.DownloadString(url); var serializer = new JavaScriptSerializer(); var obj = serializer.Deserialize <Dictionary <string, string> >(data); if (!obj.TryGetValue("access_token", out accessToken)) { DeBugMsg += "<br> Token获取错误!"; } else { opentid = obj["openid"]; //MessageBox("", "opentid:" + opentid); } // string tempToken = GetaccessWebToken(code); url = string.Format("https://api.weixin.qq.com/sns/userinfo?access_token={0}&openid={1}&lang=zh_CN", accessToken, opentid); data = client.DownloadString(url); var userInfo = serializer.Deserialize <Dictionary <string, object> >(data); DeBugMsg += "userInfo:" + data.ToString(); int vsex = 2; var vcity = "中国"; if (userInfo["sex"].ToString() == "1") { vsex = 0; } vcity = userInfo["country"].ToString() + userInfo["province"].ToString() + userInfo["city"].ToString(); DeBugMsg += "城市:" + vcity; if (opentid.Length == 0) { opentid = "test111"; } string UserName = "******"; string HeadUserUrl = ""; UserName = userInfo["nickname"].ToString(); DeBugMsg += "昵称:" + UserName; HeadUserUrl = userInfo["headimgurl"].ToString(); DeBugMsg += "头像:" + HeadUserUrl; string strSQL; strSQL = " Select * from Dance_User where WeChatOpenID='" + opentid.ToString() + "'"; if (OP_Mode.SQLRUN(strSQL)) { if (OP_Mode.Dtv.Count > 0) { /// 如果数据库有ID,则直接登录。 Response.Cookies[Constant.COOKIENAMEUSER][Constant.COOKIENAMEUSER_USERID] = OP_Mode.Dtv[0]["ID"].ToString().Trim(); Response.Cookies["Dance"]["USERID"] = OP_Mode.Dtv[0]["ID"].ToString().Trim(); Response.Cookies["Dance"]["COPENID"] = opentid.ToString(); Response.Cookies["Dance"]["CNAME"] = HttpUtility.UrlEncode(UserName); Response.Cookies["Dance"]["LTIME"] = OP_Mode.Dtv[0]["LTIME"].ToString().Trim(); Response.Cookies["Dance"]["HEADURL"] = HeadUserUrl; Response.Cookies["Dance"]["LOGIN"] = "******"; Response.Cookies[Constant.COOKIENAMEUSER][Constant.COOKIENAMEUSER_CNAME] = UserName; Response.Cookies[Constant.COOKIENAMEUSER][Constant.COOKIENAMEUSER_CTX] = HeadUserUrl; ///设置COOKIE最长时间 //Response.Cookies["Dance"].Expires = DateTime.MaxValue; /// 更新登录时间 OP_Mode.SQLRUN("Update Dance_User set Ltime=getdate(),HeadImage='" + HeadUserUrl + "',Nick=" + UserName + " where WeChatOpenID='" + opentid.ToString() + "'"); return; } else { try { strSQL = " INSERT INTO Dance_User (WeChatOpenID,Nick,HeadImage) VALUES ('" + opentid + "','" + UserName + "','" + HeadUserUrl + "')"; strSQL += " Select * from Dance_User where WeChatOpenID='" + opentid + "'"; DeBugMsg += "+" + strSQL + "+"; if (OP_Mode.SQLRUN(strSQL)) { if (OP_Mode.Dtv.Count > 0) { Response.Cookies[Constant.COOKIENAMEUSER][Constant.COOKIENAMEUSER_USERID] = OP_Mode.Dtv[0]["ID"].ToString().Trim(); Response.Cookies["Dance"]["USERID"] = OP_Mode.Dtv[0]["ID"].ToString().Trim(); Response.Cookies["Dance"]["COPENID"] = OP_Mode.Dtv[0]["WeChatOpenID"].ToString().Trim(); Response.Cookies["Dance"]["CNAME"] = HttpUtility.UrlEncode(OP_Mode.Dtv[0]["Nick"].ToString()); //HttpUtility.UrlDecode(Request.Cookies["SK_WZGY"]["CNAME"].ToString().Trim(), Encoding.GetEncoding("UTF-8")) Response.Cookies["Dance"]["LTIME"] = OP_Mode.Dtv[0]["LTIME"].ToString().Trim(); Response.Cookies["Dance"]["HEADURL"] = OP_Mode.Dtv[0]["HeadImage"].ToString().Trim(); Response.Cookies["Dance"][Constant.COOKIENAMEUSER_CNAME] = OP_Mode.Dtv[0]["Nick"].ToString().Trim(); Response.Cookies[Constant.COOKIENAMEUSER][Constant.COOKIENAMEUSER_CTX] = OP_Mode.Dtv[0]["HeadImage"].ToString().Trim(); Response.Cookies["Dance"]["LOGIN"] = "******"; Response.Cookies[Constant.COOKIENAMEOPENDOOR][Constant.COOKIENAMEOPENDOOR_LGOIN] = "true"; ///设置COOKIE最长时间 不设置时间,窗口关闭则丢失 // Response.Cookies["WeChat_Yanwo"].Expires = DateTime.MaxValue; string MSG = string.Empty;// string.Format("<img class=\"img-rounded\" src=\"{1}\" width=\"60PX\" />欢迎 {0} 注册成功。<br/>祝您生活愉快。", OP_Mode.Dtv[0]["CNAME"].ToString(), OP_Mode.Dtv[0]["HEADURL"].ToString()); MSG = "<img class=\"img-rounded\" src=\"" + OP_Mode.Dtv[0]["HeadImage"].ToString() + "\" width=\"60PX\" />欢迎 " + OP_Mode.Dtv[0]["Nick"].ToString() + " 注册成功。<br/>祝您生活愉快。"; MessageBox("", MSG); return; } } } catch (Exception ex) { DeBugMsg += "<br>" + ex.ToString(); MessageBox("", "4:" + DeBugMsg); } } } else { DeBugMsg += OP_Mode.strErrMsg; MessageBox("", "5:" + DeBugMsg); } } } }