public static string Add(HttpContext context) { string uid = context.Request.Form["uid"].ToStringExt(); if (string.IsNullOrEmpty(uid)) throw new ArgumentNullException("uid", "不能为空"); string pwd = context.Request.Form["pwd"].ToStringExt(); if (string.IsNullOrEmpty(pwd)) throw new ArgumentNullException("pwd", "不能为空"); string name = context.Request.Form["name"]; string sex = context.Request.Form["sex"]; string birthday = context.Request.Form["birthday"]; string email = context.Request.Form["email"]; Model.User_Model user = new User_Model(); user.Email = email; user.Birthday = birthday.StrToDateTime(DateTime.MaxValue); user.Name = name; user.Password = pwd; user.UserID = uid; user.Sex = sex.ToInt(0); JsonTpl<string> jsonTemplate = new JsonTpl<string>(); jsonTemplate.msg = "添加失败"; jsonTemplate.code = -11; jsonTemplate.data = ""; bool addSucess = Bll.User_Bll.InsertUser(user); if (addSucess) { jsonTemplate.msg = "添加成功"; jsonTemplate.code = 1; } string jsonResult = Common.json.JsonHelper<JsonTpl<string>>.Serialize2Object(jsonTemplate); return jsonResult; }
public bool Insert(User_Model tModel) { using (SqlCommand command = new DbHelper().Command) { command.CommandText = $"insert into {Table}(UserID,[Password],Name,Sex,Birthday,Email) values (@UserID,@Password,@Name,@Sex,@Birthday,@Email)"; command.Parameters.AddRange(CreateSqlParameters(tModel)); int ret = command.ExecuteNonQuery(); return ret > 0; } }
public User_Model GetOne(Where @where, string fields) { using (SqlCommand command = new DbHelper().Command) { User_Model user = new User_Model(); string sql = $"select top 1 {fields} from {Table} where {where.Result};"; IDataReader reader = command.ExecuteReaderExt(sql, where); if (reader.Read()) { user = ReaderModel(reader, fields); } return user; } }
private SqlParameter[] CreateSqlParameters(User_Model tModel) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.VarChar), new SqlParameter("@Password", SqlDbType.VarChar), new SqlParameter("@Name", SqlDbType.NVarChar), new SqlParameter("@Sex", SqlDbType.Int), new SqlParameter("@Birthday", SqlDbType.DateTime), new SqlParameter("@Email", SqlDbType.VarChar) }; parameters[0].Value = tModel.UserID; parameters[1].Value = tModel.Password; parameters[2].Value = tModel.Name; parameters[3].Value = tModel.Sex; parameters[4].Value = tModel.Birthday; parameters[5].Value = tModel.Email; return parameters; }
public User_Model ReaderModel(IDataReader reader, string fields) { #region check fields string flds = (string.IsNullOrEmpty(fields)) ? "*" : fields.Trim(); IEnumerable<string> fieldList = new List<string>(); if (flds != "*") { fieldList = flds.Split(',').Select(field => field.Trim()); } #endregion User_Model user = new User_Model(); if (CheckField(flds, fieldList, "ID")) { user.ID = reader.GetInt32(reader.GetOrdinal("ID")); } if (CheckField(flds, fieldList, "Sex")) { user.Sex = reader.GetInt32(reader.GetOrdinal("Sex")); } if (CheckField(flds, fieldList, "Birthday")) { user.Birthday = reader.GetDateTime(reader.GetOrdinal("Birthday")); } if (CheckField(flds, fieldList, "Name")) { user.Name = reader.GetString(reader.GetOrdinal("Name")); } if (CheckField(flds, fieldList, "UserID")) { user.UserID = reader.GetString(reader.GetOrdinal("UserID")); } if (CheckField(flds, fieldList, "Password")) { user.Password = reader.GetString(reader.GetOrdinal("Password")); } if (CheckField(flds, fieldList, "Email")) { user.Email = reader.GetString(reader.GetOrdinal("Email")); } return user; }
public static bool InsertUser(User_Model tModel) { return Dal.Insert(tModel); }