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); } }