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);
}
