/// <summary>
/// 更新用户资料
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateUserInfo(Tz888.Model.UserInfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@LoginName", SqlDbType.Char, 16),
new SqlParameter("@RealName", SqlDbType.VarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 30),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@companyname", SqlDbType.VarChar, 100),
new SqlParameter("@QQMSN", SqlDbType.VarChar, 50),
new SqlParameter("@AuditMan", SqlDbType.VarChar, 30),
new SqlParameter("@AuditTime", SqlDbType.DateTime, 8),
new SqlParameter("@AuditStatus", SqlDbType.Int, 4),
new SqlParameter("@flag", SqlDbType.VarChar, 30)
};
parameters[0].Value = model.LoginName;
parameters[1].Value = model.RealName;
parameters[2].Value = model.Tel;
parameters[3].Value = model.Email;
parameters[4].Value = model.CompanyName;
parameters[5].Value = model.QQMSN;
parameters[6].Value = model.AuditMan;
parameters[7].Value = model.AuditTime;
parameters[8].Value = model.AuditStatus;
parameters[9].Value = "Update";
bool b = DbHelperSQL.RunProcLob("SP_UserInfo", parameters);
return(b);
}
/// <summary>
/// 用户详细信息
/// </summary>
public Tz888.Model.UserInfo GetModel(string UserName)
{
SqlParameter[] parameters =
{
new SqlParameter("@LoginName", SqlDbType.VarChar, 16),
new SqlParameter("@flag", SqlDbType.VarChar, 30)
};
parameters[0].Value = UserName;
parameters[1].Value = "Select";
Tz888.Model.UserInfo model = new Tz888.Model.UserInfo();
DataSet ds = DbHelperSQL.RunProcedure("SP_UserInfo", parameters, "ds");
model.LoginName = UserName;
if (ds.Tables[0].Rows.Count > 0)
{
model.CompanyName = ds.Tables[0].Rows[0]["CompanyName"].ToString();
model.RealName = ds.Tables[0].Rows[0]["RealName"].ToString();
model.Tel = ds.Tables[0].Rows[0]["Tel"].ToString();
model.QQMSN = ds.Tables[0].Rows[0]["QQMSN"].ToString();
model.Email = ds.Tables[0].Rows[0]["Email"].ToString();
if (ds.Tables[0].Rows[0]["AuditMan"].ToString() != "")
{
model.AuditMan = ds.Tables[0].Rows[0]["AuditMan"].ToString();
}
if (ds.Tables[0].Rows[0]["AuditTime"].ToString() != "")
{
model.AuditTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["AuditTime"].ToString());
}
if (ds.Tables[0].Rows[0]["AuditStatus"].ToString() != "")
{
model.AuditStatus = Convert.ToInt32(ds.Tables[0].Rows[0]["AuditStatus"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Tz888.Model.UserInfo model)
{
SHA1 sha1 = SHA1.Create();
byte[] bytePassword = sha1.ComputeHash(model.Password);
SqlParameter[] parameters =
{
new SqlParameter("@LoginName", SqlDbType.Char, 16),
new SqlParameter("@Password", SqlDbType.VarBinary, 50),
new SqlParameter("@RoleName", SqlDbType.Char, 10),
new SqlParameter("@IsCheckUp", SqlDbType.Bit, 1),
new SqlParameter("@MemberGradeID", SqlDbType.Char, 10),
new SqlParameter("@RealName", SqlDbType.VarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 30),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@companyname", SqlDbType.VarChar, 100),
new SqlParameter("@QQMSN", SqlDbType.VarChar, 50),
new SqlParameter("@flag", SqlDbType.VarChar, 30)
};
parameters[0].Value = model.LoginName;
parameters[1].Value = bytePassword;
parameters[2].Value = model.RoleName;
parameters[3].Value = model.IsCheckUp;
parameters[4].Value = model.MemberGradeID;
parameters[5].Value = model.RealName;
parameters[6].Value = model.Tel;
parameters[7].Value = model.Email;
parameters[8].Value = model.CompanyName;
parameters[9].Value = model.QQMSN;
parameters[10].Value = "Insert";
bool b = DbHelperSQL.RunProcLob("SP_UserInfo", parameters);
return(b);
}
