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)); }