/// <summary>
/// 增加一条数据
/// </summary>
public static bool AddClientUser(FoodSafety.Model.sys_client_user model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into sys_client_user(");
strSql.Append("userId,userName,userPassword,deptId,cdate,roleId,cuserId,expired)");
strSql.Append(" values (");
strSql.Append("@userId,@userName,@userPassword,@deptId,@cdate,@roleId,@cuserId,@expired)");
MySqlParameter[] parameters =
{
new MySqlParameter("@userId", MySqlDbType.VarChar, 50),
new MySqlParameter("@userName", MySqlDbType.VarChar, 50),
new MySqlParameter("@userPassword", MySqlDbType.VarChar, 1),
new MySqlParameter("@deptId", MySqlDbType.VarChar, 50),
new MySqlParameter("@cdate", MySqlDbType.DateTime),
new MySqlParameter("@roleId", MySqlDbType.VarChar, 50),
new MySqlParameter("@cuserId", MySqlDbType.VarChar, 50),
new MySqlParameter("@expired", MySqlDbType.VarChar, 50)
};
parameters[0].Value = model.userId;
parameters[1].Value = model.userName;
parameters[2].Value = model.userPassword;
parameters[3].Value = model.deptId;
parameters[4].Value = model.cdate;
parameters[5].Value = model.roleId;
parameters[6].Value = model.cuserId;
parameters[7].Value = model.expired;
int rows = DbHelperMySQL.CreateDbHelper().ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public static DataTable GetUserModel(FoodSafety.Model.sys_client_user loginUser)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,userId,UserName,UserPassword,expired from sys_client_user ");
strSql.Append(" where userId=@userId and UserPassword=@Password");
MySqlParameter[] parameters =
{
new MySqlParameter("@userId", MySqlDbType.VarChar, 20),
new MySqlParameter("@Password", MySqlDbType.VarChar, 50)
};
parameters[0].Value = loginUser.userId;
parameters[1].Value = loginUser.userPassword;
try
{
return(DbHelperMySQL.CreateDbHelper().GetDataSet(strSql.ToString(), parameters).Tables[0]);
}
catch (Exception)
{
return(null);
}
}
public static DataTable GetUserModel(FoodSafety.Model.sys_client_user loginUser)
{
return(Sys_client_userDal.GetUserModel(loginUser));
}
public static bool AddClientUser(FoodSafety.Model.sys_client_user model)
{
return(Sys_client_userDal.AddClientUser(model));
}