public void ToDataRow(DM_KhoaInfo pDM_KhoaInfo, ref DataRow dr)
{
dr[pDM_KhoaInfo.strDM_KhoaID] = pDM_KhoaInfo.DM_KhoaID;
dr[pDM_KhoaInfo.strMaKhoa] = pDM_KhoaInfo.MaKhoa;
dr[pDM_KhoaInfo.strTenKhoa] = pDM_KhoaInfo.TenKhoa;
dr[pDM_KhoaInfo.strTenKhoa_E] = pDM_KhoaInfo.TenKhoa_E;
}
public DataTable Get(DM_KhoaInfo pDM_KhoaInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_Khoa_GetResult>(client.cDDM_Khoa_Get(GlobalVar.MaXacThuc, pDM_KhoaInfo)));
}
}
public void Delete(DM_KhoaInfo pDM_KhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_KhoaID", SqlDbType.Int, pDM_KhoaInfo.DM_KhoaID));
RunProcedure("sp_DM_Khoa_Delete", colParam);
}
public DataTable Get(DM_KhoaInfo pDM_KhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_KhoaID", SqlDbType.Int, pDM_KhoaInfo.DM_KhoaID));
return(RunProcedureGet("sp_DM_Khoa_Get", colParam));
}
public frmKhoaBoMon()
{
InitializeComponent();
oBDM_Khoa = new cBDM_Khoa();
oBDM_BoMon = new cBDM_BoMon();
pDM_KhoaInfo = new DM_KhoaInfo();
pDM_BoMonInfo = new DM_BoMonInfo();
panelTop.Visible = false;
}
public int Add(DM_KhoaInfo pDM_KhoaInfo)
{
int ID = 0;
ID = oDDM_Khoa.Add(pDM_KhoaInfo);
mErrorMessage = oDDM_Khoa.ErrorMessages;
mErrorNumber = oDDM_Khoa.ErrorNumber;
return(ID);
}
public void Update(DM_KhoaInfo pDM_KhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaKhoa", SqlDbType.NVarChar, pDM_KhoaInfo.MaKhoa));
colParam.Add(CreateParam("@TenKhoa", SqlDbType.NVarChar, pDM_KhoaInfo.TenKhoa));
colParam.Add(CreateParam("@TenKhoa_E", SqlDbType.NVarChar, pDM_KhoaInfo.TenKhoa_E));
colParam.Add(CreateParam("@DM_KhoaID", SqlDbType.Int, pDM_KhoaInfo.DM_KhoaID));
RunProcedure("sp_DM_Khoa_Update", colParam);
}
public int Add(DM_KhoaInfo pDM_KhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaKhoa", SqlDbType.NVarChar, pDM_KhoaInfo.MaKhoa));
colParam.Add(CreateParam("@TenKhoa", SqlDbType.NVarChar, pDM_KhoaInfo.TenKhoa));
colParam.Add(CreateParam("@TenKhoa_E", SqlDbType.NVarChar, pDM_KhoaInfo.TenKhoa_E));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_Khoa_Add", colParam));
}
public List <DM_KhoaInfo> GetList(DM_KhoaInfo pDM_KhoaInfo)
{
List <DM_KhoaInfo> oDM_KhoaInfoList = new List <DM_KhoaInfo>();
DataTable dtb = Get(pDM_KhoaInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_KhoaInfo = new DM_KhoaInfo();
oDM_KhoaInfo.DM_KhoaID = int.Parse(dtb.Rows[i]["DM_KhoaID"].ToString());
oDM_KhoaInfo.MaKhoa = dtb.Rows[i]["MaKhoa"].ToString();
oDM_KhoaInfo.TenKhoa = dtb.Rows[i]["TenKhoa"].ToString();
oDM_KhoaInfo.TenKhoa_E = dtb.Rows[i]["TenKhoa_E"].ToString();
oDM_KhoaInfoList.Add(oDM_KhoaInfo);
}
}
return(oDM_KhoaInfoList);
}
public void Delete(DM_KhoaInfo pDM_KhoaInfo)
{
oDDM_Khoa.Delete(pDM_KhoaInfo);
mErrorMessage = oDDM_Khoa.ErrorMessages;
mErrorNumber = oDDM_Khoa.ErrorNumber;
}
public DataTable Get(DM_KhoaInfo pDM_KhoaInfo)
{
return(oDDM_Khoa.Get(pDM_KhoaInfo));
}
