public int Them(Sach_TheLoai s_tl)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MASACH, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_MATHELOAI, SqlDbType.NVarChar, 30)
};
parm[0].Value = s_tl.MaSach;
parm[1].Value = s_tl.MaTheLoai;
return(DALHelper.ExecuteNonQuery(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblSach_TheLoai_Them", parm));
}
public List <Sach_TheLoai> DSSach_TheLoai()
{
SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblSach_TheLoai_DS", null);
List <Sach_TheLoai> mylist = new List <Sach_TheLoai>();
while (d.Read())
{
Sach_TheLoai s_tl = new Sach_TheLoai();
s_tl.MaSach = d[0].ToString();
s_tl.MaTheLoai = d[1].ToString();
mylist.Add(s_tl);
}
d.Dispose();
return(mylist);
}
public Sach_TheLoai LaySach_TheLoai(string Ma)
{
SqlParameter[] parm = new SqlParameter[]
{
new SqlParameter(PARM_MASACH, SqlDbType.NVarChar, 30),
new SqlParameter(PARM_MATHELOAI, SqlDbType.NVarChar, 30)
};
parm[0].Value = Ma;
SqlDataReader d = DALHelper.ExecuteReader(DALHelper.ConnectionString, CommandType.StoredProcedure, "tblSach_TheLoai_Lay1", parm);
Sach_TheLoai s_tl = new Sach_TheLoai();
if (d.Read())
{
s_tl.MaSach = d[0].ToString();
s_tl.MaTheLoai = d[1].ToString();
}
return(s_tl);
}
public static Sach_TheLoai Select_Sach_TheLoai(Struct.Sach_TheLoai.eSach_TheLoai type, string input)
{
Sach_TheLoai stl = new Sach_TheLoai();
if (GetDataSQL(@"select MaSach, MaTheLoai from Sach_TheLoai where " + type.ToString() + " = '" + input + "'"))
{
// đọc đến khi hết
if (reader.Read())
{
// lấy dữ liệu cột MaSach (cột 0)
stl.MaSach = reader.GetFieldValue <string>(0);
// lấy dữ liệu cột MaTheLoai (cột 1)
stl.MaTheLoai = reader.GetFieldValue <string>(1);
// lSach_TheLoai.Add(stl);
}
reader.Close();
commandSQL.Dispose();
connSQL.Close();
}
return(stl);
}
public int Them(Sach_TheLoai stl)
{
return(s_tldal.Them(stl));
}
