public DataTable Get(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_ThamSoQuyCheID", SqlDbType.Int, pKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID));
return(RunProcedureGet("sp_KQHT_ThamSoQuyChe_Get", colParam));
}
public void Delete(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_ThamSoQuyCheID", SqlDbType.Int, pKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID));
RunProcedure("sp_KQHT_ThamSoQuyChe_Delete", colParam);
}
public void ToDataRow(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo, ref DataRow dr)
{
dr[pKQHT_ThamSoQuyCheInfo.strKQHT_ThamSoQuyCheID] = pKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID;
dr[pKQHT_ThamSoQuyCheInfo.strMaThamSo] = pKQHT_ThamSoQuyCheInfo.MaThamSo;
dr[pKQHT_ThamSoQuyCheInfo.strTenThamSo] = pKQHT_ThamSoQuyCheInfo.TenThamSo;
dr[pKQHT_ThamSoQuyCheInfo.strGiaTriMacDinh] = pKQHT_ThamSoQuyCheInfo.GiaTriMacDinh;
dr[pKQHT_ThamSoQuyCheInfo.strKieuTruong] = pKQHT_ThamSoQuyCheInfo.KieuTruong;
}
public void ToInfo(ref KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo, DataRow dr)
{
pKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID = int.Parse(dr[pKQHT_ThamSoQuyCheInfo.strKQHT_ThamSoQuyCheID].ToString());
pKQHT_ThamSoQuyCheInfo.MaThamSo = dr[pKQHT_ThamSoQuyCheInfo.strMaThamSo].ToString();
pKQHT_ThamSoQuyCheInfo.TenThamSo = dr[pKQHT_ThamSoQuyCheInfo.strTenThamSo].ToString();
pKQHT_ThamSoQuyCheInfo.GiaTriMacDinh = dr[pKQHT_ThamSoQuyCheInfo.strGiaTriMacDinh].ToString();
pKQHT_ThamSoQuyCheInfo.KieuTruong = dr[pKQHT_ThamSoQuyCheInfo.strKieuTruong].ToString();
}
public int Add(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo)
{
int ID = 0;
ID = oDKQHT_ThamSoQuyChe.Add(pKQHT_ThamSoQuyCheInfo);
mErrorMessage = oDKQHT_ThamSoQuyChe.ErrorMessages;
mErrorNumber = oDKQHT_ThamSoQuyChe.ErrorNumber;
return(ID);
}
public void Update(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaThamSo", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.MaThamSo));
colParam.Add(CreateParam("@TenThamSo", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.TenThamSo));
colParam.Add(CreateParam("@GiaTriMacDinh", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.GiaTriMacDinh));
colParam.Add(CreateParam("@KieuTruong", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.KieuTruong));
colParam.Add(CreateParam("@KQHT_ThamSoQuyCheID", SqlDbType.Int, pKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID));
RunProcedure("sp_KQHT_ThamSoQuyChe_Update", colParam);
}
public int Add(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaThamSo", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.MaThamSo));
colParam.Add(CreateParam("@TenThamSo", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.TenThamSo));
colParam.Add(CreateParam("@GiaTriMacDinh", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.GiaTriMacDinh));
colParam.Add(CreateParam("@KieuTruong", SqlDbType.NVarChar, pKQHT_ThamSoQuyCheInfo.KieuTruong));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_ThamSoQuyChe_Add", colParam));
}
public List <KQHT_ThamSoQuyCheInfo> GetList(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo)
{
List <KQHT_ThamSoQuyCheInfo> oKQHT_ThamSoQuyCheInfoList = new List <KQHT_ThamSoQuyCheInfo>();
DataTable dtb = Get(pKQHT_ThamSoQuyCheInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_ThamSoQuyCheInfo = new KQHT_ThamSoQuyCheInfo();
oKQHT_ThamSoQuyCheInfo.KQHT_ThamSoQuyCheID = int.Parse(dtb.Rows[i]["KQHT_ThamSoQuyCheID"].ToString());
oKQHT_ThamSoQuyCheInfo.MaThamSo = dtb.Rows[i]["MaThamSo"].ToString();
oKQHT_ThamSoQuyCheInfo.TenThamSo = dtb.Rows[i]["TenThamSo"].ToString();
oKQHT_ThamSoQuyCheInfo.GiaTriMacDinh = dtb.Rows[i]["GiaTriMacDinh"].ToString();
oKQHT_ThamSoQuyCheInfo.KieuTruong = dtb.Rows[i]["KieuTruong"].ToString();
oKQHT_ThamSoQuyCheInfoList.Add(oKQHT_ThamSoQuyCheInfo);
}
}
return(oKQHT_ThamSoQuyCheInfoList);
}
public void Delete(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo)
{
oDKQHT_ThamSoQuyChe.Delete(pKQHT_ThamSoQuyCheInfo);
mErrorMessage = oDKQHT_ThamSoQuyChe.ErrorMessages;
mErrorNumber = oDKQHT_ThamSoQuyChe.ErrorNumber;
}
public DataTable Get(KQHT_ThamSoQuyCheInfo pKQHT_ThamSoQuyCheInfo)
{
return(oDKQHT_ThamSoQuyChe.Get(pKQHT_ThamSoQuyCheInfo));
}
public frmThamSoQuyChe()
{
InitializeComponent();
pKQHT_ThamSoQuyCheInfo = new KQHT_ThamSoQuyCheInfo();
oBKQHT_ThamSoQuyChe = new cBKQHT_ThamSoQuyChe();
}
