private static string AddUser()
{
string strreturn;
string strNickname = NetSchool.Common.Library.GetPostBack.GetPostBackStr("nickname");
string strIdcard = NetSchool.Common.Library.GetPostBack.GetPostBackStr("idcard");
string strCompany = NetSchool.Common.Library.GetPostBack.GetPostBackStr("company");
string strRoles = NetSchool.Common.Library.GetPostBack.GetPostBackStr("roles");
string strGender = NetSchool.Common.Library.GetPostBack.GetPostBackStr("gender");
NetSchool.Model.EduUser eduUserInfo = new Model.EduUser();
eduUserInfo.Id = Guid.NewGuid();
eduUserInfo.NickName = strNickname;
eduUserInfo.Idcard = strIdcard;
eduUserInfo.Roles = strRoles;
eduUserInfo.Gender = strGender;
eduUserInfo.Company = strCompany;
eduUserInfo.CreateTime = DateTime.Now;
eduUserInfo.CreatedTime = Common.Library.ChangeTime.GetStamp(DateTime.Now.ToString());
if (NetSchool.BLL.EduUser.Add(eduUserInfo))
{
strreturn = JsonConvert.SerializeObject(new { state = "success", msg = "OK" }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
else
{
strreturn = JsonConvert.SerializeObject(new { state = "error", msg = "插入失败" }, new Newtonsoft.Json.Converters.IsoDateTimeConverter()
{
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
return(strreturn);
}
public static SqlParameter[] GetModelPare(Model.EduUser model)
{
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@Nickname", SqlDbType.NVarChar),
new SqlParameter("@Idcard", SqlDbType.NVarChar),
new SqlParameter("@Company", SqlDbType.NVarChar),
new SqlParameter("@Roles", SqlDbType.NVarChar),
new SqlParameter("@Gender", SqlDbType.NVarChar),
new SqlParameter("@CreatedTime", SqlDbType.Int, 10),
new SqlParameter("@CreateTime", SqlDbType.Date)
};
parameters[0].Value = model.Id;
if (string.IsNullOrWhiteSpace(model.Company))
{
parameters[3].Value = DBNull.Value;
}
else
{
parameters[3].Value = model.Company;
}
if (string.IsNullOrWhiteSpace(model.NickName))
{
parameters[1].Value = DBNull.Value;
}
else
{
parameters[1].Value = model.NickName;
}
if (string.IsNullOrWhiteSpace(model.Idcard))
{
parameters[2].Value = DBNull.Value;
}
else
{
parameters[2].Value = model.Idcard;
}
if (string.IsNullOrWhiteSpace(model.Roles))
{
parameters[4].Value = DBNull.Value;
}
else
{
parameters[4].Value = model.Roles;
}
if (string.IsNullOrWhiteSpace(model.Gender))
{
parameters[5].Value = DBNull.Value;
}
else
{
parameters[5].Value = model.Gender;
}
parameters[6].Value = model.CreatedTime;
parameters[7].Value = model.CreateTime;
return(parameters);
}
public bool Update(Model.EduUser model)
{
return(SqlHelper.SqlHelper.ExecuteNonQuery(updatesql, GetModelPare(model)) > 0);
}
public bool Add(Model.EduUser model)
{
return(SqlHelper.SqlHelper.ExecuteNonQuery(insertsql, GetModelPare(model)) > 0);
}
