public static void ExecDODUNG_UpdIntoDataView(XPDataView dataView, Session session, int IdDD, string TenDD, decimal ChiPhiDD) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("DODUNG_Upd", new OperandValue(IdDD), new OperandValue(TenDD), new OperandValue(ChiPhiDD)); dataView.PopulateProperties(session.GetClassInfo(typeof(DODUNG_UpdResult1))); dataView.LoadData(sprocData); }
public static void ExecHR_GetEmployeeClassificationsIntoDataView(XPDataView dataView, Session session, int EmployeeClassificationKey) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("HR.GetEmployeeClassifications", new OperandValue(EmployeeClassificationKey)); dataView.PopulateProperties(session.GetClassInfo(typeof(GetEmployeeClassificationsResult))); dataView.LoadData(sprocData); }
public static void ExecDICHVU_UpdIntoDataView(XPDataView dataView, Session session, int IdDV, string TenDV, decimal DonGiaDV, string GhiChu) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("DICHVU_Upd", new OperandValue(IdDV), new OperandValue(TenDV), new OperandValue(DonGiaDV), new OperandValue(GhiChu)); dataView.PopulateProperties(session.GetClassInfo(typeof(DICHVU_UpdResult2))); dataView.LoadData(sprocData); }
public static void ExecBOPHAN_UpdIntoDataView(XPDataView dataView, Session session, int IdBP, string TenBP, string GhiChu) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("BOPHAN_Upd", new OperandValue(IdBP), new OperandValue(TenBP), new OperandValue(GhiChu)); dataView.PopulateProperties(session.GetClassInfo(typeof(BOPHAN_UpdResult2))); dataView.LoadData(sprocData); }
public static void ExecSalesByCategoryIntoDataView(XPDataView dataView, Session session, string CategoryName, string OrdYear) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("SalesByCategory", new OperandValue(CategoryName), new OperandValue(OrdYear)); dataView.PopulateProperties(session.GetClassInfo(typeof(SalesByCategoryResult))); dataView.LoadData(sprocData); }
public static void ExecMANHINH_UpdIntoDataView(XPDataView dataView, Session session, int IdMH, string TenMH) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("MANHINH_Upd", new OperandValue(IdMH), new OperandValue(TenMH)); dataView.PopulateProperties(session.GetClassInfo(typeof(MANHINH_UpdResult1))); dataView.LoadData(sprocData); }
public static void ExecNHANVIEN_ByIdIntoDataView(XPDataView dataView, Session session, int IdNV) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("NHANVIEN_ById", new OperandValue(IdNV)); dataView.PopulateProperties(session.GetClassInfo(typeof(NHANVIEN_ByIdResult))); dataView.LoadData(sprocData); }
public static void ExecVehicleNotRacedByPeriodeIntoDataView(XPDataView dataView, Session session, DateTime Date) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("VehicleNotRacedByPeriode", new OperandValue(Date)); dataView.PopulateProperties(session.GetClassInfo(typeof(VehicleNotRacedByPeriodeResult))); dataView.LoadData(sprocData); }
public static void Execsp_helpdiagramsIntoDataView(XPDataView dataView, Session session, string diagramname, int owner_id) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("sp_helpdiagrams", new OperandValue(diagramname), new OperandValue(owner_id)); dataView.PopulateProperties(session.GetClassInfo(typeof(sp_helpdiagramsResult))); dataView.LoadData(sprocData); }
public static void Execsp_helpdiagramsIntoDataView(XPDataView dataView, Session session, string diagramname, int owner_id) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("sp_helpdiagrams", new OperandValue(diagramname), new OperandValue(owner_id)); dataView.PopulateProperties(session.GetClassInfo(typeof(sp_helpdiagramsResult))); dataView.LoadData(sprocData); }
public static void ExecTurnOverCustomerAscendingIntoDataView(XPDataView dataView, Session session) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("TurnOverCustomerAscending"); dataView.PopulateProperties(session.GetClassInfo(typeof(TurnOverCustomerAscendingResult))); dataView.LoadData(sprocData); }
public static void ExecVehicleNotRacedByPeriodeIntoDataView(XPDataView dataView, Session session, DateTime Date) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("VehicleNotRacedByPeriode", new OperandValue(Date)); dataView.PopulateProperties(session.GetClassInfo(typeof(VehicleNotRacedByPeriodeResult))); dataView.LoadData(sprocData); }
public static void ExecCustOrdersOrdersIntoDataView(XPDataView dataView, Session session, string CustomerID) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("CustOrdersOrders", new OperandValue(CustomerID)); dataView.PopulateProperties(session.GetClassInfo(typeof(CustOrdersOrdersResult))); dataView.LoadData(sprocData); }
public static void ExecTenMostExpensiveProductsIntoDataView(XPDataView dataView, Session session) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("Ten Most Expensive Products"); dataView.PopulateProperties(session.GetClassInfo(typeof(TenMostExpensiveProductsResult))); dataView.LoadData(sprocData); }
public static void ExecDOUONG_InsIntoDataView(XPDataView dataView, Session session, string TenDU, string DVT, decimal DonGia, decimal DonGia_PS, string GhiChu) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("DOUONG_Ins", new OperandValue(TenDU), new OperandValue(DVT), new OperandValue(DonGia), new OperandValue(DonGia_PS), new OperandValue(GhiChu)); dataView.PopulateProperties(session.GetClassInfo(typeof(DOUONG_InsResult1))); dataView.LoadData(sprocData); }
public static void ExecTurnOverCustomerAscendingIntoDataView(XPDataView dataView, Session session) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("TurnOverCustomerAscending"); dataView.PopulateProperties(session.GetClassInfo(typeof(TurnOverCustomerAscendingResult))); dataView.LoadData(sprocData); }
public static void ExecLOAITIEC_InsIntoDataView(XPDataView dataView, Session session, string TenLT) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("LOAITIEC_Ins", new OperandValue(TenLT)); dataView.PopulateProperties(session.GetClassInfo(typeof(LOAITIEC_InsResult1))); dataView.LoadData(sprocData); }
public static void ExecGetIndexUebersichtIntoDataView(XPDataView dataView, Session session) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("GetIndexUebersicht"); dataView.PopulateProperties(session.GetClassInfo(typeof(GetIndexUebersichtResult))); dataView.LoadData(sprocData); }
public static void ExecMONAN_DelIntoDataView(XPDataView dataView, Session session, int IdMA) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("MONAN_Del", new OperandValue(IdMA)); dataView.PopulateProperties(session.GetClassInfo(typeof(MONAN_DelResult1))); dataView.LoadData(sprocData); }
public static void ExecHR_CountEmployeesByClassificationIntoDataView(XPDataView dataView, Session session) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("HR.CountEmployeesByClassification"); dataView.PopulateProperties(session.GetClassInfo(typeof(CountEmployeesByClassificationResult))); dataView.LoadData(sprocData); }
public static void ExecKHACHHANG_GetAllIntoDataView(XPDataView dataView, Session session) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("KHACHHANG_GetAll"); dataView.PopulateProperties(session.GetClassInfo(typeof(KHACHHANG_GetAllResult))); dataView.LoadData(sprocData); }
public static void ExecHR_CreateEmployeeClassificationIntoDataView(XPDataView dataView, Session session, string EmployeeClassificationName, bool IsExempt, bool IsEmployee) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("HR.CreateEmployeeClassification", new OperandValue(EmployeeClassificationName), new OperandValue(IsExempt), new OperandValue(IsEmployee)); dataView.PopulateProperties(session.GetClassInfo(typeof(CreateEmployeeClassificationResult))); dataView.LoadData(sprocData); }
public static void ExecDANGNHAPIntoDataView(XPDataView dataView, Session session, string TenDangNhap, string MatKhau) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("DANGNHAP", new OperandValue(TenDangNhap), new OperandValue(MatKhau)); dataView.PopulateProperties(session.GetClassInfo(typeof(DANGNHAPResult))); dataView.LoadData(sprocData); }
public static void ExecSalesbyYearIntoDataView(XPDataView dataView, Session session, DateTime Beginning_Date, DateTime Ending_Date) { DevExpress.Xpo.DB.SelectedData sprocData = session.ExecuteSproc("Sales by Year", new OperandValue(Beginning_Date), new OperandValue(Ending_Date)); dataView.PopulateProperties(session.GetClassInfo(typeof(SalesbyYearResult))); dataView.LoadData(sprocData); }