private void btnuser_Click(object sender, EventArgs e) { moveSlidePanel(btnuser); UC_User us = new UC_User(); AddControlPanel(us); }
public void Verify() { UC_User model = new UC_User(); model.Mobile = "18600522656"; model.PassWord = "******"; result = con.Verify(model); }
public void Update() { UC_User model = new UC_User(); model.Mobile = "18600522656"; model.PassWord = "******"; List <string> ids = new List <string>(); ids.Add("YH4F2127A3521E42709FD371BF9434C051"); result = con.Update(ids, model, model); }
public void PostgreSQLTest() { //var list = new PostgreSQL().ExecuteReader<Number>("select * from test"); //list.ForEach(t => Console.WriteLine(t.ToString())); UC_User model = new UC_User(); model.Mobile = "18600522656"; model.PassWord = "******"; result = con.Add(model); Console.ReadLine(); }
/// <summary> /// 删除用户 /// </summary> /// <param name="model"></param> /// <param name="operationUser"></param> /// <returns></returns> public AjaxMsgResult Del(List <string> ids, UC_User operationUser) { result.Success = false; try { if (ids.Count == 0) { result.State = AjaxMsgResult.StateEnum.VerifyFailed; result.Msg = "未检测到要修改的id!"; return(result); } Dictionary <string, object> dic = new Dictionary <string, object>(); StringBuilder sql = new StringBuilder(); sql.Append(@"UPDATE UC_User SET IsValid=1 WHERE 1=1 "); for (int i = 0; i < ids.Count; i++) { if (ids.Count > 0) { if (i > 0) { sql.AppendFormat(@" OR Id=?Id{0} ", i); if (i == ids.Count - 1) { sql.Append(@" ) "); } } else { sql.AppendFormat(@" AND ( Id=?Id{0} ", i); } } else { sql.AppendFormat(@" AND Id=?Id{0} ", i); } dic.Add("Id" + i, ids[i]); } int count = DataBaseFactory.GetDataBase(DataBaseType.main).ExecuteNonQuery(sql.ToString(), dic); if (count == ids.Count) { result.Success = true; } else { result.Msg = "删除失败,请检查数据合法性!"; } } catch (Exception e) { result.Msg = e.ToString(); } return(result); }
//IDataBase con = new PostgreSQL(); #region 添加用户 /// <summary> /// 添加用户 /// </summary> /// <param name="model"></param> /// <returns></returns> public AjaxMsgResult Add(UC_User model, string CreateUser = null) { result.Success = false; try { if (IsRepeat(model.LoginName, model.Mobile, model.Email) == true) { result.State = AjaxMsgResult.StateEnum.IsExist; result.Msg = "添加失败,存在相同的数据!"; return(result); } if (string.IsNullOrWhiteSpace(model.LoginName) && string.IsNullOrWhiteSpace(model.Mobile) && string.IsNullOrWhiteSpace(model.Email)) { result.State = AjaxMsgResult.StateEnum.VerifyFailed; result.Msg = "添加失败,注册用户名为空!"; return(result); } Dictionary <string, object> dic = new Dictionary <string, object>(); StringBuilder sql = new StringBuilder(); sql.Append(@" INSERT INTO UC_User(Id,UserName,LoginName,PassWord,IsValid,Status,Mobile,CreateUser,CreateTime) VALUES (?Id,?UserName,?LoginName,?PassWord,?IsValid,?Status,?Mobile,?CreateUser,?CreateTime)"); string id = NewData.NewId("YH"); dic.Add("Id", id); dic.Add("UserName", model.UserName); dic.Add("LoginName", model.LoginName); dic.Add("PassWord", Com.SHA512Encrypt(model.PassWord)); dic.Add("IsValid", model.IsValid); dic.Add("Status", model.Status); dic.Add("Mobile", model.Mobile); dic.Add("CreateUser", CreateUser == null? id:model.CreateUser); dic.Add("CreateTime", DateTime.Now); int count = DataBaseFactory.GetDataBase(DataBaseType.main).ExecuteNonQuery(sql.ToString(), dic); if (count == 1) { if (userExtendService.Add(id).Success == true) { result = Verify(model); } } else { result.Msg = "添加失败,请检查数据合法性!"; } } catch (Exception e) { result.Msg = e.ToString(); } return(result); }
/// <summary> /// 验证 /// </summary> /// <param name="model"></param> /// <returns></returns> public AjaxMsgResult Verify(UC_User model) { result.Success = false; try { if (string.IsNullOrWhiteSpace(model.LoginName) && string.IsNullOrWhiteSpace(model.Mobile) && string.IsNullOrWhiteSpace(model.Email)) { result.State = AjaxMsgResult.StateEnum.VerifyFailed; return(result); } Dictionary <string, object> dic = new Dictionary <string, object>(); StringBuilder sql = new StringBuilder(); sql.Append(@" select * from UC_User WHERE 1=1 "); if (!string.IsNullOrWhiteSpace(model.LoginName)) { sql.Append(@" AND LoginName=?LoginName"); dic.Add("LoginName", model.LoginName); } if (!string.IsNullOrWhiteSpace(model.Mobile)) { sql.Append(@" AND Mobile=?Mobile"); dic.Add("Mobile", model.Mobile); } if (!string.IsNullOrWhiteSpace(model.Email)) { sql.Append(@" AND Email=?Email"); dic.Add("Email", model.Email); } sql.Append(@" AND PassWord=?PassWord "); dic.Add("PassWord", Com.SHA512Encrypt(model.PassWord)); IList <UC_User> data = DataBaseFactory.GetDataBase(DataBaseType.main).ExecuteReader <UC_User>(sql.ToString(), true, dic); if (data != null) { if (data.Count > 0) { result.Success = true; result.Source = data; } } } catch (Exception e) { result.Msg = e.ToString(); } return(result); }
/// <summary> /// 查询 /// </summary> /// <param name="model"></param> /// <returns></returns> public AjaxMsgResult Query(UC_User model, int orderType = 1, int pageSize = 10, int pageIndex = 0, int recordCount = 0) { result.Success = false; try { Dictionary <string, object> dic = new Dictionary <string, object>(); List <string> fileds = new List <string>(); fileds.Add("*"); string orderColumnName = "CreateTime"; StringBuilder sublistSql = new StringBuilder(); sublistSql.Append(@" SELECT * FROM UC_User WHERE 1=1 "); if (model.Id != null) { sublistSql.Append(@" AND Id=?Id "); dic.Add("Id", model.Id); } if (model.UserName != null) { sublistSql.Append(@" AND UserName LIKE ?UserName "); dic.Add("UserName", "%" + model.UserName + "%"); } if (model.LoginName != null) { sublistSql.Append(@" AND LoginName LIKE ?LoginName "); dic.Add("LoginName", "%" + model.LoginName + "%"); } if (model.IsValid != null) { sublistSql.Append(@" AND IsValid=?IsValid "); } if (model.Status != null) { sublistSql.Append(@" AND Status=?Status "); } if (model.Mobile != null) { sublistSql.Append(@" AND Mobile LIKE ?Mobile "); dic.Add("Mobile", "%" + model.Mobile + "%"); } if (model.CreateUser != null) { sublistSql.Append(@" AND CreateUser=?CreateUser "); } if (model.CreateTime != null) { sublistSql.Append(@" AND IsValid=?IsValid "); } if (model.Email != null) { sublistSql.Append(@" AND Email LIKE ?Email "); dic.Add("Email", "%" + model.Email + "%"); } RecordAsPageModel page = new RecordAsPageModel(); page.FldName = ""; page.OrderType = Convert.ToInt16(orderType); page.PageIndex = pageIndex; page.SortName = orderColumnName; IList <UC_User> list = (DataBaseFactory.GetDataBase(DataBaseType.main).ExecuteReader <UC_User>(sublistSql.ToString(), true, dic)); } catch (Exception e) { result.Msg = e.ToString(); } return(result); }
public AjaxMsgResult Update(List <string> ids, UC_User model, UC_User operationUser) { result.Success = false; try { if (ids.Count == 0) { result.State = AjaxMsgResult.StateEnum.VerifyFailed; result.Msg = "未检测到要修改的id!"; return(result); } Dictionary <string, object> dic = new Dictionary <string, object>(); StringBuilder sql = new StringBuilder(); sql.Append(@"UPDATE UC_User SET "); if (model.UserName != null) { sql.Append(@" UserName=?UserName,"); dic.Add("UserName", model.UserName); } if (model.PassWord != null) { sql.Append(@" PassWord=?PassWord,"); dic.Add("PassWord", Com.SHA512Encrypt(model.PassWord)); } if (model.IsValid != null) { sql.Append(@" IsValid=?IsValid,"); dic.Add("IsValid", model.IsValid); } if (model.Status != null) { sql.Append(@" Status=?Status,"); dic.Add("Status", model.Status); } if (model.Mobile != null) { sql.Append(@" Mobile=?Mobile,"); dic.Add("Mobile", model.Mobile); } if (model.Email != null) { sql.Append(@" Email=?Email,"); dic.Add("Email", model.Email); } //去掉最后一个逗号 sql.Remove(sql.Length - 1, 1); sql.Append(@" WHERE 1=1 "); for (int i = 0; i < ids.Count; i++) { if (ids.Count > 1) { if (i > 0) { sql.AppendFormat(@" OR Id=?Id{0} ", i); if (i == ids.Count - 1) { sql.Append(@" ) "); } } else { sql.AppendFormat(@" AND ( Id=?Id{0} ", i); } } else { sql.AppendFormat(@" AND Id=?Id{0} ", i); } dic.Add("Id" + i, ids[i]); } int count = DataBaseFactory.GetDataBase(DataBaseType.main).ExecuteNonQuery(sql.ToString(), dic); if (count == ids.Count) { result.Success = true; } else { result.Msg = "修改失败,请检查数据合法性!"; } } catch (Exception e) { result.Msg = e.ToString(); } return(result); }