/// <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);
}
}
}
}
