public void Delete(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@GG_HeSoTheoTrinhDoID", SqlDbType.Int, pGG_HeSoTheoTrinhDoInfo.GG_HeSoTheoTrinhDoID));
RunProcedure("sp_GG_HeSoTheoTrinhDo_Delete", colParam);
}
public frmHeSoGioGiang()
{
InitializeComponent();
oBGG_HeSoTrinhDo = new cBGG_HeSoTheoTrinhDo();
pGG_HeSoTrinhDoInfo = new GG_HeSoTheoTrinhDoInfo();
groupTop.Visible = false;
SetControl(false);
}
public DataTable Get(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@GG_HeSoTheoTrinhDoID", SqlDbType.Int, pGG_HeSoTheoTrinhDoInfo.GG_HeSoTheoTrinhDoID));
return(RunProcedureGet("sp_GG_HeSoTheoTrinhDo_Get", colParam));
}
public void ToInfo(ref GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo, DataRow dr)
{
pGG_HeSoTheoTrinhDoInfo.GG_HeSoTheoTrinhDoID = int.Parse(dr[pGG_HeSoTheoTrinhDoInfo.strGG_HeSoTheoTrinhDoID].ToString());
pGG_HeSoTheoTrinhDoInfo.LoaiGiangDay = dr[pGG_HeSoTheoTrinhDoInfo.strLoaiGiangDay].ToString();
pGG_HeSoTheoTrinhDoInfo.IDDM_TrinhDo = int.Parse(dr[pGG_HeSoTheoTrinhDoInfo.strIDDM_TrinhDo].ToString());
pGG_HeSoTheoTrinhDoInfo.TuSo = int.Parse(dr[pGG_HeSoTheoTrinhDoInfo.strTuSo].ToString());
pGG_HeSoTheoTrinhDoInfo.DenSo = int.Parse(dr[pGG_HeSoTheoTrinhDoInfo.strDenSo].ToString());
pGG_HeSoTheoTrinhDoInfo.HeSo = double.Parse(dr[pGG_HeSoTheoTrinhDoInfo.strHeSo].ToString());
}
//public int Add(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
//{
// int ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDGG_HeSoTheoTrinhDo_Add(GlobalVar.MaXacThuc, pGG_HeSoTheoTrinhDoInfo);
// client.Close();
// mErrorMessage = oDGG_HeSoTheoTrinhDo.ErrorMessages;
// mErrorNumber = oDGG_HeSoTheoTrinhDo.ErrorNumber;
// return ID;
//}
//public void Update(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDGG_HeSoTheoTrinhDo_Update(GlobalVar.MaXacThuc, pGG_HeSoTheoTrinhDoInfo);
// client.Close();
// mErrorMessage = oDGG_HeSoTheoTrinhDo.ErrorMessages;
// mErrorNumber = oDGG_HeSoTheoTrinhDo.ErrorNumber;
//}
//public void Delete(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDGG_HeSoTheoTrinhDo_Delete(GlobalVar.MaXacThuc, pGG_HeSoTheoTrinhDoInfo);
// client.Close();
// mErrorMessage = oDGG_HeSoTheoTrinhDo.ErrorMessages;
// mErrorNumber = oDGG_HeSoTheoTrinhDo.ErrorNumber;
//}
//public List<GG_HeSoTheoTrinhDoInfo> GetList(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
//{
// List<GG_HeSoTheoTrinhDoInfo> oGG_HeSoTheoTrinhDoInfoList = new List<GG_HeSoTheoTrinhDoInfo>();
// DataTable dtb = Get(pGG_HeSoTheoTrinhDoInfo);
// if (dtb != null)
// {
// for (int i = 0; i < dtb.Rows.Count; i++)
// {
// pGG_HeSoTheoTrinhDoInfo = new GG_HeSoTheoTrinhDoInfo();
// pGG_HeSoTheoTrinhDoInfo.GG_HeSoTheoTrinhDoID = int.Parse(dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strGG_HeSoTheoTrinhDoID].ToString());
// pGG_HeSoTheoTrinhDoInfo.LoaiGiangDay = dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strLoaiGiangDay].ToString();
// pGG_HeSoTheoTrinhDoInfo.IDDM_TrinhDo = int.Parse(dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strIDDM_TrinhDo].ToString());
// pGG_HeSoTheoTrinhDoInfo.TuSo = int.Parse(dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strTuSo].ToString());
// pGG_HeSoTheoTrinhDoInfo.DenSo = int.Parse(dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strDenSo].ToString());
// pGG_HeSoTheoTrinhDoInfo.HeSo = double.Parse(dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strHeSo].ToString());
// oGG_HeSoTheoTrinhDoInfoList.Add(pGG_HeSoTheoTrinhDoInfo);
// }
// }
// return oGG_HeSoTheoTrinhDoInfoList;
//}
public void ToDataRow(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo, ref DataRow dr)
{
dr[pGG_HeSoTheoTrinhDoInfo.strGG_HeSoTheoTrinhDoID] = pGG_HeSoTheoTrinhDoInfo.GG_HeSoTheoTrinhDoID;
dr[pGG_HeSoTheoTrinhDoInfo.strLoaiGiangDay] = pGG_HeSoTheoTrinhDoInfo.LoaiGiangDay;
dr[pGG_HeSoTheoTrinhDoInfo.strIDDM_TrinhDo] = pGG_HeSoTheoTrinhDoInfo.IDDM_TrinhDo;
dr[pGG_HeSoTheoTrinhDoInfo.strTuSo] = pGG_HeSoTheoTrinhDoInfo.TuSo;
dr[pGG_HeSoTheoTrinhDoInfo.strDenSo] = pGG_HeSoTheoTrinhDoInfo.DenSo;
dr[pGG_HeSoTheoTrinhDoInfo.strHeSo] = pGG_HeSoTheoTrinhDoInfo.HeSo;
}
public int Add(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
{
int ID = 0;
ID = oDGG_HeSoTheoTrinhDo.Add(pGG_HeSoTheoTrinhDoInfo);
mErrorMessage = oDGG_HeSoTheoTrinhDo.ErrorMessages;
mErrorNumber = oDGG_HeSoTheoTrinhDo.ErrorNumber;
return(ID);
}
public void Update(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@LoaiGiangDay", SqlDbType.NVarChar, pGG_HeSoTheoTrinhDoInfo.LoaiGiangDay));
colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pGG_HeSoTheoTrinhDoInfo.IDDM_TrinhDo));
colParam.Add(CreateParam("@TuSo", SqlDbType.Int, pGG_HeSoTheoTrinhDoInfo.TuSo));
colParam.Add(CreateParam("@DenSo", SqlDbType.Int, pGG_HeSoTheoTrinhDoInfo.DenSo));
colParam.Add(CreateParam("@HeSo", SqlDbType.Float, pGG_HeSoTheoTrinhDoInfo.HeSo));
colParam.Add(CreateParam("@GG_HeSoTheoTrinhDoID", SqlDbType.Int, pGG_HeSoTheoTrinhDoInfo.GG_HeSoTheoTrinhDoID));
RunProcedure("sp_GG_HeSoTheoTrinhDo_Update", colParam);
}
public int Add(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@LoaiGiangDay", SqlDbType.NVarChar, pGG_HeSoTheoTrinhDoInfo.LoaiGiangDay));
colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pGG_HeSoTheoTrinhDoInfo.IDDM_TrinhDo));
colParam.Add(CreateParam("@TuSo", SqlDbType.Int, pGG_HeSoTheoTrinhDoInfo.TuSo));
colParam.Add(CreateParam("@DenSo", SqlDbType.Int, pGG_HeSoTheoTrinhDoInfo.DenSo));
colParam.Add(CreateParam("@HeSo", SqlDbType.Float, pGG_HeSoTheoTrinhDoInfo.HeSo));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_GG_HeSoTheoTrinhDo_Add", colParam));
}
public List <GG_HeSoTheoTrinhDoInfo> GetList(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
{
List <GG_HeSoTheoTrinhDoInfo> oGG_HeSoTheoTrinhDoInfoList = new List <GG_HeSoTheoTrinhDoInfo>();
DataTable dtb = Get(pGG_HeSoTheoTrinhDoInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
pGG_HeSoTheoTrinhDoInfo = new GG_HeSoTheoTrinhDoInfo();
pGG_HeSoTheoTrinhDoInfo.GG_HeSoTheoTrinhDoID = int.Parse(dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strGG_HeSoTheoTrinhDoID].ToString());
pGG_HeSoTheoTrinhDoInfo.LoaiGiangDay = dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strLoaiGiangDay].ToString();
pGG_HeSoTheoTrinhDoInfo.IDDM_TrinhDo = int.Parse(dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strIDDM_TrinhDo].ToString());
pGG_HeSoTheoTrinhDoInfo.TuSo = int.Parse(dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strTuSo].ToString());
pGG_HeSoTheoTrinhDoInfo.DenSo = int.Parse(dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strDenSo].ToString());
pGG_HeSoTheoTrinhDoInfo.HeSo = double.Parse(dtb.Rows[i][pGG_HeSoTheoTrinhDoInfo.strHeSo].ToString());
oGG_HeSoTheoTrinhDoInfoList.Add(pGG_HeSoTheoTrinhDoInfo);
}
}
return(oGG_HeSoTheoTrinhDoInfoList);
}
public void Delete(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
{
oDGG_HeSoTheoTrinhDo.Delete(pGG_HeSoTheoTrinhDoInfo);
mErrorMessage = oDGG_HeSoTheoTrinhDo.ErrorMessages;
mErrorNumber = oDGG_HeSoTheoTrinhDo.ErrorNumber;
}
public DataTable Get(GG_HeSoTheoTrinhDoInfo pGG_HeSoTheoTrinhDoInfo)
{
return(oDGG_HeSoTheoTrinhDo.Get(pGG_HeSoTheoTrinhDoInfo));
}
