📄 usermisc.cs
字号:
param[8].Value = uc.isopen;
param[9] = new SqlParameter("@UserGroupNumber", SqlDbType.NVarChar, 12);
param[9].Value = uc.UserGroupNumber;
param[10] = new SqlParameter("@email", SqlDbType.NVarChar, 220);
param[10].Value = uc.email;
return param;
}
/// <summary>
/// 更新基本资料第2表
/// </summary>
/// <param name="uc1"></param>
public void addUpdate_userFields(NetCMS.Model.UserInfo1 uc1, bool flag)
{
string str_sql = null;
if (flag)
{
str_sql = "Update " + Pre + "sys_userfields set Nation=@Nation,nativeplace=@nativeplace,character=@character,UserFan=@UserFan,orgSch=@orgSch,job=@job,education=@education,Lastschool=@Lastschool where UserNum=@UserNum";
}
else// 如果基本资料第2表，则插入新记录
{
str_sql = "insert into " + Pre + "sys_userfields (";
str_sql += "UserNum,Nation,nativeplace,character,UserFan,orgSch,job,education,Lastschool";
str_sql += ") values (";
str_sql += "@UserNum,@Nation,@nativeplace,@character,@UserFan,@orgSch,@job,@education,@Lastschool)";
}
SqlParameter[] parm = GetUserInfoParameters1(uc1);
DbHelper.ExecuteNonQuery(CommandType.Text, str_sql, parm);
}
/// <summary>
/// 获取UserInfo1构造
/// </summary>
/// <param name="uc1"></param>
/// <returns></returns>
private SqlParameter[] GetUserInfoParameters1(NetCMS.Model.UserInfo1 uc1)
{
SqlParameter[] param = new SqlParameter[9];
param[0] = new SqlParameter("@Nation", SqlDbType.NVarChar, 12);
param[0].Value = uc1.Nation;
param[1] = new SqlParameter("@nativeplace", SqlDbType.NVarChar, 20);
param[1].Value = uc1.nativeplace;
param[2] = new SqlParameter("@character", SqlDbType.NText);
param[2].Value = uc1.character;
param[3] = new SqlParameter("@UserFan", SqlDbType.NText);
param[3].Value = uc1.UserFan;
param[4] = new SqlParameter("@orgSch", SqlDbType.NVarChar, 10);
param[4].Value = uc1.orgSch;
param[5] = new SqlParameter("@job", SqlDbType.NVarChar, 30);
param[5].Value = uc1.job;
param[6] = new SqlParameter("@education", SqlDbType.NVarChar, 20);
param[6].Value = uc1.education;
param[7] = new SqlParameter("@Lastschool", SqlDbType.NVarChar, 80);
param[7].Value = uc1.Lastschool;
param[8] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 15);
param[8].Value = uc1.UserNum;
return param;
}
/// <summary>
/// 更新基本资料第2表
/// </summary>
/// <param name="uc1"></param>
public void addUpdate_fields(NetCMS.Model.UserInfo2 uc1,bool flag)
{
#region
string str_sql = null;
if (flag)
{
str_sql = "Update " + Pre + "sys_userfields set province=@province,City=@City,Address=@Address,Postcode=@Postcode,FaTel=@FaTel,WorkTel=@WorkTel,Fax=@Fax,QQ=@QQ,MSN=@MSN where UserNum=@UserNum";
}
else
{
str_sql = "insert into " + Pre + "sys_userfields (";
str_sql += "UserNum,province,City,Address,Postcode,FaTel,WorkTel,Fax,QQ,MSN";
str_sql += ") values (";
str_sql += "@UserNum,@province,@City,@Address,@Postcode,@FaTel,@WorkTel,@Fax,@QQ,@MSN)";
}
SqlParameter[] parm = GetUserInfoContactParameters1(uc1);
DbHelper.ExecuteNonQuery(CommandType.Text, str_sql, parm);
#endregion
}
private SqlParameter[] GetUserInfoContactParameters1(NetCMS.Model.UserInfo2 uc1)
{
#region
SqlParameter[] param = new SqlParameter[10];
param[0] = new SqlParameter("@province", SqlDbType.NVarChar, 20);
param[0].Value = uc1.province;
param[1] = new SqlParameter("@City", SqlDbType.NVarChar, 20);
param[1].Value = uc1.City;
param[2] = new SqlParameter("@Address", SqlDbType.NVarChar, 50);
param[2].Value = uc1.Address;
param[3] = new SqlParameter("@Postcode", SqlDbType.NVarChar, 10);
param[3].Value = uc1.Postcode;
param[4] = new SqlParameter("@FaTel", SqlDbType.NVarChar, 30);
param[4].Value = uc1.FaTel;
param[5] = new SqlParameter("@WorkTel", SqlDbType.NVarChar, 30);
param[5].Value = uc1.WorkTel;
param[6] = new SqlParameter("@Fax", SqlDbType.NVarChar, 30);
param[6].Value = uc1.Fax;
param[7] = new SqlParameter("@QQ", SqlDbType.NVarChar, 30);
param[7].Value = uc1.QQ;
param[8] = new SqlParameter("@MSN", SqlDbType.NVarChar, 150);
param[8].Value = uc1.MSN;
param[9] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 15);
param[9].Value = uc1.UserNum;
return param;
#endregion
}
/// <summary>
/// 如果基本资料状态表
/// </summary>
/// <param name="uc2"></param>
public void UpdateUserInfoBaseStat(NetCMS.Model.UserInfo3 uc)
{
string str_sql = "Update " + Pre + "sys_user set UserGroupNumber=@UserGroupNumber,islock=@islock,isadmin=@isadmin,CertType=@CertType,CertNumber=@CertNumber,ipoint=@ipoint,gpoint=@gpoint,cpoint=@cpoint,epoint=@epoint,apoint=@apoint,onlineTime=@onlineTime,RegTime=@RegTime,LastLoginTime=@LastLoginTime,LoginNumber=@LoginNumber,LoginLimtNumber=@LoginLimtNumber,lastIP=@lastIP,SiteID=@SiteID where Id=" + uc.Id + "";
SqlParameter[] parm = GetUserInfoBaseStatParameters1(uc);
DbHelper.ExecuteNonQuery(CommandType.Text, str_sql, parm);
}
private SqlParameter[] GetUserInfoBaseStatParameters1(NetCMS.Model.UserInfo3 uc1)
{
#region
SqlParameter[] param = new SqlParameter[17];
param[0] = new SqlParameter("@UserGroupNumber", SqlDbType.NVarChar, 12);
param[0].Value = uc1.UserGroupNumber;
param[1] = new SqlParameter("@islock", SqlDbType.TinyInt, 1);
param[1].Value = uc1.islock;
param[2] = new SqlParameter("@isadmin", SqlDbType.TinyInt, 1);
param[2].Value = uc1.isadmin;
param[3] = new SqlParameter("@CertType", SqlDbType.NVarChar, 15);
param[3].Value = uc1.CertType;
param[4] = new SqlParameter("@CertNumber", SqlDbType.NVarChar, 20);
param[4].Value = uc1.CertNumber;
param[5] = new SqlParameter("@ipoint", SqlDbType.Int, 4);
param[5].Value = uc1.ipoint;
param[6] = new SqlParameter("@gpoint", SqlDbType.Int, 4);
param[6].Value = uc1.gpoint;
param[7] = new SqlParameter("@cpoint", SqlDbType.Int, 4);
param[7].Value = uc1.cpoint;
param[8] = new SqlParameter("@epoint", SqlDbType.Int, 4);
param[8].Value = uc1.epoint;
param[9] = new SqlParameter("@apoint", SqlDbType.Int, 4);
param[9].Value = uc1.apoint;
param[10] = new SqlParameter("@onlineTime", SqlDbType.Int, 4);
param[10].Value = uc1.onlineTime;
param[11] = new SqlParameter("@RegTime", SqlDbType.DateTime, 8);
param[11].Value = uc1.RegTime;
param[12] = new SqlParameter("@LastLoginTime", SqlDbType.DateTime, 8);
param[12].Value = uc1.LastLoginTime;
param[13] = new SqlParameter("@LoginNumber", SqlDbType.Int, 4);
param[13].Value = uc1.LoginNumber;
param[14] = new SqlParameter("@LoginLimtNumber", SqlDbType.Int, 4);
param[14].Value = uc1.LoginLimtNumber;
param[15] = new SqlParameter("@lastIP", SqlDbType.NVarChar, 16);
param[15].Value = uc1.lastIP;
param[16] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
param[16].Value = uc1.SiteID;
return param;
#endregion
}
/// <summary>
///更新手机号码
/// </summary>
/// <param name="uc2"></param>
public void updateMobile(string _MobileNumber, int BindTF)
{
SqlParameter param = new SqlParameter("@Mobile", _MobileNumber);
string Sql = "Update " + Pre + "sys_User set mobile=@Mobile,BindTF=" + BindTF + " where UserNum='" + NetCMS.Global.Current.UserNum + "'";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
}
#endregion 会员列表部分
#region 会员组部分
public void del_User(int Gid,int flag)
{
#region
string str_sql = null;
SqlParameter param = null;
if (flag == 0)
{
rootPublic pd = new rootPublic();
//更新相应的会员数据会员组
string SQL = "Update " + Pre + "sys_user set UserGroupNumber='0' where UserGroupNumber='" + pd.getGidGroupNumber(Gid) + "' " + NetCMS.Common.Public.getSessionStr() + "";
DbHelper.ExecuteNonQuery(CommandType.Text, SQL, null);
str_sql = "Delete From " + Pre + "user_Group where id=" + Gid + " " + NetCMS.Common.Public.getSessionStr() + "";
}
else if (flag == 1)
{
param = new SqlParameter("@Qid", Gid);
str_sql = "delete From " + Pre + "API_Navi where am_id=@Qid and UserNum='" + NetCMS.Global.Current.UserNum + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
}
else if (flag == 2)
{
str_sql = "delete from " + Pre + "user_URL where ID =" + Gid + " and UserNum='" + NetCMS.Global.Current.UserNum + "'";
}
else if (flag == 3)
{
string Sql = "delete from " + Pre + "user_URLClass where ID =" + Gid + " and UserNum='" + NetCMS.Global.Current.UserNum + "'";
DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
str_sql = "delete from " + Pre + "user_URL where ClassID =" + Gid + " and UserNum='" + NetCMS.Global.Current.UserNum + "'";
}
DbHelper.ExecuteNonQuery(CommandType.Text, str_sql, param);
#endregion
}
public DataTable sel_GroupListStr(int flag)
{
#region
string Sql = null;
if (flag == 0)
{
Sql = "select id,GroupNumber,Discount,GroupName,iPoint,Gpoint,CreatTime,Rtime from " + Pre + "user_Group where 1=1 " + NetCMS.Common.Public.getSessionStr() + " order by id desc";
}
else if (flag == 1)
{
Sql = "select onpayType,O_userName,O_key,O_sendurl,O_returnurl,O_md5,O_other1,O_other2,O_other3 from " + Pre + "sys_PramUser where SiteID='" + NetCMS.Global.Current.SiteID + "'";
}
else if (flag == 2)
{
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 From " + Pre + "API_Navi where Am_position='00000' and SiteID='" + NetCMS.Global.Current.SiteID + "' order by am_orderID desc,am_id asc";
}
else if (flag == 3)
{
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_position='00000' and SiteID='" + NetCMS.Global.Current.SiteID + "' order by am_orderID desc,am_id desc";
}
else if (flag == 4)
{
Sql = "select isIDcard,IDcardFiles,ID,BindTF from " + Pre + "sys_User where UserNum='" + NetCMS.Global.Current.UserNum + "'";
}
else if (flag == 5)
{
Sql = "select DisTinct Money from " + Pre + "user_Card where isBuy=0 and isUse=0 and isLock=0 and SiteID='" + NetCMS.Global.Current.SiteID + "' and TimeOutDate>'" + DateTime.Now + "' and Money>0 order by Money asc";
}
else if (flag == 6)
{
Sql = "select LTitle,Lpicurl,iPoint from " + Pre + "sys_UserLevel order by id asc";
}
DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
return rdr;
#endregion
}
/// <summary>
/// 插入新会员组
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -