public RetModel Register(UserInfo user)
{
Sys_UserInfoBLL bll = new Sys_UserInfoBLL();
Sys_UserInfo model = new Sys_UserInfo()
{
UserName = user.UserName,
Password = user.Password,
Email = user.Email,
Phone = user.Phone
};
int result = bll.Add(model);
RetModel retmodel = new RetModel();
switch (result)
{
case 0:
retmodel.StatusCode = Convert.ToInt32(ResultType.userIsExist).ToString();
break;
case -1:
retmodel.StatusCode = Convert.ToInt32(ResultType.EmailIsExist).ToString();
break;
case -2:
retmodel.StatusCode = Convert.ToInt32(ResultType.PhoneIsExist).ToString();
break;
default:
retmodel.StatusCode = Convert.ToInt32(ResultType.success).ToString();
retmodel.RetValue = RongCloudServer.GetToken(appKey, appSecret, model.ID, model.UserName, "http://www.qqw21.com/article/UploadPic/2012-11/201211259378560.jpg");
break;
}
return retmodel;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Sys_UserInfo model)
{
SqlConnection sqlConn = new SqlConnection(DbHelperSQL.connectionString);
sqlConn.Open();
SqlCommand sqlCmd = new SqlCommand("AddUserInfo", sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@ID", SqlDbType.VarChar, 50).Value = model.ID;
sqlCmd.Parameters.Add("@UserName", SqlDbType.VarChar, 50).Value = model.UserName;
sqlCmd.Parameters.Add("@Password", SqlDbType.VarChar, 250).Value = model.Password;
sqlCmd.Parameters.Add("@Email", SqlDbType.VarChar, 250).Value = model.Email;
sqlCmd.Parameters.Add("@Phone", SqlDbType.VarChar, 250).Value = model.Phone;
sqlCmd.Parameters.Add("ReturnValue", SqlDbType.Int, 4);
sqlCmd.Parameters["ReturnValue"].Direction = ParameterDirection.ReturnValue;
sqlCmd.ExecuteNonQuery();
int result = Convert.ToInt32(sqlCmd.Parameters["ReturnValue"].Value);
return result;
// SqlParameter[] parameters = {
// new SqlParameter("@ID", SqlDbType.VarChar,38),
// new SqlParameter("@UserName", SqlDbType.VarChar,50),
// new SqlParameter("@Password", SqlDbType.VarChar,50),
// //new SqlParameter("@NiName", SqlDbType.NVarChar,50),
// new SqlParameter("@Email", SqlDbType.VarChar,50),
// new SqlParameter("@Phone", SqlDbType.VarChar,12),
// //new SqlParameter("@Sex", SqlDbType.Bit,1),
// //new SqlParameter("@Birthday", SqlDbType.DateTime),
// //new SqlParameter("@ImageUrl", SqlDbType.VarChar,100)
// //,
// //new SqlParameter("@IsDeleted", SqlDbType.Bit,1),
// //new SqlParameter("@CreateTime", SqlDbType.DateTime),
// //new SqlParameter("@DeleteTime", SqlDbType.DateTime)
// };
// parameters[0].Value = model.ID;
// parameters[1].Value = model.UserName;
// parameters[2].Value = model.Password;
//// parameters[3].Value = model.NiName;
//// parameters[4].Value = model.Sex;
//// parameters[5].Value = model.Birthday;
// parameters[3].Value = model.Email;
// parameters[4].Value = model.Phone;
//// parameters[8].Value = model.ImageUrl;
// //parameters[9].Value = model.IsDeleted;
// //parameters[10].Value = model.CreateTime;
// //parameters[11].Value = model.DeleteTime;
// int rows = 0;
// int result = DbHelperSQL.RunProcedure("AddUserInfo", parameters, out rows);
// return result;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Sys_UserInfo DataRowToModel(DataRow row)
{
Sys_UserInfo model = new Sys_UserInfo();
if (row != null)
{
if (row["ID"] != null)
{
model.ID = row["ID"].ToString();
}
if (row["UserName"] != null)
{
model.UserName = row["UserName"].ToString();
}
if (row["Password"] != null)
{
model.Password = row["Password"].ToString();
}
if (row["NiName"] != null)
{
model.NiName = row["NiName"].ToString();
}
if (row["Sex"] != null && row["Sex"].ToString() != "")
{
if ((row["Sex"].ToString() == "1") || (row["Sex"].ToString().ToLower() == "true"))
{
model.Sex = true;
}
else
{
model.Sex = false;
}
}
if (row["Birthday"] != null && row["Birthday"].ToString() != "")
{
model.Birthday = DateTime.Parse(row["Birthday"].ToString());
}
if (row["Email"] != null)
{
model.Email = row["Email"].ToString();
}
if (row["Phone"] != null)
{
model.Phone = row["Phone"].ToString();
}
if (row["ImageUrl"] != null)
{
model.ImageUrl = row["ImageUrl"].ToString();
}
if (row["IsDeleted"] != null && row["IsDeleted"].ToString() != "")
{
if ((row["IsDeleted"].ToString() == "1") || (row["IsDeleted"].ToString().ToLower() == "true"))
{
model.IsDeleted = true;
}
else
{
model.IsDeleted = false;
}
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["DeleteTime"] != null && row["DeleteTime"].ToString() != "")
{
model.DeleteTime = DateTime.Parse(row["DeleteTime"].ToString());
}
}
return model;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Sys_UserInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_UserInfo set ");
strSql.Append("UserName=@UserName,");
strSql.Append("Password=@Password,");
strSql.Append("NiName=@NiName,");
strSql.Append("Sex=@Sex,");
strSql.Append("Birthday=@Birthday,");
strSql.Append("Email=@Email,");
strSql.Append("Phone=@Phone,");
strSql.Append("ImageUrl=@ImageUrl,");
strSql.Append("IsDeleted=@IsDeleted,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("DeleteTime=@DeleteTime");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@UserName", SqlDbType.VarChar,50),
new SqlParameter("@Password", SqlDbType.VarChar,50),
new SqlParameter("@NiName", SqlDbType.NVarChar,50),
new SqlParameter("@Sex", SqlDbType.Bit,1),
new SqlParameter("@Birthday", SqlDbType.DateTime),
new SqlParameter("@Email", SqlDbType.VarChar,50),
new SqlParameter("@Phone", SqlDbType.VarChar,12),
new SqlParameter("@ImageUrl", SqlDbType.VarChar,100),
new SqlParameter("@IsDeleted", SqlDbType.Bit,1),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@DeleteTime", SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.VarChar,38)};
parameters[0].Value = model.UserName;
parameters[1].Value = model.Password;
parameters[2].Value = model.NiName;
parameters[3].Value = model.Sex;
parameters[4].Value = model.Birthday;
parameters[5].Value = model.Email;
parameters[6].Value = model.Phone;
parameters[7].Value = model.ImageUrl;
parameters[8].Value = model.IsDeleted;
parameters[9].Value = model.CreateTime;
parameters[10].Value = model.DeleteTime;
parameters[11].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Sys_UserInfo GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,UserName,Password,NiName,Sex,Birthday,Email,Phone,ImageUrl,IsDeleted,CreateTime,DeleteTime from Sys_UserInfo ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.VarChar,38) };
parameters[0].Value = ID;
Sys_UserInfo model = new Sys_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;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Sys_UserInfo model)
{
return model==null?0:dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Sys_UserInfo model)
{
return dal.Update(model);
}