public DataTable Get(DM_KhoiKienThucInfo pDM_KhoiKienThucInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_KhoiKienThuc_GetResult>(client.cDDM_KhoiKienThuc_Get(GlobalVar.MaXacThuc, pDM_KhoiKienThucInfo)));
}
}
public List <DM_KhoiKienThucInfo> GetList(DM_KhoiKienThucInfo pDM_KhoiKienThucInfo)
{
List <DM_KhoiKienThucInfo> oDM_KhoiKienThucInfoList = new List <DM_KhoiKienThucInfo>();
DataTable dtb = Get(pDM_KhoiKienThucInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_KhoiKienThucInfo = new DM_KhoiKienThucInfo();
oDM_KhoiKienThucInfo.DM_KhoiKienThucID = int.Parse(dtb.Rows[i]["DM_KhoiKienThucID"].ToString());
oDM_KhoiKienThucInfo.MaKhoiKienThuc = dtb.Rows[i]["MaKhoiKienThuc"].ToString();
oDM_KhoiKienThucInfo.TenKhoiKienThuc = dtb.Rows[i]["TenKhoiKienThuc"].ToString();
oDM_KhoiKienThucInfo.ParentID = int.Parse(dtb.Rows[i]["ParentID"].ToString());
oDM_KhoiKienThucInfo.SoHocPhanPhaiChon = int.Parse(dtb.Rows[i]["SoHocPhanPhaiChon"].ToString());
oDM_KhoiKienThucInfo.KhoaLuanTotNghiep = bool.Parse(dtb.Rows[i]["KhoaLuanTotNghiep"].ToString());
oDM_KhoiKienThucInfo.SapXep = int.Parse(dtb.Rows[i]["SapXep"].ToString());
oDM_KhoiKienThucInfoList.Add(oDM_KhoiKienThucInfo);
}
}
return(oDM_KhoiKienThucInfoList);
}
public void Delete(DM_KhoiKienThucInfo pDM_KhoiKienThucInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_KhoiKienThucID", SqlDbType.Int, pDM_KhoiKienThucInfo.DM_KhoiKienThucID));
RunProcedure("sp_DM_KhoiKienThuc_Delete", colParam);
}
public DataTable Get(DM_KhoiKienThucInfo pDM_KhoiKienThucInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_KhoiKienThucID", SqlDbType.Int, pDM_KhoiKienThucInfo.DM_KhoiKienThucID));
return(RunProcedureGet("sp_DM_KhoiKienThuc_Get", colParam));
}
public void Delete(DM_KhoiKienThucInfo pDM_KhoiKienThucInfo)
{
var client = new UnimOsServiceClient();
client.cDDM_KhoiKienThuc_Delete(GlobalVar.MaXacThuc, pDM_KhoiKienThucInfo);
client.Close();
mErrorMessage = oDDM_KhoiKienThuc.ErrorMessages;
mErrorNumber = oDDM_KhoiKienThuc.ErrorNumber;
}
public int Add(DM_KhoiKienThucInfo pDM_KhoiKienThucInfo)
{
int ID = 0;
ID = oDDM_KhoiKienThuc.Add(pDM_KhoiKienThucInfo);
mErrorMessage = oDDM_KhoiKienThuc.ErrorMessages;
mErrorNumber = oDDM_KhoiKienThuc.ErrorNumber;
return(ID);
}
public int Add(DM_KhoiKienThucInfo pDM_KhoiKienThucInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDDM_KhoiKienThuc_Add(GlobalVar.MaXacThuc, pDM_KhoiKienThucInfo);
client.Close();
mErrorMessage = oDDM_KhoiKienThuc.ErrorMessages;
mErrorNumber = oDDM_KhoiKienThuc.ErrorNumber;
return(ID);
}
public void Update(DM_KhoiKienThucInfo pDM_KhoiKienThucInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaKhoiKienThuc", SqlDbType.NVarChar, pDM_KhoiKienThucInfo.MaKhoiKienThuc));
colParam.Add(CreateParam("@TenKhoiKienThuc", SqlDbType.NVarChar, pDM_KhoiKienThucInfo.TenKhoiKienThuc));
colParam.Add(CreateParam("@ParentID", SqlDbType.Int, pDM_KhoiKienThucInfo.ParentID));
colParam.Add(CreateParam("@SoHocPhanPhaiChon", SqlDbType.Int, pDM_KhoiKienThucInfo.SoHocPhanPhaiChon));
colParam.Add(CreateParam("@KhoaLuanTotNghiep", SqlDbType.Bit, pDM_KhoiKienThucInfo.KhoaLuanTotNghiep));
colParam.Add(CreateParam("@SapXep", SqlDbType.Int, pDM_KhoiKienThucInfo.SapXep));
colParam.Add(CreateParam("@DM_KhoiKienThucID", SqlDbType.Int, pDM_KhoiKienThucInfo.DM_KhoiKienThucID));
RunProcedure("sp_DM_KhoiKienThuc_Update", colParam);
}
public int Add(DM_KhoiKienThucInfo pDM_KhoiKienThucInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaKhoiKienThuc", SqlDbType.NVarChar, pDM_KhoiKienThucInfo.MaKhoiKienThuc));
colParam.Add(CreateParam("@TenKhoiKienThuc", SqlDbType.NVarChar, pDM_KhoiKienThucInfo.TenKhoiKienThuc));
colParam.Add(CreateParam("@ParentID", SqlDbType.Int, pDM_KhoiKienThucInfo.ParentID));
colParam.Add(CreateParam("@SoHocPhanPhaiChon", SqlDbType.Int, pDM_KhoiKienThucInfo.SoHocPhanPhaiChon));
colParam.Add(CreateParam("@KhoaLuanTotNghiep", SqlDbType.Bit, pDM_KhoiKienThucInfo.KhoaLuanTotNghiep));
colParam.Add(CreateParam("@SapXep", SqlDbType.Int, pDM_KhoiKienThucInfo.SapXep));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_KhoiKienThuc_Add", colParam));
}
public void Delete(DM_KhoiKienThucInfo pDM_KhoiKienThucInfo)
{
oDDM_KhoiKienThuc.Delete(pDM_KhoiKienThucInfo);
mErrorMessage = oDDM_KhoiKienThuc.ErrorMessages;
mErrorNumber = oDDM_KhoiKienThuc.ErrorNumber;
}
public DataTable Get(DM_KhoiKienThucInfo pDM_KhoiKienThucInfo)
{
return(oDDM_KhoiKienThuc.Get(pDM_KhoiKienThucInfo));
}
