public List <XL_BaoBanPhongHocInfo> GetList(XL_BaoBanPhongHocInfo pXL_BaoBanPhongHocInfo)
{
List <XL_BaoBanPhongHocInfo> oXL_BaoBanPhongHocInfoList = new List <XL_BaoBanPhongHocInfo>();
DataTable dtb = Get(pXL_BaoBanPhongHocInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oXL_BaoBanPhongHocInfo = new XL_BaoBanPhongHocInfo();
oXL_BaoBanPhongHocInfo.XL_BaoBanPhongHocID = int.Parse(dtb.Rows[i]["XL_BaoBanPhongHocID"].ToString());
oXL_BaoBanPhongHocInfo.IDTuan = long.Parse(dtb.Rows[i]["IDTuan"].ToString());
oXL_BaoBanPhongHocInfo.IDXL_PhongHoc = int.Parse(dtb.Rows[i]["IDXL_PhongHoc"].ToString());
oXL_BaoBanPhongHocInfo.Thu = int.Parse(dtb.Rows[i]["Thu"].ToString());
oXL_BaoBanPhongHocInfo.Tiet = int.Parse(dtb.Rows[i]["Tiet"].ToString());
oXL_BaoBanPhongHocInfo.SoTiet = int.Parse(dtb.Rows[i]["SoTiet"].ToString());
oXL_BaoBanPhongHocInfo.MoTa = dtb.Rows[i]["MoTa"].ToString();
oXL_BaoBanPhongHocInfoList.Add(oXL_BaoBanPhongHocInfo);
}
}
return(oXL_BaoBanPhongHocInfoList);
}
public void Delete(XL_BaoBanPhongHocInfo pXL_BaoBanPhongHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_BaoBanPhongHocID", SqlDbType.Int, pXL_BaoBanPhongHocInfo.XL_BaoBanPhongHocID));
RunProcedure("sp_XL_BaoBanPhongHoc_Delete", colParam);
}
public DataTable Get(XL_BaoBanPhongHocInfo pXL_BaoBanPhongHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@XL_BaoBanPhongHocID", SqlDbType.Int, pXL_BaoBanPhongHocInfo.XL_BaoBanPhongHocID));
return(RunProcedureGet("sp_XL_BaoBanPhongHoc_Get", colParam));
}
public int Add(XL_BaoBanPhongHocInfo pXL_BaoBanPhongHocInfo)
{
int ID = 0;
ID = oDXL_BaoBanPhongHoc.Add(pXL_BaoBanPhongHocInfo);
mErrorMessage = oDXL_BaoBanPhongHoc.ErrorMessages;
mErrorNumber = oDXL_BaoBanPhongHoc.ErrorNumber;
return(ID);
}
public void Update(XL_BaoBanPhongHocInfo pXL_BaoBanPhongHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDTuan", SqlDbType.BigInt, pXL_BaoBanPhongHocInfo.IDTuan));
colParam.Add(CreateParam("@IDXL_PhongHoc", SqlDbType.Int, pXL_BaoBanPhongHocInfo.IDXL_PhongHoc));
colParam.Add(CreateParam("@Thu", SqlDbType.Int, pXL_BaoBanPhongHocInfo.Thu));
colParam.Add(CreateParam("@Tiet", SqlDbType.Int, pXL_BaoBanPhongHocInfo.Tiet));
colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pXL_BaoBanPhongHocInfo.SoTiet));
colParam.Add(CreateParam("@MoTa", SqlDbType.NVarChar, pXL_BaoBanPhongHocInfo.MoTa));
colParam.Add(CreateParam("@XL_BaoBanPhongHocID", SqlDbType.Int, pXL_BaoBanPhongHocInfo.XL_BaoBanPhongHocID));
RunProcedure("sp_XL_BaoBanPhongHoc_Update", colParam);
}
public int Add(XL_BaoBanPhongHocInfo pXL_BaoBanPhongHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDTuan", SqlDbType.BigInt, pXL_BaoBanPhongHocInfo.IDTuan));
colParam.Add(CreateParam("@IDXL_PhongHoc", SqlDbType.Int, pXL_BaoBanPhongHocInfo.IDXL_PhongHoc));
colParam.Add(CreateParam("@Thu", SqlDbType.Int, pXL_BaoBanPhongHocInfo.Thu));
colParam.Add(CreateParam("@Tiet", SqlDbType.Int, pXL_BaoBanPhongHocInfo.Tiet));
colParam.Add(CreateParam("@SoTiet", SqlDbType.Int, pXL_BaoBanPhongHocInfo.SoTiet));
colParam.Add(CreateParam("@MoTa", SqlDbType.NVarChar, pXL_BaoBanPhongHocInfo.MoTa));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_XL_BaoBanPhongHoc_Add", colParam));
}
public void Delete(XL_BaoBanPhongHocInfo pXL_BaoBanPhongHocInfo)
{
oDXL_BaoBanPhongHoc.Delete(pXL_BaoBanPhongHocInfo);
mErrorMessage = oDXL_BaoBanPhongHoc.ErrorMessages;
mErrorNumber = oDXL_BaoBanPhongHoc.ErrorNumber;
}
public DataTable Get(XL_BaoBanPhongHocInfo pXL_BaoBanPhongHocInfo)
{
return(oDXL_BaoBanPhongHoc.Get(pXL_BaoBanPhongHocInfo));
}
