public string AddUserInfo(Model.UserInfo userInfo) { if (userInfo.UserLoginName == "" || userInfo.UserLoginName == null) { return(ViewBag.Errmsg = "no:请输入用户登录名!"); } if (userInfo.Age > 120 || userInfo.Age < 0 || userInfo.Age == null) { return(ViewBag.Errmsg = "no:请输入正确的年龄!"); } if (userInfo.UserMail == "" || userInfo.UserMail == null) { return(ViewBag.Errmsg = "no:请输入邮箱!"); } if (userInfo.UserName == "" || userInfo.UserName == null) { return(ViewBag.Errmsg = "no:请输入用户真实名!"); } if (userInfo.UserPsd == "" || userInfo.UserPsd == null) { return(ViewBag.Errmsg = "no:请输入密码!"); } if (userInfoBll.Add(userInfo)) { return(ViewBag.Errmsg = "ok:添加成功"); } else { return(ViewBag.Errmsg = "ok:添加失败"); } }
public int CheckAuthorisation(string username) { Context _Context = new Context(); Model.UserInfo _UserInfo = _Context.UsersInfo.Where(e => e.Username == username).SingleOrDefault(); return(_UserInfo.Authorisation); }
public int Add(Model.UserInfo user) { using (IDbConnection cn = new MySqlConnection(cns)) { string sql = "insert into userinfo values(@userName,@passWord,@qq,@email,@type,@userImg);"; return(cn.Execute(sql, user)); } }
public int Update(Model.UserInfo user) { using (IDbConnection cn = new MySqlConnection(cns)) { string sql = "update userinfo set password=@passWord,qq=@qq,email=@email,type=@type,userimg=@userImg where username=@userName"; return(cn.Execute(sql, user)); } }
/// <summary> /// 更新一条数据 /// </summary> public static int UpdateShopInfo(Model.UserInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UserInfo set "); strSql.Append("username=@username,"); strSql.Append("relName=@relName,"); strSql.Append("comName=@comName,"); strSql.Append("imgUrl=@imgUrl,"); strSql.Append("remark=@remark,"); strSql.Append("mobileCode=@mobileCode,"); strSql.Append("activeCode=@activeCode,"); strSql.Append("mainbrand=@mainbrand,"); strSql.Append("email=@email,shopType=" + model.shopType + ",weibo = '" + model.weibo + "'"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@username", SqlDbType.VarChar, 150), new SqlParameter("@relName", SqlDbType.VarChar, 150), new SqlParameter("@comName", SqlDbType.VarChar, 150), new SqlParameter("@imgUrl", SqlDbType.VarChar, 150), new SqlParameter("@remark", SqlDbType.VarChar, 1500), new SqlParameter("@mobileCode", SqlDbType.VarChar, 550), new SqlParameter("@activeCode", SqlDbType.VarChar, 550), new SqlParameter("@mainbrand", SqlDbType.VarChar, 1500), new SqlParameter("@email", SqlDbType.VarChar, 150), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.username; parameters[1].Value = model.relName; parameters[2].Value = model.comName; parameters[3].Value = model.imgUrl; parameters[4].Value = model.remark; parameters[5].Value = model.mobileCode; parameters[6].Value = model.activeCode; parameters[7].Value = model.mainbrand; parameters[8].Value = model.email; parameters[9].Value = model.id; return(DBHelperSQL.ExecuteSql(strSql.ToString(), parameters)); }
/// <summary> /// 头像信息更新 /// </summary> /// <param name="model"></param> /// <param name="num"></param> /// <returns></returns> public static int UpdateImg(Model.UserInfo model, int num) { if (num == 1) { string sql = "update UserInfo set shopingTime = '" + model.shopingtime + "' where id = " + model.id; return(DBHelperSQL.ExecuteSql(sql)); } else if (num == 2) { string sql = "update UserInfo set mainbrand = '" + model.mainbrand + "' where id = " + model.id; return(DBHelperSQL.ExecuteSql(sql)); } else if (num == 3) { string sql = "update UserInfo set mobileCode = '" + model.mobileCode + "' where id = " + model.id; return(DBHelperSQL.ExecuteSql(sql)); } else if (num == 4) { string sql = "update UserInfo set activeCode = '" + model.activeCode + "' where id = " + model.id; return(DBHelperSQL.ExecuteSql(sql)); } else if (num == 5) { string sql = "update UserInfo set imgUrl = '" + model.imgUrl + "' where id = " + model.id; return(DBHelperSQL.ExecuteSql(sql)); } else if (num == 6) { string sql = "update UserInfo set remark = '" + model.remark + "' where id = " + model.id; return(DBHelperSQL.ExecuteSql(sql)); } else if (num == 10) { string sql = "update UserInfo set zipCode = '" + model.zipCode + "' where id = " + model.id; return(DBHelperSQL.ExecuteSql(sql)); } else if (num == 11) { string sql = "update UserInfo set qq = '" + model.qq + "' where id = " + model.id; return(DBHelperSQL.ExecuteSql(sql)); } else if (num == 12) { string sql = "update UserInfo set weixin = '" + model.weixin + "' where id = " + model.id; return(DBHelperSQL.ExecuteSql(sql)); } else if (num == 13) { string sql = "update UserInfo set weibo = '" + model.weibo + "' where id = " + model.id; return(DBHelperSQL.ExecuteSql(sql)); } return(0); }
private void Repeater1bind() { if (userid > 0) { Model.UserInfo info = BLL.UsersBLL.GetModel(userid);// UsersController.GetUserByUserID(userid); lbUserName.Text = info.UserName; //List<Model.Roles> list = BLL.Roles.GetList(-1, "RoleID in (select Roleid from UserRoles where userid=" + userid + ")", ""); //UsersController.GetListUserRoleByUserId(userid); DataTable dt = BLL.UserRolesBLL.GetUserRolesANDRoles("O.userid=" + userid); Repeater1.DataSource = dt; Repeater1.DataBind(); } }
/// <summary> /// 平台类登陆 /// </summary> /// <param name="openId"></param> /// <param name="accessToken"></param> /// <param name="infoType"></param> /// <returns></returns> public static UserInfo GetModel(string loginname, string password) { string sql = "select * from UserInfo where mobile = '" + loginname + "' and md5Pass = '******'"; Model.UserInfo model = new Model.UserInfo(); DataSet ds = DBHelperSQL.Query(sql); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } return(null); }
public static string GetMenuJSON(int UserID) { string UserType = ""; Model.UserInfo userinfo = BLL.UsersBLL.GetModel(UserID); if (userinfo == null || userinfo.UserID != UserID) { return(""); } UserType = userinfo.UserType; List <TabsInfo> list = BLL.TabsBLL.GetList(-1, "ParentId=0 and DisPlay='True'", ""); string result = "["; if (list != null && list.Count > 0) { foreach (TabsInfo info in list) { if (PermissionBLL.GetPermission(info.TabKey, UserID, "VIEW")) { string TabUrl = "javascript:void(0);"; if (info.TabUrl.Length > 0) { //if (i == 1) // TabUrl = "Main.aspx?menuid=" + info.TabID; //else TabUrl = info.TabUrl; } result += "{\"url\":\"" + TabUrl + "\",\"id\":\"" + info.TabID + "\",\"name\":\"" + info.TabName + "\",\"submenu\":[]},"; } } } if (UserType == Common.enumUserType.host.ToString()) { result += "{\"url\":\"javascript:void(0);\",\"id\":\"admin\",\"name\":\"admin\",\"submenu\":[]},"; result += "{\"url\":\"javascript:void(0);\",\"id\":\"host\",\"name\":\"Host\",\"submenu\":[]},"; } if (UserType == Common.enumUserType.admin.ToString()) { result += "{\"url\":\"javascript:void(0);\",\"id\":\"admin\",\"name\":\"admin\",\"submenu\":[]},"; } if (result.EndsWith(",")) { result = result.Remove(result.Length - 1); } result += "]"; return(result); }
/// <summary> /// qq登陆授权 /// </summary> /// <param name="openId"></param> /// <param name="accessToken"></param> /// <param name="infoType"></param> /// <returns></returns> public static UserInfo GetModel(string openId, string accessToken, int infoType) { string sql = "select * from UserInfo where bodyCode = '" + openId + "' and comName = '" + accessToken + "' and infoType = " + infoType; Model.UserInfo model = new Model.UserInfo(); DataSet ds = DBHelperSQL.Query(sql); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public string ChangeUserInformation(int userID, string firstName, string familyName, string username, string phoneNumber, string plate) { Context _Context = new Context(); Model.UserInfo _UserInfoObj = _Context.UsersInfo.Where(e => e.UserInfoID == userID).SingleOrDefault(); _UserInfoObj = new Model.UserInfo() { FirstName = firstName, FamilyName = familyName, Username = username, PhoneNumber = phoneNumber, Plate = plate }; _Context.Entry(_UserInfoObj).State = System.Data.Entity.EntityState.Modified; _Context.SaveChanges(); return("Changed Successful!"); }
public bool AddNewUser(string firstName, string familyName, string username, string password, string phoneNumber, string plate, int authorisation) { Context _Context = new Context(); Model.UserInfo _UserInfoObj = new Model.UserInfo() { FirstName = firstName, FamilyName = familyName, Username = username, Password = password, PhoneNumber = phoneNumber, Plate = plate, Authorisation = authorisation }; _Context.UsersInfo.Add(_UserInfoObj); _Context.SaveChanges(); return(true); }
public UserInfo SelectUser(string userName) //查询表并返回结果 { UserInfo user = null; //用于保存读取的数据 try { SqlConnection conn = new SqlConnection(DbUtil.ConnString); //创建一个命令对象,并添加命令 SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = DbUtil.userDataBasesql3; cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@account", userName)); //cmd.Parameters.Add(new SqlParameter("@account", "%" + userName + "%")); conn.Open(); //打开数据链接 SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) //开始读取数据 { if (user == null) //如果没有,则重新生成一个 { user = new Model.UserInfo(); } user.Account = reader.GetString(reader.GetOrdinal("account")); user.Name = reader.GetString(reader.GetOrdinal("name")); user.Password = reader.GetString(reader.GetOrdinal("password")); user.Permission = reader.GetString(reader.GetOrdinal("permission")); user.Department = reader.GetString(reader.GetOrdinal("department")); } } catch (Exception ee) { exception = ee.ToString(); //Console.WriteLine(ee.ToString()); } //Console.WriteLine(image.ToString()); return(user); }
/// <summary> /// 查询是否有权限 /// </summary> /// <param name="TabKey">页面Key</param> /// <param name="RoleID">角色ID</param> /// <param name="PermissionKey">权限Key(全部为大写 如添加为ADD,修改为UPDATE,删除为DELETE,查看为VIEW)</param> /// <returns></returns> public static bool GetPermission(string TabKey, int UserID, string PermissionKey) { bool isVIEW = false; try { Model.UserInfo userInfo = BLL.UsersBLL.GetModel(UserID); if (userInfo == null || userInfo.UserID <= 0) { return(false); } if (userInfo.UserType == Common.enumUserType.host.ToString() || userInfo.UserType == Common.enumUserType.admin.ToString()) { return(true); } List <int> TabIDs = BLL.TabsBLL.GetTabIDsByTabKey(TabKey); foreach (int TabID in TabIDs) { if (TabID > 0) { List <Model.RoleInfo> rolelist = BLL.RolesBLL.GetList(-1, "RoleID in (select Roleid from UserRoles where userid=" + UserID + ")", ""); bool isPermission = false; foreach (Model.RoleInfo roleinfo in rolelist) { isVIEW = new PermissionDAL().GetPermission(TabID, roleinfo.RoleID, PermissionKey); if (isVIEW) { isPermission = true; } } if (isPermission) { break; } } } } catch { } return(isVIEW); }
/// <summary> /// 得到一个对象实体 /// </summary> public static Model.UserInfo GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from UserInfo "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.UserInfo model = new Model.UserInfo(); DataSet ds = DBHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public UserEdit(Model.UserInfo m_userinfo) { InitializeComponent(); // TODO: Complete member initialization this._m_userinfo = m_userinfo; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.UserInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update UserInfo set "); strSql.Append("username=@username,"); strSql.Append("mobile=@mobile,"); strSql.Append("isBindMobile=@isBindMobile,"); strSql.Append("email=@email,"); strSql.Append("isBindEmail=@isBindEmail,"); strSql.Append("password=@password,"); strSql.Append("md5Pass=@md5Pass,"); strSql.Append("relName=@relName,"); strSql.Append("bodyCode=@bodyCode,"); strSql.Append("comName=@comName,"); strSql.Append("pid=@pid,"); strSql.Append("cid=@cid,"); strSql.Append("regionId=@regionId,"); strSql.Append("address=@address,"); strSql.Append("zipCode=@zipCode,"); strSql.Append("qq=@qq,"); strSql.Append("weixin=@weixin,"); strSql.Append("isBindWeiXin=@isBindWeiXin,"); strSql.Append("weibo=@weibo,"); strSql.Append("isBindWeiBo=@isBindWeiBo,"); strSql.Append("shopType=@shopType,"); strSql.Append("shopTypeName=@shopTypeName,"); strSql.Append("imgUrl=@imgUrl,"); strSql.Append("comInfo=@comInfo,"); strSql.Append("remark=@remark,"); strSql.Append("status=@status,"); strSql.Append("addTime=@addTime,"); strSql.Append("mobileCode=@mobileCode,"); strSql.Append("activeCode=@activeCode,"); strSql.Append("infoType=@infoType"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@username", SqlDbType.VarChar, 150), new SqlParameter("@mobile", SqlDbType.VarChar, 150), new SqlParameter("@isBindMobile", SqlDbType.Int, 4), new SqlParameter("@email", SqlDbType.VarChar, 150), new SqlParameter("@isBindEmail", SqlDbType.Int, 4), new SqlParameter("@password", SqlDbType.VarChar, 150), new SqlParameter("@md5Pass", SqlDbType.VarChar, 150), new SqlParameter("@relName", SqlDbType.VarChar, 150), new SqlParameter("@bodyCode", SqlDbType.VarChar, 150), new SqlParameter("@comName", SqlDbType.VarChar, 150), new SqlParameter("@pid", SqlDbType.Int, 4), new SqlParameter("@cid", SqlDbType.Int, 4), new SqlParameter("@regionId", SqlDbType.Int, 4), new SqlParameter("@address", SqlDbType.VarChar, 150), new SqlParameter("@zipCode", SqlDbType.VarChar, 150), new SqlParameter("@qq", SqlDbType.VarChar, 150), new SqlParameter("@weixin", SqlDbType.VarChar, 150), new SqlParameter("@isBindWeiXin", SqlDbType.Int, 4), new SqlParameter("@weibo", SqlDbType.VarChar, 150), new SqlParameter("@isBindWeiBo", SqlDbType.Int, 4), new SqlParameter("@shopType", SqlDbType.Int, 4), new SqlParameter("@shopTypeName", SqlDbType.VarChar, 150), new SqlParameter("@imgUrl", SqlDbType.VarChar, 150), new SqlParameter("@comInfo", SqlDbType.NText), new SqlParameter("@remark", SqlDbType.VarChar, 150), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@mobileCode", SqlDbType.VarChar, 150), new SqlParameter("@activeCode", SqlDbType.VarChar, 150), new SqlParameter("@infoType", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.username; parameters[1].Value = model.mobile; parameters[2].Value = model.isBindMobile; parameters[3].Value = model.email; parameters[4].Value = model.isBindEmail; parameters[5].Value = model.password; parameters[6].Value = model.md5Pass; parameters[7].Value = model.relName; parameters[8].Value = model.bodyCode; parameters[9].Value = model.comName; parameters[10].Value = model.pid; parameters[11].Value = model.cid; parameters[12].Value = model.regionId; parameters[13].Value = model.address; parameters[14].Value = model.zipCode; parameters[15].Value = model.qq; parameters[16].Value = model.weixin; parameters[17].Value = model.isBindWeiXin; parameters[18].Value = model.weibo; parameters[19].Value = model.isBindWeiBo; parameters[20].Value = model.shopType; parameters[21].Value = model.shopTypeName; parameters[22].Value = model.imgUrl; parameters[23].Value = model.comInfo; parameters[24].Value = model.remark; parameters[25].Value = model.status; parameters[26].Value = model.addTime; parameters[27].Value = model.mobileCode; parameters[28].Value = model.activeCode; parameters[29].Value = model.infoType; parameters[30].Value = model.id; int rows = DBHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
//根据jobid 修改底薪 public static int UpdateDxById(Model.UserInfo uinfo, int dx) { return(DAL.JobServer.UpdateDxById(uinfo, dx)); }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(Model.UserInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserInfo("); strSql.Append("username,mobile,isBindMobile,email,isBindEmail,password,md5Pass,relName,bodyCode,comName,pid,cid,regionId,address,zipCode,qq,weixin,isBindWeiXin,weibo,isBindWeiBo,shopType,shopTypeName,imgUrl,comInfo,remark,status,addTime,mobileCode,activeCode,infoType,shopingTime,mainBrand,assessCount,shareCount,productType,goodCount,badCount,viewsCount,loginTime,loginIP)"); strSql.Append(" values ("); strSql.Append("@username,@mobile,@isBindMobile,@email,@isBindEmail,@password,@md5Pass,@relName,@bodyCode,@comName,@pid,@cid,@regionId,@address,@zipCode,@qq,@weixin,@isBindWeiXin,@weibo,@isBindWeiBo,@shopType,@shopTypeName,@imgUrl,@comInfo,@remark,@status,@addTime,@mobileCode,@activeCode,@infoType,@shopingTime,@mainBrand,@assessCount,@shareCount,@productType,@goodCount,@badCount,@viewsCount,@loginTime,@loginIP)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@username", SqlDbType.VarChar, 150), new SqlParameter("@mobile", SqlDbType.VarChar, 150), new SqlParameter("@isBindMobile", SqlDbType.Int, 4), new SqlParameter("@email", SqlDbType.VarChar, 150), new SqlParameter("@isBindEmail", SqlDbType.Int, 4), new SqlParameter("@password", SqlDbType.VarChar, 150), new SqlParameter("@md5Pass", SqlDbType.VarChar, 150), new SqlParameter("@relName", SqlDbType.VarChar, 150), new SqlParameter("@bodyCode", SqlDbType.VarChar, 150), new SqlParameter("@comName", SqlDbType.VarChar, 150), new SqlParameter("@pid", SqlDbType.Int, 4), new SqlParameter("@cid", SqlDbType.Int, 4), new SqlParameter("@regionId", SqlDbType.Int, 4), new SqlParameter("@address", SqlDbType.VarChar, 150), new SqlParameter("@zipCode", SqlDbType.VarChar, 150), new SqlParameter("@qq", SqlDbType.VarChar, 150), new SqlParameter("@weixin", SqlDbType.VarChar, 150), new SqlParameter("@isBindWeiXin", SqlDbType.Int, 4), new SqlParameter("@weibo", SqlDbType.VarChar, 150), new SqlParameter("@isBindWeiBo", SqlDbType.Int, 4), new SqlParameter("@shopType", SqlDbType.Int, 4), new SqlParameter("@shopTypeName", SqlDbType.VarChar, 150), new SqlParameter("@imgUrl", SqlDbType.VarChar, 150), new SqlParameter("@comInfo", SqlDbType.NText), new SqlParameter("@remark", SqlDbType.VarChar, 1500), new SqlParameter("@status", SqlDbType.Int, 4), new SqlParameter("@addTime", SqlDbType.DateTime), new SqlParameter("@mobileCode", SqlDbType.VarChar, 150), new SqlParameter("@activeCode", SqlDbType.VarChar, 150), new SqlParameter("@infoType", SqlDbType.Int, 4), new SqlParameter("@shopingTime", SqlDbType.VarChar, 54), new SqlParameter("@mainBrand", SqlDbType.VarChar, 154), new SqlParameter("@assessCount", SqlDbType.Int, 4), new SqlParameter("@shareCount", SqlDbType.Int, 4), new SqlParameter("@productType", SqlDbType.Int, 4), new SqlParameter("@goodCount", SqlDbType.Int, 4), new SqlParameter("@badCount", SqlDbType.Int, 4), new SqlParameter("@viewsCount", SqlDbType.Int, 4),new SqlParameter("@loginTime",SqlDbType.DateTime), new SqlParameter("@loginIP", SqlDbType.VarChar, 54) }; parameters[0].Value = model.username; parameters[1].Value = model.mobile; parameters[2].Value = model.isBindMobile; parameters[3].Value = model.email; parameters[4].Value = model.isBindEmail; parameters[5].Value = model.password; parameters[6].Value = model.md5Pass; parameters[7].Value = model.relName; parameters[8].Value = model.bodyCode; parameters[9].Value = model.comName; parameters[10].Value = model.pid; parameters[11].Value = model.cid; parameters[12].Value = model.regionId; parameters[13].Value = model.address; parameters[14].Value = model.zipCode; parameters[15].Value = model.qq; parameters[16].Value = model.weixin; parameters[17].Value = model.isBindWeiXin; parameters[18].Value = model.weibo; parameters[19].Value = model.isBindWeiBo; parameters[20].Value = model.shopType; parameters[21].Value = model.shopTypeName; parameters[22].Value = model.imgUrl; parameters[23].Value = model.comInfo; parameters[24].Value = model.remark; parameters[25].Value = model.status; parameters[26].Value = model.addTime; parameters[27].Value = model.mobileCode; parameters[28].Value = model.activeCode; parameters[29].Value = model.infoType; parameters[30].Value = model.shopingtime; parameters[31].Value = model.mainbrand; parameters[32].Value = model.assesscount; parameters[33].Value = model.sharecount; parameters[34].Value = model.producttype; parameters[35].Value = model.goodcount; parameters[36].Value = model.badcount; parameters[37].Value = model.viewscountd; parameters[38].Value = model.logintime; parameters[39].Value = model.loginip; object obj = DBHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新普通用户信息 /// </summary> /// <returns></returns> public static int UpdateCommonInfo(Model.UserInfo model) { string sql = "update UserInfo set pid=" + model.pid + ",cid = " + model.cid + ", comName = '" + model.comName + "',mobile = '" + model.mobile + "',mainBrand = '" + model.mainbrand + "',email = '" + model.email + "',address = '" + model.address + "',regionId = " + model.regionId + " where id = " + model.id; return(DBHelperSQL.ExecuteSql(sql)); }
//查询员工 员工编号 职务 底薪 返回DataSet public static DataSet SelectAStaffJobDxById(Model.UserInfo uinfo) { return(DAL.JobServer.SelectAStaffJobDxById(uinfo)); }
//查询员工 员工编号 职务 底薪 返回DataSet public static DataSet SelectAStaffJobDxById(Model.UserInfo uinfo) { sqltext = "SELECT UserInfo.name as 员工,UserInfo.uid as 员工编号,departjob.jobname as 职务,departjob.dx as 底薪 FROM UserInfo ,departjob where UserInfo.jobid=departjob.jobid AND UserInfo.uid='" + uinfo.Uid + "'"; return(DAL.SQLHELPER.ExecuteDataSet(sqltext)); }
//根据jobid 修改底薪 public static int UpdateDxById(Model.UserInfo uinfo, int dx) { sqltext = "UPDATE departjob SET dx='" + dx + "' WHERE jobid='" + uinfo.Uid + "'"; return(Convert.ToInt32(DAL.SQLHELPER.ExecuteNonQuery(sqltext))); }
/// <summary> /// 得到一个对象实体 /// </summary> public static Model.UserInfo DataRowToModel(DataRow row) { Model.UserInfo model = new Model.UserInfo(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["username"] != null) { model.username = row["username"].ToString(); } if (row["mobile"] != null) { model.mobile = row["mobile"].ToString(); } if (row["isBindMobile"] != null && row["isBindMobile"].ToString() != "") { model.isBindMobile = int.Parse(row["isBindMobile"].ToString()); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["isBindEmail"] != null && row["isBindEmail"].ToString() != "") { model.isBindEmail = int.Parse(row["isBindEmail"].ToString()); } if (row["password"] != null) { model.password = row["password"].ToString(); } if (row["md5Pass"] != null) { model.md5Pass = row["md5Pass"].ToString(); } if (row["telephone"] != null) { model.telephone = row["telephone"].ToString(); } if (row["relName"] != null) { model.relName = row["relName"].ToString(); } if (row["bodyCode"] != null) { model.bodyCode = row["bodyCode"].ToString(); } if (row["comName"] != null) { model.comName = row["comName"].ToString(); } if (row["pid"] != null && row["pid"].ToString() != "") { model.pid = int.Parse(row["pid"].ToString()); } if (row["cid"] != null && row["cid"].ToString() != "") { model.cid = int.Parse(row["cid"].ToString()); } if (row["regionId"] != null && row["regionId"].ToString() != "") { model.regionId = int.Parse(row["regionId"].ToString()); } if (row["address"] != null) { model.address = row["address"].ToString(); } if (row["zipCode"] != null) { model.zipCode = row["zipCode"].ToString(); } if (row["qq"] != null) { model.qq = row["qq"].ToString(); } if (row["weixin"] != null) { model.weixin = row["weixin"].ToString(); } if (row["isBindWeiXin"] != null && row["isBindWeiXin"].ToString() != "") { model.isBindWeiXin = int.Parse(row["isBindWeiXin"].ToString()); } if (row["weibo"] != null) { model.weibo = row["weibo"].ToString(); } if (row["isBindWeiBo"] != null && row["isBindWeiBo"].ToString() != "") { model.isBindWeiBo = int.Parse(row["isBindWeiBo"].ToString()); } if (row["shopType"] != null && row["shopType"].ToString() != "") { model.shopType = int.Parse(row["shopType"].ToString()); } if (row["shopTypeName"] != null) { model.shopTypeName = row["shopTypeName"].ToString(); } if (row["imgUrl"] != null) { model.imgUrl = row["imgUrl"].ToString(); } if (row["comInfo"] != null) { model.comInfo = row["comInfo"].ToString(); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } if (row["status"] != null && row["status"].ToString() != "") { model.status = int.Parse(row["status"].ToString()); } if (row["addTime"] != null && row["addTime"].ToString() != "") { model.addTime = DateTime.Parse(row["addTime"].ToString()); } if (row["mobileCode"] != null) { model.mobileCode = row["mobileCode"].ToString(); } if (row["activeCode"] != null) { model.activeCode = row["activeCode"].ToString(); } if (row["infoType"] != null && row["infoType"].ToString() != "") { model.infoType = int.Parse(row["infoType"].ToString()); } model.shopingtime = row["shopingTime"].ToString(); model.mainbrand = row["mainbrand"].ToString(); if (row["assessCount"] != null && row["assessCount"].ToString() != "") { model.assesscount = int.Parse(row["assessCount"].ToString()); } if (row["shareCount"] != null && row["shareCount"].ToString() != "") { model.sharecount = int.Parse(row["shareCount"].ToString()); } if (row["productType"] != null && row["productType"].ToString() != "") { model.producttype = int.Parse(row["productType"].ToString()); } if (row["goodCount"] != null && row["goodCount"].ToString() != "") { model.goodcount = int.Parse(row["goodCount"].ToString()); } if (row["badCount"] != null && row["badCount"].ToString() != "") { model.badcount = int.Parse(row["badCount"].ToString()); } if (row["viewsCount"] != null && row["viewsCount"].ToString() != "") { model.viewscountd = int.Parse(row["viewsCount"].ToString()); } model.loginip = row["loginip"].ToString(); if (row["logintime"] != null && row["logintime"].ToString() != "") { model.logintime = DateTime.Parse(row["logintime"].ToString()); } model.relName = row["relName"].ToString(); } return(model); }
/// <summary> /// 用于向 UserInfo EntitySet 添加新对象的方法,已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。 /// </summary> public void AddToUserInfo(UserInfo userInfo) { base.AddObject("UserInfo", userInfo); }
public OrderInfo() { this.VisitTimes = new System.Collections.Generic.List<VisitTime>(); this.Doctor = new DoctorInfo(); this.User = new UserInfo(); }
/// <summary> /// 子菜单JSON /// </summary> /// <param name="UserID">当前登陆帐号</param> /// <param name="menuid">菜单ID 一般为父级ID 也可以是admin或host 如果是"0"则查全部</param> /// <param name="Level">级别 0为到所有级 1为到一级 2为到二级 ...</param> /// <returns></returns> public static string GetSubMenuJSON(int UserID, string menuid, int Level) { i = 0; if (menuid.Trim().Length == 0 || menuid.Trim() == "-1") { return("[]"); } string UserType = ""; Model.UserInfo userinfo = BLL.UsersBLL.GetModel(UserID); if (userinfo == null || userinfo.UserID != UserID) { return("[]"); } UserType = userinfo.UserType; string result = "["; if ((UserType == Common.enumUserType.host.ToString() || UserType == Common.enumUserType.admin.ToString()) && (menuid.Trim().ToLower() == "admin")) { if (menuid.Trim().ToLower() == "admin") { if (Level > 1) { result += "{\"url\":\"DesktopModules/district/district.aspx\",\"id\":\"district\",\"name\":\"城市设置\",\"submenu\":[]},"; //result += "{\"url\":\"DesktopModules/companys/companys.aspx\",\"id\":\"companys\",\"name\":\"代理商\",\"submenu\":[]},"; result += "{\"url\":\"DesktopModules/Users/ViewUsers.aspx\",\"id\":\"users\",\"name\":\"帐号管理\",\"submenu\":[]},"; result += "{\"url\":\"DesktopModules/Roles/ViewRoles.aspx\",\"id\":\"viewroles\",\"name\":\"角色\",\"submenu\":[]},"; result += "{\"url\":\"DesktopModules/eventlog/eventlog.aspx\",\"id\":\"eventlog\",\"name\":\"事件日志\",\"submenu\":[]},"; } } if (result.EndsWith(",")) { result = result.Remove(result.Length - 1); } result += "]"; return(result); } if (UserType == Common.enumUserType.host.ToString() && (menuid.Trim().ToLower() == "host")) { if (menuid.Trim().ToLower() == "host") { if (Level > 1) { result += "{\"url\":\"DesktopModules/console/datainit.aspx\",\"id\":\"datainit\",\"name\":\"刷新基础数据\",\"submenu\":[]},"; result += "{\"url\":\"DesktopModules/Tabs/TabsList.aspx\",\"id\":\"pagemenu\",\"name\":\"菜单\",\"submenu\":[]},"; result += "{\"url\":\"DesktopModules//SQL/execSQL.aspx\",\"id\":\"execsql\",\"name\":\"执行脚本\",\"submenu\":[]},"; } } if (result.EndsWith(",")) { result = result.Remove(result.Length - 1); } result += "]"; return(result); } int ParentId = -1; int.TryParse(menuid.Trim(), out ParentId); if (ParentId > 0) { result += menuJSON(UserID, ParentId, Level); } if (result.EndsWith(",")) { result = result.Remove(result.Length - 1); } result += "]"; return(result); }
/// <summary> /// 菜单XML /// </summary> /// <param name="UserID">当前登陆帐号</param> /// <param name="menuid">菜单ID 一般为父级ID 也可以是admin或host 如果是"0"则查全部</param> /// <param name="Level">级别 0为到所有级 1为到一级 2为到二级 ...</param> /// <returns></returns> public static string GetMenuXML(int UserID, string menuid, int Level) { i = 0; string result = "<?xml version=\"1.0\" encoding=\"utf-8\" ?>"; if (menuid.Trim().Length == 0 || menuid.Trim() == "-1") { return(result); } string UserType = ""; Model.UserInfo userinfo = BLL.UsersBLL.GetModel(UserID); if (userinfo == null || userinfo.UserID != UserID) { return(""); } UserType = userinfo.UserType; result += "<Tabs>"; string addto1 = ""; if ((UserType == Common.enumUserType.host.ToString() || UserType == Common.enumUserType.admin.ToString()) && (menuid.Trim().ToLower() == "admin")) { if (menuid.Trim().ToLower() == "admin") { if (Level != 1) { addto1 += "<Tab NavigateUrl=\"DesktopModules/companys/companys.aspx\" ID=\"companys\" Text=\"代理商\" />"; addto1 += "<Tab NavigateUrl=\"DesktopModules/Users/ViewUsers.aspx\" ID=\"users\" Text=\"帐号管理\" />"; addto1 += "<Tab NavigateUrl=\"DesktopModules/Roles/ViewRoles.aspx\" ID=\"viewroles\" Text=\"角色\"/>"; } } else { addto1 += "<Tab ID=\"admin\" NavigateUrl=\"Main.aspx?menuid=admin\" Text=\"Admin\">"; if (Level != 1) { addto1 += "<Tab NavigateUrl=\"DesktopModules/companys/companys.aspx\" ID=\"companys\" Text=\"代理商\" />"; addto1 += "<Tab NavigateUrl=\"DesktopModules/Users/ViewUsers.aspx\" ID=\"users\" Text=\"帐号管理\" />"; addto1 += "<Tab NavigateUrl=\"DesktopModules/Roles/ViewRoles.aspx\" ID=\"viewroles\" Text=\"角色\"/>"; } addto1 += "</Tab>"; } } if (UserType == Common.enumUserType.host.ToString() && (menuid.Trim().ToLower() == "host")) { if (menuid.Trim().ToLower() == "host") { if (Level != 1) { addto1 += "<Tab NavigateUrl=\"DesktopModules/Tabs/TabsList.aspx\" ID=\"pagemenu\" Text=\"菜单\" />"; addto1 += "<Tab NavigateUrl=\"DesktopModules/SQL/execSQL.aspx\" ID=\"execsql\" Text=\"执行脚本\" />"; } } else { addto1 += "<Tab ID=\"host\" NavigateUrl=\"Main.aspx?menuid=host\" Text=\"host\">"; if (Level != 1) { addto1 += "<Tab NavigateUrl=\"DesktopModules/Tabs/TabsList.aspx\" ID=\"pagemenu\" Text=\"菜单\" />"; addto1 += "<Tab NavigateUrl=\"DesktopModules/SQL/execSQL.aspx\" ID=\"execsql\" Text=\"执行脚本\" />"; } addto1 += "</Tab>"; } } int ParentId = -1; try { ParentId = int.Parse(menuid.Trim()); } catch { } string addto0 = ""; //if (menuid.Trim().ToLower() == "0") // addto0 = "<Tab NavigateUrl=\"javascript:void(0);\" ID=\"home\" Text=\"\" Img=\"images/home.png\"/>"; result += menuXML(UserID, ParentId, Level, addto0, addto1); result += "</Tabs>"; return(result); }
public bool Equals(UserInfo anotherUserInfo) { return this.UiID == anotherUserInfo.UiID && this.UiName == anotherUserInfo.UiName && this.UiSex == anotherUserInfo.UiSex && this.UiIdentityNum == anotherUserInfo.UiIdentityNum && this.UiDepartment == anotherUserInfo.UiDepartment && this.UiTelephone == anotherUserInfo.UiTelephone && this.UiEmail == anotherUserInfo.UiEmail && this.UiMobPhone == anotherUserInfo.UiMobPhone && this.UiAddress == anotherUserInfo.UiAddress && this.UiZipCode == anotherUserInfo.UiZipCode && this.UiType == anotherUserInfo.UiType && this.UiJob == anotherUserInfo.UiJob && this.UiFund == anotherUserInfo.UiFund && this.UiCharacter == anotherUserInfo.UiCharacter && this.UiCompany == anotherUserInfo.UiCompany && this.UiEvaluationStatus == anotherUserInfo.UiEvaluationStatus; ; }
/// <summary> /// 创建新的 UserInfo 对象。 /// </summary> /// <param name="id">ID 属性的初始值。</param> /// <param name="userName">UserName 属性的初始值。</param> /// <param name="pwd">Pwd 属性的初始值。</param> /// <param name="phone">Phone 属性的初始值。</param> /// <param name="idCard">IdCard 属性的初始值。</param> /// <param name="level">Level 属性的初始值。</param> public static UserInfo CreateUserInfo(global::System.Int32 id, global::System.String userName, global::System.String pwd, global::System.String phone, global::System.String idCard, global::System.Int32 level) { UserInfo userInfo = new UserInfo(); userInfo.ID = id; userInfo.UserName = userName; userInfo.Pwd = pwd; userInfo.Phone = phone; userInfo.IdCard = idCard; userInfo.Level = level; return userInfo; }