public DataTable Get(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_HT_ThongTinTruong_GetResult>(client.cDHT_ThongTinTruong_Get(GlobalVar.MaXacThuc, pHT_ThongTinTruongInfo)));
}
}
public frmThongTinTruong()
{
InitializeComponent();
oBHT_ThongTinTruong = new cBHT_ThongTinTruong();
pHT_ThongTinTruongInfo = new HT_ThongTinTruongInfo();
pnThongTin.Visible = false;
}
public void ToInfo(ref HT_ThongTinTruongInfo pHT_ThongTinTruongInfo, DataRow dr)
{
pHT_ThongTinTruongInfo.HT_ThongTinTruongID = int.Parse(dr[pHT_ThongTinTruongInfo.strHT_ThongTinTruongID].ToString());
pHT_ThongTinTruongInfo.MaThongTin = dr[pHT_ThongTinTruongInfo.strMaThongTin].ToString();
pHT_ThongTinTruongInfo.TenThongTin = dr[pHT_ThongTinTruongInfo.strTenThongTin].ToString();
pHT_ThongTinTruongInfo.GiaTri = dr[pHT_ThongTinTruongInfo.strGiaTri].ToString();
pHT_ThongTinTruongInfo.SapXep = int.Parse(dr[pHT_ThongTinTruongInfo.strSapXep].ToString());
}
public void ToDataRow(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo, ref DataRow dr)
{
dr[pHT_ThongTinTruongInfo.strHT_ThongTinTruongID] = pHT_ThongTinTruongInfo.HT_ThongTinTruongID;
dr[pHT_ThongTinTruongInfo.strMaThongTin] = pHT_ThongTinTruongInfo.MaThongTin;
dr[pHT_ThongTinTruongInfo.strTenThongTin] = pHT_ThongTinTruongInfo.TenThongTin;
dr[pHT_ThongTinTruongInfo.strGiaTri] = pHT_ThongTinTruongInfo.GiaTri;
dr[pHT_ThongTinTruongInfo.strSapXep] = pHT_ThongTinTruongInfo.SapXep;
}
public void Delete(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_ThongTinTruongID", SqlDbType.Int, pHT_ThongTinTruongInfo.HT_ThongTinTruongID));
RunProcedure("sp_HT_ThongTinTruong_Delete", colParam);
}
public DataTable Get(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_ThongTinTruongID", SqlDbType.Int, pHT_ThongTinTruongInfo.HT_ThongTinTruongID));
return(RunProcedureGet("sp_HT_ThongTinTruong_Get", colParam));
}
public int Add(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
int ID = 0;
ID = oDHT_ThongTinTruong.Add(pHT_ThongTinTruongInfo);
mErrorMessage = oDHT_ThongTinTruong.ErrorMessages;
mErrorNumber = oDHT_ThongTinTruong.ErrorNumber;
return(ID);
}
public void Delete(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
var client = new UnimOsServiceClient();
client.cDHT_ThongTinTruong_Delete(GlobalVar.MaXacThuc, pHT_ThongTinTruongInfo);
client.Close();
mErrorMessage = oDHT_ThongTinTruong.ErrorMessages;
mErrorNumber = oDHT_ThongTinTruong.ErrorNumber;
}
public int Add(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDHT_ThongTinTruong_Add(GlobalVar.MaXacThuc, pHT_ThongTinTruongInfo);
client.Close();
mErrorMessage = oDHT_ThongTinTruong.ErrorMessages;
mErrorNumber = oDHT_ThongTinTruong.ErrorNumber;
return(ID);
}
public void Update(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaThongTin", SqlDbType.NVarChar, pHT_ThongTinTruongInfo.MaThongTin));
colParam.Add(CreateParam("@TenThongTin", SqlDbType.NVarChar, pHT_ThongTinTruongInfo.TenThongTin));
colParam.Add(CreateParam("@GiaTri", SqlDbType.NVarChar, pHT_ThongTinTruongInfo.GiaTri));
colParam.Add(CreateParam("@SapXep", SqlDbType.Int, pHT_ThongTinTruongInfo.SapXep));
colParam.Add(CreateParam("@HT_ThongTinTruongID", SqlDbType.Int, pHT_ThongTinTruongInfo.HT_ThongTinTruongID));
RunProcedure("sp_HT_ThongTinTruong_Update", colParam);
}
public int Add(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaThongTin", SqlDbType.NVarChar, pHT_ThongTinTruongInfo.MaThongTin));
colParam.Add(CreateParam("@TenThongTin", SqlDbType.NVarChar, pHT_ThongTinTruongInfo.TenThongTin));
colParam.Add(CreateParam("@GiaTri", SqlDbType.NVarChar, pHT_ThongTinTruongInfo.GiaTri));
colParam.Add(CreateParam("@SapXep", SqlDbType.Int, pHT_ThongTinTruongInfo.SapXep));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_HT_ThongTinTruong_Add", colParam));
}
public List <HT_ThongTinTruongInfo> GetList(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
List <HT_ThongTinTruongInfo> oHT_ThongTinTruongInfoList = new List <HT_ThongTinTruongInfo>();
DataTable dtb = Get(pHT_ThongTinTruongInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oHT_ThongTinTruongInfo = new HT_ThongTinTruongInfo();
oHT_ThongTinTruongInfo.HT_ThongTinTruongID = int.Parse(dtb.Rows[i]["HT_ThongTinTruongID"].ToString());
oHT_ThongTinTruongInfo.MaThongTin = dtb.Rows[i]["MaThongTin"].ToString();
oHT_ThongTinTruongInfo.TenThongTin = dtb.Rows[i]["TenThongTin"].ToString();
oHT_ThongTinTruongInfo.GiaTri = dtb.Rows[i]["GiaTri"].ToString();
oHT_ThongTinTruongInfo.SapXep = int.Parse(dtb.Rows[i]["SapXep"].ToString());
oHT_ThongTinTruongInfoList.Add(oHT_ThongTinTruongInfo);
}
}
return(oHT_ThongTinTruongInfoList);
}
public void Delete(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
oDHT_ThongTinTruong.Delete(pHT_ThongTinTruongInfo);
mErrorMessage = oDHT_ThongTinTruong.ErrorMessages;
mErrorNumber = oDHT_ThongTinTruong.ErrorNumber;
}
public DataTable Get(HT_ThongTinTruongInfo pHT_ThongTinTruongInfo)
{
return(oDHT_ThongTinTruong.Get(pHT_ThongTinTruongInfo));
}