void Completed(object sende, EventArgs e) { string m_huyen = App.nhomtd.Length>30 ? App.nhomtd + ";WWW": App.nhomtd; QLThuebaoDomainContext dstb = new QLThuebaoDomainContext(); EntityQuery<rp_tktonghop> Query = dstb.GetRp_tktonghopQuery(); LoadOperation<rp_tktonghop> LoadOp = dstb.Load(Query.Where(p => m_huyen.Contains(p.ma_dv.Trim())).OrderBy(p => p.ma_dv), LoadOp_Complete, null); }
void Completed(object sende, EventArgs e) { string m_huyen = App.nhomtd; QLThuebaoDomainContext dstb = new QLThuebaoDomainContext(); EntityQuery<rp_tklydocat> Query = dstb.GetRp_tklydocatQuery(); LoadOperation<rp_tklydocat> LoadOp = dstb.Load(Query.OrderBy(p => p.ma_dv), LoadOp_Complete, null); }
public void dien_dl() { gridControl1.ShowLoadingPanel = true; EntityQuery<Mdiaban> Queryt = dstb.GetMadiabanTrimQuery(); LoadOptuyen = dstb.Load(Queryt.Where(p => p.ma_huyen == m_huyen && p.kt == false).OrderBy(p => p.ten_tuyen), LoadOpTT_Complete, null); EntityQuery<Mdiaban> Query = dstb.GetMadiabanTrimQuery(); LoadOptuyenkt = dstb.Load(Query.Where(p => p.ma_huyen == m_huyen && p.kt == true).OrderBy(p => p.ten_tuyen), LoadOpTTKT_Complete, null); EntityQuery<ds_codinh> QueryC = dstb.GetDs_codinhQuery(); LoadOp = dstb.Load(QueryC.Where(p=>(p.ma_nvcs==null || p.ma_nvkt==null) && p.ma_huyen==m_huyen),null,null ); EntityQuery<Gphone> QueryG = dstb.GetGphonesQuery(); LoadOpG = dstb.Load(QueryG.Where(p => (p.ma_nvcs == null || p.ma_nvkt == null) && p.ma_huyen == m_huyen), null, null); EntityQuery<internet> QueryI = dstb.GetInternetsQuery(); LoadOpI = dstb.Load(QueryI.Where(p => (p.ma_nvcs == null || p.ma_nvkt == null) && p.ma_huyen == m_huyen), null, null); EntityQuery<mytv> QueryM = dstb.GetMytvsQuery(); LoadOpM = dstb.Load(QueryM.Where(p => (p.ma_nvcs == null || p.ma_nvkt == null) && p.ma_huyen == m_huyen), null, null); QLThuebaoDomainContext db = new QLThuebaoDomainContext(); InvokeOperation<System.Nullable<int>> pr = db.Excute_DsGanDiaban(m_kt, m_nv, m_huyen, m_emp); pr.Completed += new EventHandler(GetData); if (App.kythuat) ma_nvcs.ReadOnly = true; else ma_nvkt.ReadOnly = true; }
private void OKButton_Click(object sender, RoutedEventArgs e) { QLThuebaoDomainContext dstb = new QLThuebaoDomainContext(); int m= Convert.ToInt16(cmbloaihong.GetKeyValue(cmbloaihong.SelectedIndex).ToString()); InvokeOperation<System.Nullable<int>> p = dstb.Excute_p_suaxong119(m_so,m,App.User_name); p.Completed += new EventHandler(Completed); }
private void FindButton_Click(object sender, RoutedEventArgs e) { if (txttim.Text.Trim() != "") { QLThuebaoDomainContext db = new QLThuebaoDomainContext(); if (chkInt.IsChecked == true) { EntityQuery<internet> Query = db.GetInternetsQuery(); LoadOperation<internet> Load = db.Load(Query.Where(p => p.user_name.Trim().Contains(txttim.Text.Trim())).OrderBy(p => p.ma_huyen), lo => { gridInt.Visibility = Visibility.Visible; gridmy.Visibility = Visibility.Collapsed; gridInt.ItemsSource = lo.Entities; }, null); } else { EntityQuery<mytv> Query = db.GetMytvsQuery(); LoadOperation<mytv> Load = db.Load(Query.Where(p => p.user_name.Trim().Contains(txttim.Text.Trim())).OrderBy(p=>p.ma_huyen), lo => { gridInt.Visibility = Visibility.Collapsed; gridmy.Visibility = Visibility.Visible; gridmy.ItemsSource = lo.Entities; }, null); } } }
void Completed(object sende, EventArgs e) { QLThuebaoDomainContext db = new QLThuebaoDomainContext(); EntityQuery<rp_dt_diaban> Query = db.GetRp_dt_diabanQuery(); LoadOperation<rp_dt_diaban> LoadOp = db.Load(Query.Where(p => App.nhomtd.Contains(p.ma_huyen)).OrderBy(p => p.ma_huyen).OrderBy(p => p.ten_tuyen), LoadOp_Complete, null); }
private void FindButton_Click(object sender, RoutedEventArgs e) { gridmy.ShowLoadingPanel = true; QLThuebaoDomainContext dstb = new QLThuebaoDomainContext(); InvokeOperation<System.Nullable<int>> p= dstb.Excute_p_tktonghop(dngaybd.DateTime, dngaykt.DateTime); p.Completed += new EventHandler(Completed); }
void GetData() { bool dba; if (rdnhanvien.IsChecked==true) dba=true; else dba=false; grid.ShowLoadingPanel = true; QLThuebaoDomainContext db = new QLThuebaoDomainContext(); InvokeOperation<System.Nullable<int>> p = db.Excute_TKDoanhThuGanNV(App.kythuat,dba,thang.DateTime); p.Completed += new EventHandler(Completed); }
void CreateData() { string m_huyen; grid.ShowLoadingPanel = true; grid1.ShowLoadingPanel = true; QLThuebaoDomainContext dstb = new QLThuebaoDomainContext(); if (App.admin_119) m_huyen = "ALL"; else m_huyen = "'" + App.nhomtd + "'"; // m_huyen ="'"+ App.nhomtd.Replace(";","','")+"'"; // MessageBox.Show(m_huyen); InvokeOperation<System.Nullable<int>> p = dstb.Excute_p_getsuaxong119(m_huyen,this.dngaybd.DateTime, this.dngaykt.DateTime); p.Completed += new EventHandler(Completed); }
void dien_dl(string mloai, string mbd,string mhuyen,DateTime ngaybd, DateTime ngaykt) //mbd M: hoa mang N: ngung C: cat T:thtb { QLThuebaoDomainContext dstb = new QLThuebaoDomainContext(); // loai co dinh if (mloai == "C") { EntityQuery<codinh_log> Query = dstb.GetCodinh_logQuery(); LoadOperation<codinh_log> Load = dstb.Load(Query.Where(p => p.ma_huyen == mhuyen && p.lydocat == mbd && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpCDComplete, null); } // loai Gphone if (mloai == "G") { EntityQuery<Gphone_log> Query = dstb.GetGphone_logQuery(); LoadOperation<Gphone_log> Load = dstb.Load(Query.Where(p => p.ma_huyen == mhuyen && p.lydocat == mbd && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt && p.loai_tb == false), LoadOpGPComplete, null); } // loai MyTV if (mloai == "M") { EntityQuery<mytv_log> Query = dstb.GetMytv_logQuery(); LoadOperation<mytv_log> Load = dstb.Load(Query.Where(p => p.ma_huyen == mhuyen && p.lydocat == mbd && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpMYComplete, null); } // loai internet if (mloai == "I") { EntityQuery<internet_log> Query = dstb.GetInternet_logQuery(); LoadOperation<internet_log> Load = dstb.Load(Query.Where(p => p.ma_huyen == mhuyen && p.ma_dv == "ADSL" && p.lydocat == mbd && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpINTComplete, null); } // loai ftth if (mloai == "F") { EntityQuery<internet_log> Query = dstb.GetInternet_logQuery(); LoadOperation<internet_log> Load = dstb.Load(Query.Where(p => p.ma_huyen == mhuyen && p.ma_dv == "FIBER" && p.lydocat == mbd && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpINTComplete, null); } }
private void OKButton_Click(object sender, RoutedEventArgs e) { if (txtsogoibao.Text.Trim() == "" || txtsogoibao.Text.Trim().Length < 7) { MessageBox.Show("Chưa nhập vào số gọi báo hoặc số gọi báo chưa đúng !"); return; } QLThuebaoDomainContext db = new QLThuebaoDomainContext(); string m_user = App.User_name.Length > 12 ? App.User_name.Substring(0, 13) : App.User_name; InvokeOperation<System.Nullable<int>> p = db.Excute_p_bao119(txtsdt.Text.Trim(), App.refix_119, txtsogoibao.Text.Trim()); p.Completed += new EventHandler(GetData); //QLThuebaoDomainContext db = new QLThuebaoDomainContext(); //EntityQuery<C119TVPrefix> Query = db.GetC119TVPrefixQuery(); //Load = db.Load(Query.OrderBy(p=>p.nPrefixBegin),LoadOpComplete,null); }
void search() { gridControl1.ItemsSource = null; gridControl1.ShowLoadingPanel = true; QLThuebaoDomainContext db = new QLThuebaoDomainContext(); //if ((txtsodt.Text.Trim() != "" || txtsodt.Text.Trim() != "0") && txtsodt.Text.Trim().Length < 7) //{ // MessageBox.Show("Nhập chưa đúng số điện thoại !"); // return; //} if (txtsodt.Text.Trim() != "" && txtsodt.Text.Trim() !="0") { EntityQuery<DSCD> Query = db.Getds1080Query(txtsodt.Text.Trim()); LoadOperation<DSCD> Load = db.Load(Query, LoadOpComplete, null); } if (txttentb.Text.Trim() != "" && txtdcld.Text.Trim() == "" && txtttin108.Text.Trim() == "") { EntityQuery<DSCD> Query = db.Getds10801Query(txttentb.Text.Trim()); LoadOperation<DSCD> Load = db.Load(Query, LoadOpComplete, null); } if (txttentb.Text.Trim() != "" && txtdcld.Text.Trim() != "" && txtttin108.Text.Trim() == "") { EntityQuery<DSCD> Query = db.Getds10802Query(txttentb.Text.Trim(), txtdcld.Text.Trim()); LoadOperation<DSCD> Load = db.Load(Query, LoadOpComplete, null); } if (txttentb.Text.Trim() != "" && txtdcld.Text.Trim() != "" && txtttin108.Text.Trim() != "") { EntityQuery<DSCD> Query = db.Getds10803Query(txttentb.Text.Trim(), txtdcld.Text.Trim(), txtttin108.Text.Trim()); LoadOperation<DSCD> Load = db.Load(Query, LoadOpComplete, null); } if (txttentb.Text.Trim() == "" && txtdcld.Text.Trim() == "" && txtttin108.Text.Trim() != "") { EntityQuery<DSCD> Query = db.Getds10804Query(txtttin108.Text.Trim()); LoadOperation<DSCD> Load = db.Load(Query, LoadOpComplete, null); } if (txttentb.Text.Trim() == "" && txtdcld.Text.Trim() != "" && txtttin108.Text.Trim() == "") { EntityQuery<DSCD> Query = db.Getds10805Query(txtdcld.Text.Trim()); LoadOperation<DSCD> Load = db.Load(Query, LoadOpComplete, null); } }
void GetData(object sender, EventArgs e) { grid.ShowLoadingPanel = true; QLThuebaoDomainContext db = new QLThuebaoDomainContext(); if (App.admin_119) { EntityQuery<ds_119> Query = db.GetDs_119Query(); LoadOperation<ds_119> LoadOp = db.Load(Query.OrderByDescending(p => p.dtRecvTime), LoadOp_Complete, null); EntityQuery<dsw_119> Query1 = db.GetDsw_119Query(); LoadOperation<dsw_119> LoadOp1 = db.Load(Query1.OrderByDescending(p => p.dtRecvTime), LoadOp1_Complete, null); } else { EntityQuery<ds_119> Query = db.GetDs_119Query(); LoadOperation<ds_119> LoadOp = db.Load(Query.Where(p => App.nhomtd.Contains(p.ma_huyen)).OrderByDescending(p => p.dtRecvTime), LoadOp_Complete, null); EntityQuery<dsw_119> Query1 = db.GetDsw_119Query(); LoadOperation<dsw_119> LoadOp1 = db.Load(Query1.Where(p => App.nhomtd.Contains(p.ma_huyen)).OrderByDescending(p => p.dtRecvTime), LoadOp1_Complete, null); } }
void get_data() { //grid.ShowLoadingPanel = true; //grid1.ShowLoadingPanel = true; QLThuebaoDomainContext db = new QLThuebaoDomainContext(); if (App.admin_119) { EntityQuery<dssuaxong_119> Query = db.GetDssuaxong_119Query(); LoadOperation<dssuaxong_119> LoadOp = db.Load(Query.Where(p=>p.bfinished==true).OrderByDescending(p => p.dtRecvTime), LoadOp_Complete, null); } else { EntityQuery<dssuaxong_119> Query = db.GetDssuaxong_119Query(); LoadOperation<dssuaxong_119> LoadOp = db.Load(Query.Where(p =>App.nhomtd.Contains(p.ma_huyen) && p.bfinished==true).OrderByDescending(p => p.dtRecvTime), LoadOp_Complete, null); } EntityQuery<tkloai119> Querys = db.GetTkloai119Query(); LoadOperation<tkloai119> LoadOps = db.Load(Querys.OrderBy(p => p.istatusID), LoadOps_Complete, null); }
void dien_dl() { int m_kt; m_kt = dngaykt.DateTime.Month; QLThuebaoDomainContext db = new QLThuebaoDomainContext(); EntityQuery<khachhangDN> Query = db.GetKhachhangDNQuery(); if (checkEdit1.IsChecked == true) { LoadOperation<khachhangDN> Load = db.Load(Query.Where(p =>p.ngay_tl.Value.Month == m_kt).OrderBy(p => p.ngay_tl), lo => { gridControl1.ItemsSource = lo.Entities; this.Title = "Khách hàng là doanh nghiệp : " + lo.Entities.Count().ToString(); }, true); } else { LoadOperation<khachhangDN> Load = db.Load(Query.Where(p => p.ngay_tl.Value >= dngaybd.DateTime && p.ngay_tl.Value <= dngaykt.DateTime).OrderBy(p => p.ngay_tl), lo => { gridControl1.ItemsSource = lo.Entities; this.Title = "Khách hàng là doanh nghiệp : " + lo.Entities.Count().ToString(); }, true); } }
private void txttentb_DefaultButtonClick(object sender, RoutedEventArgs e) { grid.ShowLoadingPanel = true; txtsdt.IsEnabled = false; txttentb.IsEnabled = false; QLThuebaoDomainContext dbs = new QLThuebaoDomainContext(); if (App.admin_119) { EntityQuery<ds119s> Query = dbs.Getds119Query(txttentb.Text.Trim()); LoadOperation<ds119s> Load = dbs.Load(Query, LoadOpComplete, null); } else { EntityQuery<ds119s> Query = dbs.Getds119Query(txttentb.Text.Trim()); LoadOperation<ds119s> Load = dbs.Load(Query.Where(p => p.ma_huyen == App.ma_huyen), LoadOpComplete, null); } }
void RefreshData() { grid.ShowLoadingPanel = true; QLThuebaoDomainContext db = new QLThuebaoDomainContext(); InvokeOperation<System.Nullable<int>> p = db.Excute_get_119_new(); p.Completed += new EventHandler(GetData); }
private void deleteRowItem1_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e) { if (grid1.GetFocusedRow() != null) { if (App.admin_119) { string m_dl = grid1.GetFocusedRowCellValue(sDamagedPhoneNo1).ToString().Trim(); //int rowHandle = gridControl1.View.FocusedRowHandle; MessageBoxResult result = MessageBox.Show("Muốn xóa số : " + m_dl + " ?", "Xác nhận", MessageBoxButton.OKCancel); if (result == MessageBoxResult.OK) { QLThuebaoDomainContext db = new QLThuebaoDomainContext(); InvokeOperation<System.Nullable<int>> p = db.Excute_p_Delete_119(m_dl); p.Completed += new EventHandler(GetData); } else return; } else MessageBox.Show("Không có quyền xóa dữ liệu !"); } else MessageBox.Show("Chưa chọn mẫu tin cần xóa !"); }
private void OnSubmitCompleted(SubmitOperation so) { if (so.HasError) { MessageBox.Show(string.Format("Submit Failed: {0}", so.Error.Message)); so.MarkErrorAsHandled(); } else { QLThuebaoDomainContext dstb = new QLThuebaoDomainContext(); InvokeOperation<System.Nullable<int>> p = dstb.Excute_p_doiaccmytv(txtusr.Text.Trim(), txtusrn.Text.Trim()); p.Completed += new EventHandler(Completed); } }
void dien_dl(string mloai, string mbd,string mhuyen,DateTime ngaybd, DateTime ngaykt) //mbd M: hoa mang N: ngung C: cat T:thtb { QLThuebaoDomainContext dstb = new QLThuebaoDomainContext(); // loai co dinh if (mloai == "C") { switch( mbd) { case "T": EntityQuery<codinh_log> Query = dstb.GetCodinh_logQuery(); LoadOperation<codinh_log> Load = dstb.Load(Query.Where(p => p.ma_huyen == mhuyen && (p.may_ngung == "C" || p.may_ngung == "N") && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpCDComplete, null); break; case "M": EntityQuery<codinh_log> QueryM = dstb.GetCodinh_logQuery(); LoadOperation<codinh_log> LoadM = dstb.Load(QueryM.Where(p => p.ma_huyen == mhuyen && p.ngay_hd >= ngaybd && p.ngay_hd <= ngaykt), LoadOpCDComplete, null); break; default: EntityQuery<codinh_log> Queryd = dstb.GetCodinh_logQuery(); LoadOperation<codinh_log> Loadd = dstb.Load(Queryd.Where(p => p.ma_huyen == mhuyen && p.may_ngung == mbd && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpCDComplete, null); break; } } // loai Gphone if (mloai == "G") { switch (mbd) { case "T": EntityQuery<Gphone_log> Query = dstb.GetGphone_logQuery(); LoadOperation<Gphone_log> Load = dstb.Load(Query.Where(p => p.ma_huyen == mhuyen && (p.may_ngung == "C" || p.may_ngung == "N") && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt && p.loai_tb == false), LoadOpGPComplete, null); break; case "M": EntityQuery<Gphone_log> QueryM = dstb.GetGphone_logQuery(); LoadOperation<Gphone_log> LoadM = dstb.Load(QueryM.Where(p => p.ma_huyen == mhuyen && p.ngay_hd >= ngaybd && p.ngay_hd <= ngaykt && p.loai_tb == false), LoadOpGPComplete, null); break; default: EntityQuery<Gphone_log> Queryd = dstb.GetGphone_logQuery(); LoadOperation<Gphone_log> Loadd = dstb.Load(Queryd.Where(p => p.ma_huyen == mhuyen && p.may_ngung == mbd && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt && p.loai_tb == false), LoadOpGPComplete, null); break; } } // loai Gphone if (mloai == "GT") { switch (mbd) { case "T": EntityQuery<Gphone_log> Query = dstb.GetGphone_logQuery(); LoadOperation<Gphone_log> Load = dstb.Load(Query.Where(p => p.ma_huyen == mhuyen && (p.may_ngung == "C" || p.may_ngung == "N") && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt && p.loai_tb == true), LoadOpGPComplete, null); break; case "M": EntityQuery<Gphone_log> QueryM = dstb.GetGphone_logQuery(); LoadOperation<Gphone_log> LoadM = dstb.Load(QueryM.Where(p => p.ma_huyen == mhuyen && p.ngay_hd >= ngaybd && p.ngay_hd <= ngaykt && p.loai_tb == true), LoadOpGPComplete, null); break; default: EntityQuery<Gphone_log> Queryd = dstb.GetGphone_logQuery(); LoadOperation<Gphone_log> Loadd = dstb.Load(Queryd.Where(p => p.ma_huyen == mhuyen && p.may_ngung == mbd && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt && p.loai_tb == true), LoadOpGPComplete, null); break; } } // loai MyTV if (mloai == "M") { switch (mbd) { case "T": EntityQuery<mytv_log> Query = dstb.GetMytv_logQuery(); LoadOperation<mytv_log> Load = dstb.Load(Query.Where(p => p.ma_huyen == mhuyen && (p.tinh_trang == "C" || p.tinh_trang == "N") && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpMYComplete, null); break; case "M": EntityQuery<mytv_log> QueryM = dstb.GetMytv_logQuery(); LoadOperation<mytv_log> LoadM = dstb.Load(QueryM.Where(p => p.ma_huyen == mhuyen && p.ngay_hd >= ngaybd && p.ngay_hd <= ngaykt), LoadOpMYComplete, null); break; default: EntityQuery<mytv_log> Queryd = dstb.GetMytv_logQuery(); LoadOperation<mytv_log> Loadd = dstb.Load(Queryd.Where(p => p.ma_huyen == mhuyen && p.tinh_trang == mbd && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpMYComplete, null); break; } } // loai internet if (mloai == "I") { switch (mbd) { case "T": EntityQuery<internet_log> Query = dstb.GetInternet_logQuery(); LoadOperation<internet_log> Load = dstb.Load(Query.Where(p => p.ma_huyen == mhuyen && p.ma_dv == "ADSL" && (p.may_ngung == "C" || p.may_ngung == "N") && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpINTComplete, null); break; case "M": EntityQuery<internet_log> QueryM = dstb.GetInternet_logQuery(); LoadOperation<internet_log> LoadM = dstb.Load(QueryM.Where(p => p.ma_huyen == mhuyen && p.ma_dv == "ADSL" && p.ngay_hd >= ngaybd && p.ngay_hd <= ngaykt), LoadOpINTComplete, null); break; default: EntityQuery<internet_log> Queryd = dstb.GetInternet_logQuery(); LoadOperation<internet_log> Loadd = dstb.Load(Queryd.Where(p => p.ma_huyen == mhuyen && p.ma_dv == "ADSL" && p.may_ngung == mbd && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpINTComplete, null); break; } } // loai ftth if (mloai == "F") { switch (mbd) { case "T": EntityQuery<internet_log> Query = dstb.GetInternet_logQuery(); LoadOperation<internet_log> Load = dstb.Load(Query.Where(p => p.ma_huyen == mhuyen && p.ma_dv == "FIBER" && (p.may_ngung == "C" || p.may_ngung == "N") && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpINTComplete, null); break; case "M": EntityQuery<internet_log> QueryM = dstb.GetInternet_logQuery(); LoadOperation<internet_log> LoadM = dstb.Load(QueryM.Where(p => p.ma_huyen == mhuyen && p.ma_dv == "FIBER" && p.ngay_hd >= ngaybd && p.ngay_hd <= ngaykt), LoadOpINTComplete, null); break; default: EntityQuery<internet_log> Queryd = dstb.GetInternet_logQuery(); LoadOperation<internet_log> Loadd = dstb.Load(Queryd.Where(p => p.ma_huyen == mhuyen && p.ma_dv == "FIBER" && p.may_ngung == mbd && p.ngay_ngung >= ngaybd && p.ngay_ngung <= ngaykt), LoadOpINTComplete, null); break; } } }
void GetData(object sender, EventArgs e) { this.gridControl1.ItemsSource = new GanDB(); // lay bang rong dua vao tableView1.DeleteRow(0); gridControl1.ShowLoadingPanel = true; QLThuebaoDomainContext db = new QLThuebaoDomainContext(); if (m_kt) { EntityQuery<rp_dsgan> Query = db.GetRp_dsganQuery(); LoadOperation<rp_dsgan> LoadOp = db.Load(Query.OrderBy(p => p.ma_nvcs), LoadOp_Complete, null); } else { EntityQuery<rp_dsgan> Query = db.GetRp_dsganQuery(); LoadOperation<rp_dsgan> LoadOp = db.Load(Query.OrderBy(p => p.ma_nvkt), LoadOp_Complete, null); } }
//void LoadOpC(LoadOperation<ds_codinh> lo) //{ // EntityQuery<Gphone> QueryG = dstb.GetGphonesQuery(); // LoadOpG = dstb.Load(QueryG.Where(p => (p.ma_nvcs == null || p.ma_nvkt == null) && p.ma_huyen == m_huyen), LoadOpG_C, null); //} //void LoadOpG_C(LoadOperation<Gphone> lo) //{ // EntityQuery<internet> QueryI = dstb.GetInternetsQuery(); // LoadOpI = dstb.Load(QueryI.Where(p => (p.ma_nvcs == null || p.ma_nvkt == null) && p.ma_huyen == m_huyen), LoadOpI_C, null); //} //void LoadOpI_C(LoadOperation<internet> lo) //{ // EntityQuery<mytv> QueryM = dstb.GetMytvsQuery(); // LoadOpM = dstb.Load(QueryM.Where(p => (p.ma_nvcs == null || p.ma_nvkt == null) && p.ma_huyen == m_huyen), LoadOpM_C, null); //} void LoadOpM_C(LoadOperation<mytv> lo) { QLThuebaoDomainContext db = new QLThuebaoDomainContext(); InvokeOperation<System.Nullable<int>> pr = db.Excute_DsGanDiaban(m_kt, m_nv, m_huyen, m_emp); pr.Completed += new EventHandler(GetData); }
void CreateChart() { double mtong = 0; QLThuebaoDomainContext db = new QLThuebaoDomainContext(); EntityQuery<tk119> Qr = db.GetTk119Query(); LoadOperation<tk119> Load = db.Load(Qr.OrderBy(p => p.ID), lo => { if (lo.Entities.Count() > 0) { for (int i = 0; i < lo.Entities.Count(); i++) { double sl = Convert.ToDouble(lo.Entities.ElementAt(i).suaxong, CultureInfo.InvariantCulture); double slx = Convert.ToDouble(lo.Entities.ElementAt(i).baohong, CultureInfo.InvariantCulture); string name = lo.Entities.ElementAt(i).loai.Trim(); thuebao.Add(new slthuebao(name, sl,slx)); mtong += sl; } chart.Diagram.Series[0].DataSource = thuebao; chart.Diagram.Series[1].DataSource = thuebao; // ltongc.Content = "Tổng : " + mtong.ToString() + " tính theo phương pháp 60 ngày có nạp thẻ trên địa bàn tỉnh"; //TT.Content = ""; chart.Diagram.Series[0].LabelsVisibility = true; chart.Animate(); } }, false ); }
private void DabaoItem_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e) { if (grid.GetFocusedRow() != null) { string m_dl = grid.GetFocusedRowCellValue(sDamagedPhoneNo).ToString().Trim(); QLThuebaoDomainContext db = new QLThuebaoDomainContext(); InvokeOperation<System.Nullable<int>> p = db.Excute_p_Dathongbao_119(m_dl); p.Completed += new EventHandler(GetData); } else MessageBox.Show("Chưa chọn số !"); }
void laythongtin() { QLThuebaoDomainContext dbs = new QLThuebaoDomainContext(); EntityQuery<ma_diaban> Query = dbs.GetMa_diabanQuery(); LoadOperation<ma_diaban> Load = dbs.Load(Query.Where(p => p.ma_huyen == App.ma_huyen && p.kt == App.kythuat), lo => { gridControl1.ItemsSource = lo.Entities; }, null); }
private void brSua_ItemClick(object sender, RoutedEventArgs e) { if (gridControl1.GetFocusedRow() != null) { string db = gridControl1.GetFocusedRowCellValue(diaban)==null ? "":gridControl1.GetFocusedRowCellValue(diaban).ToString().Trim(); if (db.Length > 1) db = db.Substring(1, db.Length - 1); frmnhapnvcs frm = new frmnhapnvcs(true,db); frm.txtmanv.Text = gridControl1.GetFocusedRowCellValue(ma_nvcs).ToString().Trim(); frm.txtten.Text = gridControl1.GetFocusedRowCellValue(ten_nv).ToString().Trim(); frm.txtphone.Text = gridControl1.GetFocusedRowCellValue(phone)==null? "": gridControl1.GetFocusedRowCellValue(phone).ToString().Trim(); frm.checkEdit1.IsChecked = gridControl1.GetFocusedRowCellValue(kt)==null? false: Convert.ToBoolean(gridControl1.GetFocusedRowCellValue(kt)); this.Close(); frm.Show(); } else MessageBox.Show("Chưa chọn nhân viên cần sửa !"); }