📄 usermisc.cs
字号:
/// <param name="uc1"></param>
/// <returns></returns>
private SqlParameter[] InsertManageMenuParameters2(NetCMS.Model.UserInfo7 uc1)
{
#region
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@am_Name", SqlDbType.NVarChar, 20);
param[0].Value = uc1.am_Name;
param[1] = new SqlParameter("@am_orderID", SqlDbType.Int, 4);
param[1].Value = uc1.am_orderID;
param[2] = new SqlParameter("@am_ID", SqlDbType.Int, 4);
param[2].Value = uc1.am_ID;
param[3] = new SqlParameter("@popCode", SqlDbType.NVarChar, 50);
param[3].Value = uc1.popCode;
return param;
#endregion
}
/// <summary>
/// 删除快揭菜单
/// </summary>
/// <param name="Qid"></param>
public void QShortcutdel(int Qid, int _num)
{
string str_sql = "delete From " + Pre + "API_Qmenu where id=" + Qid + " and UserNum='" + NetCMS.Global.Current.UserNum + "' and ismanage=" + _num + " and SiteID='" + NetCMS.Global.Current.SiteID + "'";
DbHelper.ExecuteNonQuery(CommandType.Text, str_sql, null);
}
/// <summary>
/// 获取快捷菜单的列表(管理员)
/// </summary>
/// <returns></returns>
public IDataReader QShortcutList(int _num)
{
string Sql = "Select id,QMID,qName,FilePath,usernum,siteid,orderid From " + Pre + "API_Qmenu where (UserNum='" + NetCMS.Global.Current.UserNum + "' or UserNum='0') and ismanage=" + _num + " and SiteID='" + NetCMS.Global.Current.SiteID + "' order by OrderID desc,id desc";
return DbHelper.ExecuteReader(CommandType.Text, Sql, null);
}
/// <summary>
/// 插入快捷菜单新记录
/// </summary>
/// <param name="uc2"></param>
public void addUpdate_QMenu(NetCMS.Model.UserInfo8 uc2,bool flag)
{
#region
string Sql = null;
SqlParameter[] parm;
if (flag)
{
Sql = "insert into " + Pre + "API_Qmenu (";
Sql += "QmID,qName,FilePath,Ismanage,OrderID,usernum,SiteID";
Sql += ") values (";
Sql += "@QmID,@qName,@FilePath,@Ismanage,@OrderID,@usernum,'" + NetCMS.Global.Current.SiteID + "')";
parm = InsertQMenuParameters(uc2);
}
else
{
Sql = "Update " + Pre + "API_Qmenu set qName=@qName,FilePath=@FilePath,OrderID=@OrderID where ID=" + uc2.Id + " and UserNum='" + NetCMS.Global.Current.UserNum + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
parm = new SqlParameter[3];
parm[0] = new SqlParameter("@qName", SqlDbType.NVarChar, 50);
parm[0].Value = uc2.qName;
parm[1] = new SqlParameter("@FilePath", SqlDbType.NVarChar, 200);
parm[1].Value = uc2.FilePath;
parm[2] = new SqlParameter("@OrderID", SqlDbType.Int, 4);
parm[2].Value = uc2.OrderID;
}
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
#endregion
}
/// <summary>
/// 获取UserInfo8构造
/// </summary>
/// <param name="uc1"></param>
/// <returns></returns>
private SqlParameter[] InsertQMenuParameters(NetCMS.Model.UserInfo8 uc1)
{
#region
SqlParameter[] param = new SqlParameter[8];
param[0] = new SqlParameter("@QmID", SqlDbType.NVarChar, 12);
param[0].Value = uc1.QmID;
param[1] = new SqlParameter("@qName", SqlDbType.NVarChar, 50);
param[1].Value = uc1.qName;
param[2] = new SqlParameter("@FilePath", SqlDbType.NVarChar, 200);
param[2].Value = uc1.FilePath;
param[3] = new SqlParameter("@Ismanage", SqlDbType.TinyInt, 1);
param[3].Value = uc1.Ismanage;
param[4] = new SqlParameter("@OrderID", SqlDbType.Int, 4);
param[4].Value = uc1.OrderID;
param[5] = new SqlParameter("@usernum", SqlDbType.NVarChar, 15);
param[5].Value = uc1.usernum;
param[6] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
param[6].Value = uc1.SiteID;
param[7] = new SqlParameter("@Id", SqlDbType.Int, 4);
param[7].Value = uc1.Id;
return param;
#endregion
}
/// <summary>
/// 获取UserInfo8构造
/// </summary>
/// <param name="uc1"></param>
/// <returns></returns>
private SqlParameter[] InsertQMenuParameters1(NetCMS.Model.UserInfo8 uc1)
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@qName", SqlDbType.NVarChar, 50);
param[0].Value = uc1.qName;
param[1] = new SqlParameter("@FilePath", SqlDbType.NVarChar, 200);
param[1].Value = uc1.FilePath;
param[2] = new SqlParameter("@OrderID", SqlDbType.Int, 4);
param[2].Value = uc1.OrderID;
param[3] = new SqlParameter("@Id", SqlDbType.Int, 4);
param[3].Value = uc1.Id;
return param;
}
#endregion 菜单部分
#region 会员列表部分
public DataTable sel_sysInfos(int Uid,int flag)
{
#region
string Sql = null;
SqlParameter param = new SqlParameter("@nID", Uid); ;
if (flag == 0)
{
Sql = "select UserGroupNumber,UserNum,NickName,RealName,birthday,Userinfo,UserFace,userFacesize,email,sex,marriage,isopen,id,CertType,CertNumber,ipoint,gpoint,cpoint,epoint,apoint,RegTime,onlineTime,LoginNumber,LoginLimtNumber,lastIP,LastLoginTime,SiteID,islock,isadmin,isIDcard,UserName,IDcardFiles from " + Pre + "sys_User where id=@nID" + NetCMS.Common.Public.getSessionStr() + "";
}
else if (flag == 1)
{
Sql = "select CharLenContent,CharHTML,CharTF from " + Pre + "user_group a," + Pre + "sys_user b where b.id=@nID and b.UserGroupNumber=a.GroupNumber";
}
else if (flag == 2)
{
Sql = "select PassQuestion,PassKey from " + Pre + "sys_User where ID=@nID";
}
else if (flag == 3)
{
Sql = "select id,GroupNumber,GroupName,iPoint,Gpoint,Rtime,LenCommContent,CommCheckTF,PostCommTime,upfileType,upfileNum,upfileSize,DayUpfilenum,ContrNum,DicussTF,PostTitle,ReadUser,MessageNum,MessageGroupNum,IsCert,CharTF,CharHTML,CharLenContent,RegMinute,PostTitleHTML,DelSelfTitle,DelOTitle,EditSelfTitle,EditOtitle,ReadTitle,MoveSelfTitle,MoveOTitle,TopTitle,GoodTitle,LockUser,UserFlag,CheckTtile,IPTF,EncUser,OCTF,StyleTF,UpfaceSize,GIChange,GTChageRate,LoginPoint,RegPoint,GroupTF,GroupSize,GroupPerNum,GroupCreatNum,CreatTime,siteID,Discount from " + Pre + "user_Group where id=@nID" + NetCMS.Common.Public.getSessionStr() + "";
}
else if (flag == 4)
{
Sql = "select id,title,content,getpoint,GroupNumber from " + Pre + "user_news where id=@nID" + NetCMS.Common.Public.getSessionStr() + "";
}
else if (flag == 5)
{
Sql = "Select am_id,api_IdentID,am_ClassID,Am_position,am_Name,Am_Ename,am_FilePath,am_target,am_ParentID,am_type,am_orderID,isSys,popCode From " + Pre + "API_Navi where am_id=@nID and SiteID='" + NetCMS.Global.Current.SiteID + "' order by am_orderID desc,am_id desc";
}
else if (flag == 6)
{
Sql = "Select QmID,qName,FilePath,Ismanage,OrderID,usernum,siteID From " + Pre + "API_Qmenu Where ID=@nID and UserNum = '" + NetCMS.Global.Current.UserNum + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
}
else if (flag == 7)
{
Sql = "Select QmID From " + Pre + "API_Qmenu Where UserNum='" + NetCMS.Global.Current.UserNum + "' and ismanage=@nID and SiteID='" + NetCMS.Global.Current.SiteID + "'";
}
else if (flag == 8)
{
Sql = "select id,CardNumber,CardPassWord,Money,Point,TimeOutDate,isLock,isUse,isBuy From " + Pre + "user_card where id=@nID and SiteID = '" + NetCMS.Global.Current.SiteID + "'";
}
else if (flag == 9)
{
Sql = "select * from " + Pre + "user_URL where ID=@nID";
}
else if (flag == 10)
{
Sql = "select * from " + Pre + "user_URL where ClassID=@nID order by id desc";
}
else if (flag == 11)
{
Sql = "select * from " + Pre + "user_URLClass where ID=@nID";
}
return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
#endregion
}
public void UpdateUserSafe(int Uid, string PassQuestion, string PassKey, string password)
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@PassQuestion", SqlDbType.NVarChar, 20);
param[0].Value = PassQuestion;
param[1] = new SqlParameter("@PassKey", SqlDbType.NVarChar, 20);
param[1].Value = NetCMS.Common.Input.MD5(PassKey);
param[2] = new SqlParameter("@password", SqlDbType.NVarChar, 32);
param[2].Value = NetCMS.Common.Input.MD5(password);
string str_sql = "Update " + Pre + "sys_User set PassQuestion=@PassQuestion,PassKey=@PassKey,UserPassword=@password where id=" + Uid + NetCMS.Common.Public.getSessionStr() + "";
DbHelper.ExecuteNonQuery(CommandType.Text, str_sql, param);
}
public void UpdateUserInfoIDCard(int Uid, string _temp)
{
string str_sql = "update " + Pre + "sys_user " + _temp + " where id=" + Uid + NetCMS.Common.Public.getSessionStr() + "";
DbHelper.ExecuteNonQuery(CommandType.Text, str_sql, null);
}
/// <summary>
/// 得到是否是管理员
/// </summary>
/// <returns>1是，0否</returns>
public int getisAdmin()
{
int intflg = 0;
string Sql = "select isAdmin from " + Pre + "sys_User where UserNum='" + NetCMS.Global.Current.UserNum + "'";
DataTable dt = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
if (dt != null)
{
if (dt.Rows.Count > 0) { intflg = int.Parse(dt.Rows[0]["isAdmin"].ToString()); }
dt.Clear(); dt.Dispose();
}
return intflg;
}
/// <summary>
/// 更新基本资料
/// </summary>
/// <param name="uc"></param>
public void UpdateUserInfoBase(NetCMS.Model.UserInfo uc)
{
string str_sql = "Update " + Pre + "sys_User set NickName=@NickName,RealName=@RealName,sex=@sex,birthday=@birthday,Userinfo=@Userinfo,UserFace=@UserFace,userFacesize=@userFacesize,marriage=@marriage,isopen=@isopen,UserGroupNumber=@UserGroupNumber,email=@email where id=" + uc.Id + " " + NetCMS.Common.Public.getSessionStr() + "";
SqlParameter[] parm = GetUserInfoParameters(uc);
DbHelper.ExecuteNonQuery(CommandType.Text, str_sql, parm);
}
/// <summary>
/// 获取UserInfo构造
/// </summary>
/// <param name="uc"></param>
/// <returns></returns>
private SqlParameter[] GetUserInfoParameters(NetCMS.Model.UserInfo uc)
{
SqlParameter[] param = new SqlParameter[11];
param[0] = new SqlParameter("@NickName", SqlDbType.NVarChar, 12);
param[0].Value = uc.NickName;
param[1] = new SqlParameter("@RealName", SqlDbType.NVarChar, 20);
param[1].Value = uc.RealName;
param[2] = new SqlParameter("@sex", SqlDbType.TinyInt, 1);
param[2].Value = uc.sex;
param[3] = new SqlParameter("@birthday", SqlDbType.DateTime, 8);
param[3].Value = uc.birthday;
param[4] = new SqlParameter("@Userinfo", SqlDbType.NText);
param[4].Value = uc.Userinfo;
param[5] = new SqlParameter("@UserFace", SqlDbType.NVarChar, 220);
param[5].Value = uc.UserFace;
param[6] = new SqlParameter("@userFacesize", SqlDbType.NVarChar, 8);
param[6].Value = uc.userFacesize;
param[7] = new SqlParameter("@marriage", SqlDbType.TinyInt, 1);
param[7].Value = uc.marriage;
param[8] = new SqlParameter("@isopen", SqlDbType.TinyInt, 1);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -