Code C#:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Web.Security;
using System.Xml;
namespace HyeyCRM.BLL.Comm
{
/// <summary>
/// 終端采購會員
/// </summary>
public class FinalUser
{
public string TrueName
{
get { return getUserData("Truename"); }
}
public string UserName
{
get
{
return getUserData("UserName");
}
}
public string UserID
{
get
{
return getUserData("UserID");
}
}
/// <summary>
/// 會員組編號
/// </summary>
public string GroupID
{
get
{
return getUserData("GroupID");
}
}
/// <summary>
/// 用戶權限字符串
/// </summary>
public string RightList
{
get
{
return getUserData("RightList");
}
}
string getUserData(string dataTitle)
{
string dataValue = null;
if (System.Web.HttpContext.Current.User != null)
{
if (System.Web.HttpContext.Current.User.Identity.IsAuthenticated)
{
if (System.Web.HttpContext.Current.User.Identity is FormsIdentity)
{
FormsIdentity id = (FormsIdentity)System.Web.HttpContext.Current.User.Identity;
FormsAuthenticationTicket ticket = id.Ticket;
// 取存儲在票據中的用戶數據，
string userData = ticket.UserData;
string[] roles = userData.Split(';');
foreach (string s in roles)
{
if (s.StartsWith(dataTitle))
{
dataValue = s.Substring(dataTitle.Length + 1);
break;
}
}
}
}
}
return dataValue;
}
#region 靜態化實例對象
private static readonly FinalUser _user = null;
static FinalUser()
{
_user = new FinalUser();
}
public static FinalUser Instance()
{
return _user;
}
private FinalUser()
{
}
#endregion
}
public class UserManager
{
/// <summary>
/// 獲取當前終端采購會員的會員組和所屬的業務員ID
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public Dictionary<int, int> getYwUserAndGroupIDByUserID(string userid)
{
Dictionary<int, int> dicValue = new Dictionary<int, int>();
string strSql = "select sid,userGroup From CustomerRelationship where cid="+userid;
try
{
DataSet ds = CommonClass.GetList(strSql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
dicValue.Add(int.Parse(ds.Tables[0].Rows[0]["sid"].ToString()), int.Parse(ds.Tables[0].Rows[0]["userGroup"].ToString()));
}
}
catch
{
}
return dicValue;
}
/// <summary>
/// 獲取當前終端采購會員的庫存名狀態和銷售狀態的業務員ID
/// </summary>
/// <param name="YwUserid"></param>
/// <returns></returns>
public Dictionary<int, int> getYwCkAndYwSalesStateByUserID(string YwUserid)
{
Dictionary<int, int> dicValue = new Dictionary<int, int>();
string strSql = "select ywck,YwsalesState From MembersView where userid=" + YwUserid;
try
{
DataSet ds = CommonClass.GetList(strSql);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
dicValue.Add(int.Parse(ds.Tables[0].Rows[0]["ywck"].ToString()), int.Parse(ds.Tables[0].Rows[0]["YwsalesState"].ToString()));
}
}
catch
{
}
return dicValue;
}
/// <summary>
/// 根據用戶ID獲取所屬的業務員ID
/// </summary>
/// <param name="UserID">用戶ID</param>
/// <returns>返回業務員ID</returns>
public int getYwUserIDByUserID(string UserID)
{
int YwUserID = 0;
string strSql = "select sid From CustomerRelationship where cid=" + UserID;
try
{
string resultYwUserID = CommonClass.ExecScalar(strSql);
if (resultYwUserID != "")
{
YwUserID = int.Parse(resultYwUserID);
}
}
catch
{
}
return YwUserID;
}
/// <summary>
/// 獲取會員信息
/// </summary>
/// <returns></returns>
public DataSet GetUserAndContacter()
{
string strSql = "select * from MembersView where Userid=" + YwUser.Instance().UserID;
return CommonClass.GetList(ConnConfig.ConnString, strSql);
}
public int UpdateUserInfo(string updateSql)
{
updateSql = updateSql + " where contacterid=(select contacterid from hyey_power.dbo.pe_user where userid=" + YwUser.Instance().UserID + ")";
string myConnString = ConnConfig.ConnString;
int i = CommonClass.ExecNonQuery(updateSql);
return i;
}
//修改密碼
public int changePass(string newpass)
{
string md5Passworde = SysCode.md5(newpass, 16);
string strSql = "Update pe_user Set UserPassWord = '" + md5Passworde + "',OldPassWord='" + newpass + "' WHERE UserName = '" + YwUser.Instance().UserName + "'";
int i = CommonClass.ExecNonQuery(strSql);
return i;
}
//修改密碼
/// <summary>
/// 功能：修改密碼
/// Changes the pass by ID.
/// </summary>
/// <param name="newpass">新密碼</param>
/// <param name="id">用戶ID</param>
/// <returns></returns>
public int changePassByID(string newpass, int id)
{
string md5Passworde = SysCode.md5(newpass, 16);
string strSql = "Update pe_user Set UserPassWord = '" + md5Passworde + "',OldPassWord='" + newpass + "' WHERE Userid = '" + id + "'";
int i = CommonClass.ExecNonQuery(strSql);
return i;
}
public int Delete(string IDstr)
{
string sql = "delete pe_user where Userid in (" + IDstr + ")";
return CommonClass.ExecNonQuery(sql);
}
#region 靜態化實例對象
private static readonly UserManager _usermanager = null;
static UserManager()
{
_usermanager = new UserManager();
}
public static UserManager Instance()
{
return _usermanager;
}
private UserManager()
{
}
#endregion
}
}
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
