public string getgrade(int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@id", SqlDbType.Int);
parameters[0].Value = id;
string dt;
dt = DAL.SelectDataString("getgrade", parameters);
DAL.Close();
return(dt);
}
//GetGuardianNationIdStd
public string GetGuardianNationIdStd(int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@id", SqlDbType.Int);
parameters[0].Value = id;
string dt;
dt = DAL.SelectDataString("GetGuardianNationIdStd", parameters);
DAL.Close();
return(dt);
}
public string GetUserTypeByName(string name)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@name", SqlDbType.NVarChar, 100);
parameters[0].Value = name;
string dt;
dt = DAL.SelectDataString("GetUserTypeByName", parameters);
DAL.Close();
return(dt);
}
//GetDeptFromAccount
public String GetDeptFromAccount(int id)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@id", SqlDbType.Int);
parameters[0].Value = id;
String dt;
dt = DAL.SelectDataString("GetDeptFromAccount", parameters);
DAL.Close();
return(dt);
}
public String get_code4from_account(string code)
{
DAL.DataAccessLayer DAL = new DAL.DataAccessLayer();
DAL.Open();
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter("@code", SqlDbType.NVarChar, 100);
parameters[0].Value = code;
String dt;
dt = DAL.SelectDataString("get_code4from_account", parameters);
DAL.Close();
return(dt);
}
