public DataTable Get(KQHT_QuyCheInfo pKQHT_QuyCheInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_KQHT_QuyChe_GetResult>(client.cDKQHT_QuyChe_Get(GlobalVar.MaXacThuc, pKQHT_QuyCheInfo)));
}
}
public frmQuyChe()
{
InitializeComponent();
pKQHT_QuyCheInfo = new KQHT_QuyCheInfo();
oBKQHT_QuyChe = new cBKQHT_QuyChe();
lstQuyChe = new List <KQHT_QuyCheInfo>();
lstQuyChe = oBKQHT_QuyChe.GetList(pKQHT_QuyCheInfo);
}
public void Delete(KQHT_QuyCheInfo pKQHT_QuyCheInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_QuyCheID", SqlDbType.Int, pKQHT_QuyCheInfo.KQHT_QuyCheID));
RunProcedure("sp_KQHT_QuyChe_Delete", colParam);
}
public DataTable Get(KQHT_QuyCheInfo pKQHT_QuyCheInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KQHT_QuyCheID", SqlDbType.Int, pKQHT_QuyCheInfo.KQHT_QuyCheID));
return(RunProcedureGet("sp_KQHT_QuyChe_Get", colParam));
}
public int Add(KQHT_QuyCheInfo pKQHT_QuyCheInfo)
{
int ID = 0;
ID = oDKQHT_QuyChe.Add(pKQHT_QuyCheInfo);
mErrorMessage = oDKQHT_QuyChe.ErrorMessages;
mErrorNumber = oDKQHT_QuyChe.ErrorNumber;
return(ID);
}
public void Delete(KQHT_QuyCheInfo pKQHT_QuyCheInfo)
{
var client = new UnimOsServiceClient();
client.cDKQHT_QuyChe_Delete(GlobalVar.MaXacThuc, pKQHT_QuyCheInfo);
client.Close();
mErrorMessage = oDKQHT_QuyChe.ErrorMessages;
mErrorNumber = oDKQHT_QuyChe.ErrorNumber;
}
public void Update(KQHT_QuyCheInfo pKQHT_QuyCheInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaQuyChe", SqlDbType.NVarChar, pKQHT_QuyCheInfo.MaQuyChe));
colParam.Add(CreateParam("@TenQuyChe", SqlDbType.NVarChar, pKQHT_QuyCheInfo.TenQuyChe));
colParam.Add(CreateParam("@KQHT_QuyCheID", SqlDbType.Int, pKQHT_QuyCheInfo.KQHT_QuyCheID));
RunProcedure("sp_KQHT_QuyChe_Update", colParam);
}
public int Add(KQHT_QuyCheInfo pKQHT_QuyCheInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaQuyChe", SqlDbType.NVarChar, pKQHT_QuyCheInfo.MaQuyChe));
colParam.Add(CreateParam("@TenQuyChe", SqlDbType.NVarChar, pKQHT_QuyCheInfo.TenQuyChe));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_KQHT_QuyChe_Add", colParam));
}
public int Add(KQHT_QuyCheInfo pKQHT_QuyCheInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDKQHT_QuyChe_Add(GlobalVar.MaXacThuc, pKQHT_QuyCheInfo);
client.Close();
mErrorMessage = oDKQHT_QuyChe.ErrorMessages;
mErrorNumber = oDKQHT_QuyChe.ErrorNumber;
return(ID);
}
public List <KQHT_QuyCheInfo> GetList(KQHT_QuyCheInfo pKQHT_QuyCheInfo)
{
List <KQHT_QuyCheInfo> oKQHT_QuyCheInfoList = new List <KQHT_QuyCheInfo>();
DataTable dtb = Get(pKQHT_QuyCheInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oKQHT_QuyCheInfo = new KQHT_QuyCheInfo();
oKQHT_QuyCheInfo.KQHT_QuyCheID = int.Parse(dtb.Rows[i]["KQHT_QuyCheID"].ToString());
oKQHT_QuyCheInfo.MaQuyChe = dtb.Rows[i]["MaQuyChe"].ToString();
oKQHT_QuyCheInfo.TenQuyChe = dtb.Rows[i]["TenQuyChe"].ToString();
oKQHT_QuyCheInfoList.Add(oKQHT_QuyCheInfo);
}
}
return(oKQHT_QuyCheInfoList);
}
public void Delete(KQHT_QuyCheInfo pKQHT_QuyCheInfo)
{
oDKQHT_QuyChe.Delete(pKQHT_QuyCheInfo);
mErrorMessage = oDKQHT_QuyChe.ErrorMessages;
mErrorNumber = oDKQHT_QuyChe.ErrorNumber;
}
public DataTable Get(KQHT_QuyCheInfo pKQHT_QuyCheInfo)
{
return(oDKQHT_QuyChe.Get(pKQHT_QuyCheInfo));
}
