public List <HT_ThamSoHeThongInfo> GetListByPhanHe(int PhanHe)
{
List <HT_ThamSoHeThongInfo> oHT_ThamSoHeThongInfoList = new List <HT_ThamSoHeThongInfo>();
DataTable dtb = GetByPhanHe(PhanHe);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oHT_ThamSoHeThongInfo = new HT_ThamSoHeThongInfo();
oHT_ThamSoHeThongInfo.HT_ThamSoHeThongID = int.Parse(dtb.Rows[i]["HT_ThamSoHeThongID"].ToString());
oHT_ThamSoHeThongInfo.MaThamSoHeThong = dtb.Rows[i]["MaThamSoHeThong"].ToString();
oHT_ThamSoHeThongInfo.TenThamSoHeThong = dtb.Rows[i]["TenThamSoHeThong"].ToString();
oHT_ThamSoHeThongInfo.PhanHe = int.Parse(dtb.Rows[i]["PhanHe"].ToString());
oHT_ThamSoHeThongInfo.GiaTri = dtb.Rows[i]["GiaTri"].ToString();
oHT_ThamSoHeThongInfo.GhiChu = dtb.Rows[i]["GhiChu"].ToString();
oHT_ThamSoHeThongInfo.TrangThai = bool.Parse(dtb.Rows[i]["TrangThai"].ToString());
oHT_ThamSoHeThongInfo.SapXep = int.Parse(dtb.Rows[i]["SapXep"].ToString());
oHT_ThamSoHeThongInfoList.Add(oHT_ThamSoHeThongInfo);
}
}
return(oHT_ThamSoHeThongInfoList);
}
public DataTable Get(HT_ThamSoHeThongInfo pHT_ThamSoHeThongInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_HT_ThamSoHeThong_GetResult>(client.cDHT_ThamSoHeThong_Get(GlobalVar.MaXacThuc, pHT_ThamSoHeThongInfo)));
}
}
public void Delete(HT_ThamSoHeThongInfo pHT_ThamSoHeThongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_ThamSoHeThongID", SqlDbType.Int, pHT_ThamSoHeThongInfo.HT_ThamSoHeThongID));
RunProcedure("sp_HT_ThamSoHeThong_Delete", colParam);
}
public DataTable Get(HT_ThamSoHeThongInfo pHT_ThamSoHeThongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@HT_ThamSoHeThongID", SqlDbType.Int, pHT_ThamSoHeThongInfo.HT_ThamSoHeThongID));
return(RunProcedureGet("sp_HT_ThamSoHeThong_Get", colParam));
}
private void DocThamSoXepLich()
{
// Đọc tham số hệ thống
HT_ThamSoHeThongInfo pThamSoHeThongInfo = new HT_ThamSoHeThongInfo();
pThamSoHeThongInfo.HT_ThamSoHeThongID = 0;
dtThamSo = new cBwsHT_ThamSoHeThong().Get(pThamSoHeThongInfo);
}
public int Add(HT_ThamSoHeThongInfo pHT_ThamSoHeThongInfo)
{
int ID = 0;
ID = oDHT_ThamSoHeThong.Add(pHT_ThamSoHeThongInfo);
mErrorMessage = oDHT_ThamSoHeThong.ErrorMessages;
mErrorNumber = oDHT_ThamSoHeThong.ErrorNumber;
return(ID);
}
public void DocThamSoXepLich()
{
// Đọc tham số hệ thống
HT_ThamSoHeThongInfo pThamSoHeThongInfo = new HT_ThamSoHeThongInfo();
pThamSoHeThongInfo.HT_ThamSoHeThongID = 0;
DataTable dtThamSo = new cBHT_ThamSoHeThong().Get(pThamSoHeThongInfo);
DocThamSoXepLich(dtThamSo);
}
public int Add(HT_ThamSoHeThongInfo pHT_ThamSoHeThongInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDHT_ThamSoHeThong_Add(GlobalVar.MaXacThuc, pHT_ThamSoHeThongInfo);
client.Close();
mErrorMessage = oDHT_ThamSoHeThong.ErrorMessages;
mErrorNumber = oDHT_ThamSoHeThong.ErrorNumber;
return(ID);
}
public void Update(HT_ThamSoHeThongInfo pHT_ThamSoHeThongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaThamSoHeThong", SqlDbType.NVarChar, pHT_ThamSoHeThongInfo.MaThamSoHeThong));
colParam.Add(CreateParam("@TenThamSoHeThong", SqlDbType.NVarChar, pHT_ThamSoHeThongInfo.TenThamSoHeThong));
colParam.Add(CreateParam("@IDDM_He", SqlDbType.Int, pHT_ThamSoHeThongInfo.IDDM_He));
colParam.Add(CreateParam("@PhanHe", SqlDbType.Int, pHT_ThamSoHeThongInfo.PhanHe));
colParam.Add(CreateParam("@GiaTri", SqlDbType.NVarChar, pHT_ThamSoHeThongInfo.GiaTri));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pHT_ThamSoHeThongInfo.GhiChu));
colParam.Add(CreateParam("@TrangThai", SqlDbType.Bit, pHT_ThamSoHeThongInfo.TrangThai));
colParam.Add(CreateParam("@SapXep", SqlDbType.Int, pHT_ThamSoHeThongInfo.SapXep));
colParam.Add(CreateParam("@HT_ThamSoHeThongID", SqlDbType.Int, pHT_ThamSoHeThongInfo.HT_ThamSoHeThongID));
RunProcedure("sp_HT_ThamSoHeThong_Update", colParam);
}
public int Add(HT_ThamSoHeThongInfo pHT_ThamSoHeThongInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaThamSoHeThong", SqlDbType.NVarChar, pHT_ThamSoHeThongInfo.MaThamSoHeThong));
colParam.Add(CreateParam("@TenThamSoHeThong", SqlDbType.NVarChar, pHT_ThamSoHeThongInfo.TenThamSoHeThong));
colParam.Add(CreateParam("@IDDM_He", SqlDbType.Int, pHT_ThamSoHeThongInfo.IDDM_He));
colParam.Add(CreateParam("@PhanHe", SqlDbType.Int, pHT_ThamSoHeThongInfo.PhanHe));
colParam.Add(CreateParam("@GiaTri", SqlDbType.NVarChar, pHT_ThamSoHeThongInfo.GiaTri));
colParam.Add(CreateParam("@GhiChu", SqlDbType.NVarChar, pHT_ThamSoHeThongInfo.GhiChu));
colParam.Add(CreateParam("@TrangThai", SqlDbType.Bit, pHT_ThamSoHeThongInfo.TrangThai));
colParam.Add(CreateParam("@SapXep", SqlDbType.Int, pHT_ThamSoHeThongInfo.SapXep));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_HT_ThamSoHeThong_Add", colParam));
}
public void Delete(HT_ThamSoHeThongInfo pHT_ThamSoHeThongInfo)
{
oDHT_ThamSoHeThong.Delete(pHT_ThamSoHeThongInfo);
mErrorMessage = oDHT_ThamSoHeThong.ErrorMessages;
mErrorNumber = oDHT_ThamSoHeThong.ErrorNumber;
}
public DataTable Get(HT_ThamSoHeThongInfo pHT_ThamSoHeThongInfo)
{
return(oDHT_ThamSoHeThong.Get(pHT_ThamSoHeThongInfo));
}
private void grvXepLich_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
pThamSoHeThongInfo = (HT_ThamSoHeThongInfo)grvXepLich.GetRow(grvXepLich.FocusedRowHandle);
}
public dlgThamSoHeThong(HT_ThamSoHeThongInfo mThamSoHeThongInfo)
{
InitializeComponent();
pThamSoHeThongInfo = mThamSoHeThongInfo;
}
