public void LoadBase(DataRow rows, BASE_USER bASE_USER1)
{
bASE_USER1.id = Convert.ToInt32(rows["id"]);
bASE_USER1.name = rows["name"] != null ? rows["name"].ToString() : string.Empty;
bASE_USER1.pwd = rows["password"] != null ? rows["password"].ToString() : string.Empty;
bASE_USER1.jurisdiction = Convert.ToInt32(rows["jurisdiction"]);
}
public BASE_USER selectBase(BASE_USER bASE_USER)
{
string str = "select * from BASE_USER where name=@name";
SqlParameter[] pars =
{
new SqlParameter("@name", SqlDbType.VarChar, 20),
};
pars[0].Value = bASE_USER.name;
DataTable da = SqlHelper.GetTable(str, CommandType.Text, pars);
BASE_USER bASE_USER1 = new BASE_USER();
if (da.Rows.Count > 0)
{
foreach (DataRow datarow in da.Rows)
{
LoadBase(datarow, bASE_USER1);
}
}
return(bASE_USER1);
}
public Boolean UPpwd(BASE_USER bASE_USER)
{
string str = "update BASE_USER set password =@password where name=@name ";
SqlParameter[] pars =
{
//new SqlParameter("@name", userInfo.UserName),
new SqlParameter("@password", SqlDbType.VarChar, 20),
new SqlParameter("@name", SqlDbType.VarChar, 20),
};
pars[0].Value = bASE_USER.pwd;
pars[1].Value = bASE_USER.name;
if (SqlHelper.GetExecuteNonQuery(str, CommandType.Text, pars) > 0)
{
return(true);
}
else
{
return(false);
}
}
public Boolean login(BASE_USER bASE_USER)
{
string str = "select * from BASE_USER where name=@name and password=@password";
//sql 语句中的替换
SqlParameter[] pars =
{
//new SqlParameter("@name", userInfo.UserName),
new SqlParameter("@name", SqlDbType.VarChar, 20),
new SqlParameter("@password", SqlDbType.VarChar, 20),
};
pars[0].Value = bASE_USER.name;
pars[1].Value = bASE_USER.pwd;
DataTable da = SqlHelper.GetTable(str, CommandType.Text, pars);
if (da.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
