public static DataView loadAllGroup() { DataSet ds = DAGroup.Instance.loadDataSetGroup(); DataViewManager dvManager = new DataViewManager(ds); DataView dv = dvManager.CreateDataView(ds.Tables["GROUP_TBL"]); return dv; }
private void Form1_Load(object sender, EventArgs e) { DbADOTest = new DataSet("DbADOTest"); tblPeople = MakePeopleTable(); tblSale = MakeSaleTable(); DbADOTest.Tables.Add(tblPeople); DbADOTest.Tables.Add(tblSale); // 매니저를 통한 뷰 설정 DataViewManager vm = new DataViewManager(DbADOTest); vm.DataViewSettings["tblPeople"].Sort = "Name"; vm.DataViewSettings["tblSale"].RowFilter = "OrderNo > 1"; // 새로운 뷰 생성 DataView ViewMan = vm.CreateDataView(tblPeople); ViewMan.RowFilter = "Male = true"; ViewMan.Sort = "Age DESC"; foreach (DataViewSetting vs in vm.DataViewSettings) { listBox1.Items.Add(string.Format("테이블:{0}, 필터:{1}, 정렬:{2}, 상태:{3}", vs.Table, vs.RowFilter, vs.Sort, vs.RowStateFilter)); } dataGridView1.DataSource = vm; dataGridView1.DataMember = "tblPeople"; dataGridView2.DataSource = vm; dataGridView2.DataMember = "tblSale"; dataGridView3.DataSource = ViewMan; }
private void PopulateCptyData() { this.Text = "Cpty Fax Mapping"; this.lblCode.Text = "Cpty Short Name:"; this.ddCptyCode.Visible = true; this.txtDesc.Visible = false; DataSet ds = new DataSet(); OracleDataAdapter adapter = new OracleDataAdapter(_CPTY_SQL, connectionString); adapter.Fill(ds,"Cpty"); DataViewManager dvm = new DataViewManager(ds); dv = dvm.CreateDataView(ds.Tables["Cpty"]); dv.Sort = "SHORT_NAME"; this.ddCptyCode.Properties.DataSource = dv; this.ddCptyCode.Properties.ValidateOnEnterKey = true; this.ddCptyCode.DataBindings.Add("EditValue", dv, "SHORT_NAME"); this.ddCptyCode.Properties.ValueMember = "SHORT_NAME"; this.ddCptyCode.Properties.DisplayMember = "SHORT_NAME"; GridColumn col1 = ddCptyCode.Properties.View.Columns.ColumnByFieldName("SHORT_NAME"); col1.VisibleIndex = 0; col1.Caption = "Short Name"; GridColumn col2 = ddCptyCode.Properties.View.Columns.ColumnByFieldName("LEGAL_NAME"); col2.VisibleIndex = 1; col2.Caption = "Name"; this.txtFax.Text = this.faxNumber; this.ddCptyCode.EditValue = this.codeDesc; }
private void loadGridViewUserSelectionChanged() { if (gridViewUser.FocusedRowHandle >= 0) { DataRow row = gridViewUser.GetDataRow(gridViewUser.FocusedRowHandle); DataSet ds = Feature.getFeatureUserAdapter(HelpNumber.ParseInt64(row["userid"]), "USER_FEATURE_TBL"); DataViewManager dvManager = new DataViewManager(ds); DataView dv = dvManager.CreateDataView(ds.Tables["USER_FEATURE_TBL"]); gridControlFeature.DataSource = dv; SetDisableFunction(); DataSet ds2 = BaoBieu.getReportUserAdapter(HelpNumber.ParseInt64(row["userid"]), "USER_REPORT_TBL"); DataViewManager dvManager2 = new DataViewManager(ds2); DataView dv2 = dvManager2.CreateDataView(ds2.Tables["USER_REPORT_TBL"]); gridControlReport.DataSource = dv2; UserManUtil.getAllGroupByUserId(gridControlThanhPhanGroupUser, ref dsGetGroupByUser, HelpNumber.ParseInt64(row["userid"]), false); if (row["username"].ToString() == "admin") { this.btnDelete.Enabled = false; } else { this.btnDelete.Enabled = true; } } else { gridControlFeature.DataSource = null; gridControlReport.DataSource = null; } }
private void loadGridViewGroupSelectionChanged() { if (gridViewGroup.FocusedRowHandle >= 0) { DataRow row = gridViewGroup.GetDataRow(gridViewGroup.FocusedRowHandle); DataSet ds = Feature.getFeatureGroupAdapter(HelpNumber.ParseInt64(row["groupid"].ToString()), "GROUP_FEATURE_TBL"); DataViewManager dvManager = new DataViewManager(ds); DataView dv = dvManager.CreateDataView(ds.Tables["GROUP_FEATURE_TBL"]); gridControlFeature.DataSource = dv; SetDisableFunction(); DataSet ds2 = BaoBieu.getReportGroupAdapter(HelpNumber.ParseInt64(row["groupid"].ToString()), "GROUP_REPORT_TBL"); DataViewManager dvManager2 = new DataViewManager(ds2); DataView dv2 = dvManager2.CreateDataView(ds2.Tables["GROUP_REPORT_TBL"]); gridControlReport.DataSource = dv2; UserManUtil.getAllUserByGroupId(gridControlThanhPhanGroupUser,ref dsGetUserByGroup, HelpNumber.ParseInt64(row["groupid"]), false); } else { gridControlFeature.DataSource = null; gridControlReport.DataSource = null; } }
private void loadGridViewUserSelectionChanged() { if (gridViewUser.FocusedRowHandle >= 0) { DataRow row = gridViewUser.GetDataRow(gridViewUser.FocusedRowHandle); //DataSet ds = Feature.getFeatureUserAdapter(HelpNumber.ParseInt64(row["userid"].ToString()), "USER_FEATURE_TBL"); //DataViewManager dvManager = new DataViewManager(ds); //DataView dv = dvManager.CreateDataView(ds.Tables["USER_FEATURE_TBL"]); //gridControlFeature.DataSource = dv; //HUNG/// DataSet dsTemp = getUserFeatureAdapter1(HelpNumber.ParseInt64(row["userid"].ToString()), "USER_FEATURE_TBL"); setModifyFeatureDataSetAfterLoad(dsTemp); treeListFeature.KeyFieldName = "ID"; treeListFeature.ParentFieldName = "PARENTID"; treeListFeature.DataSource = dsTemp.Tables[0]; //treeListFeature.ExpandAll(); //----------------------------- //START : CHAUTV SetDisableFunction(dsTemp); //END : CHAUTV DataSet ds2 = BaoBieu.getReportUserAdapter(HelpNumber.ParseInt64(row["userid"].ToString()), "USER_REPORT_TBL"); DataViewManager dvManager2 = new DataViewManager(ds2); DataView dv2 = dvManager2.CreateDataView(ds2.Tables["USER_REPORT_TBL"]); gridControlReport.DataSource = dv2; getAllGroupByUserId(ref dsGetGroupByUser, HelpNumber.ParseInt64(row["userid"]), false); if (row["username"].ToString() == "admin") { this.btnDelete.Enabled = false; } else { this.btnDelete.Enabled = true; } } else { //gridControlFeature.DataSource = null; treeListFeature.DataSource = null; gridControlReport.DataSource = null; } }
private void loadGridViewGroupSelectionChanged() { if (gridViewGroup.FocusedRowHandle >= 0) { DataRow row = gridViewGroup.GetDataRow(gridViewGroup.FocusedRowHandle); //DataSet ds = Feature.getFeatureGroupAdapter(HelpNumber.ParseInt64(row["groupid"].ToString()), "GROUP_FEATURE_TBL"); //DataViewManager dvManager = new DataViewManager(ds); //DataView dv = dvManager.CreateDataView(ds.Tables["GROUP_FEATURE_TBL"]); //gridControlFeature.DataSource = dv; //HUNG DataSet dsTemp = getGroupFeatureAdapter1(HelpNumber.ParseInt64(row["groupid"].ToString()), "GROUP_FEATURE_TBL"); setModifyFeatureDataSetAfterLoad(dsTemp); treeListFeature.KeyFieldName = "ID"; treeListFeature.ParentFieldName = "PARENTID"; treeListFeature.DataSource = dsTemp.Tables[0]; //treeListFeature.ExpandAll(); //----------------------------- //S:CHAUTV SetDisableFunction(dsTemp); //E:CHAUTV DataSet ds2 = BaoBieu.getReportGroupAdapter(HelpNumber.ParseInt64(row["groupid"].ToString()), "GROUP_REPORT_TBL"); DataViewManager dvManager2 = new DataViewManager(ds2); DataView dv2 = dvManager2.CreateDataView(ds2.Tables["GROUP_REPORT_TBL"]); gridControlReport.DataSource = dv2; getAllUserByGroupId(ref dsGetUserByGroup, HelpNumber.ParseInt64(row["groupid"]), false); } else { //gridControlFeature.DataSource = null; treeListFeature.DataSource = null; gridControlReport.DataSource = null; } }
public static DataView LoadAllOperationLog() { DataSet ds = DAUserLog.Instance.loadDataSetOperationLog("USER_LOG"); DataViewManager dvManager = new DataViewManager(ds); DataView dv = dvManager.CreateDataView(ds.Tables["USER_LOG"]); return dv; }
public static DataView loadAllUser() { DataSet ds = DAUser.Instance.loadDataSetUser("USER_TBL"); DataViewManager dvManager = new DataViewManager(ds); DataView dv = dvManager.CreateDataView(ds.Tables["USER_TBL"]); return dv; }
private void Cargar_ComboTarjeta() { try { var BL = new tb_t1_tarjetaBL(); var BE = new tb_t1_tarjeta(); var ds = new DataSet(); BE.filtro = "2"; ds = BL.GetAll2(VariablesPublicas.EmpresaID, BE); var dvm = new DataViewManager(ds); DataView dvDropDown; dvDropDown = dvm.CreateDataView(ds.Tables[0]); glueTarjeta.Properties.View.OptionsBehavior.AutoPopulateColumns = false; glueTarjeta.Properties.DataSource = dvDropDown; glueTarjeta.Properties.DisplayMember = "tarjetaname"; glueTarjeta.Properties.ValueMember = "tarjetaid"; var col1 = glueTarjeta.Properties.View.Columns.AddField("tarjetalogo"); col1.VisibleIndex = 0; col1.Caption = "logo"; col1.Width = 20; var col2 = glueTarjeta.Properties.View.Columns.AddField("tarjetaname"); col2.VisibleIndex = 1; col2.Caption = "Nombre de Tarjeta"; col2.Width = 100; glueTarjeta.Properties.PopupFormWidth = 1; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void treeList1_Click(object sender, EventArgs e) { if (treeList1.Selection.Count == 0) return; DataSet ds = new DataSet(); List<PSPDEV> p1 = new List<PSPDEV>(); List<PSPDEV> p2 = new List<PSPDEV>(); string str = ""; string substr =""; decimal d1 = 0; decimal d2 = 0; for (int i = 0; i < treeList1.Selection.Count; i++) { TreeListNode info = treeList1.Selection[i]; string uid = info.GetValue("UID").ToString(); string tit = info.GetValue("Title").ToString(); d1 =d1+ Convert.ToDecimal(info.GetValue("L2")); string sql = " where Type='01' and SvgUID='" + uid + "' and ProjectID='" + MIS.ProgUID + "'"; IList<PSPDEV> list = Services.BaseService.GetList<PSPDEV>("SelectPSPDEVByCondition", sql); int num = 0; substr = tit; for (int j = 0; j < list.Count; j++) { PSPDEV dev = list[j]; string sql1 = " where Type='05' and (IName='" + dev.Name + "' or JName='" + dev.Name + "') and ProjectID='" + MIS.ProgUID + "'"; IList<PSPDEV> list1 = Services.BaseService.GetList<PSPDEV>("SelectPSPDEVByCondition", sql1); num = num + list1.Count; for (int m = 0; m < list1.Count;m++ ) { PSPDEV _p = list1[m]; d2 = d2 +Convert.ToDecimal(_p.Burthen) *Convert.ToDecimal(_p.RateVolt)/10000; if(_p.JName==dev.Name){ _p.IName = _p.JName; } } p2.AddRange(list1); } substr = substr + "变电站,包含母线"+list.Count.ToString()+"条。母线上连接的线路"+num.ToString()+"条。\r\n"; str = str + substr; p1.AddRange(list); } if(p1.Count==0){ p1.Add(new PSPDEV()); } if (p2.Count == 0) { //p2.Add(new PSPDEV()); } DataTable t1= DataConverter.ToDataTable(p1); //DataTable t2= DataConverter.ToDataTable(p2); System.Data.DataTable t2 = new DataTable("tb2"); DataColumn column; column = new DataColumn(); column.DataType = System.Type.GetType("System.String"); column.ColumnName = "Name"; column.ReadOnly = true; t2.Columns.Add(column); DataColumn column2; column2 = new DataColumn(); column2.DataType = System.Type.GetType("System.Int32"); column2.ColumnName = "Number"; column2.ReadOnly = true; t2.Columns.Add(column2); DataColumn column3; column3 = new DataColumn(); column3.DataType = System.Type.GetType("System.String"); column3.ColumnName = "IName"; column3.ReadOnly = true; t2.Columns.Add(column3); DataColumn column4; column4 = new DataColumn(); column4.DataType = System.Type.GetType("System.Double"); column4.ColumnName = "Burthen"; column4.ReadOnly = true; t2.Columns.Add(column4); for (int i = 0; i < p2.Count; i++) { DataRow row = t2.NewRow(); row["Name"] = p2[i].Name; row["Number"] = p2[i].Number; row["IName"] = p2[i].IName; row["Burthen"] = p2[i].Burthen; t2.Rows.Add(row); } ds.Tables.Add(t1); ds.Tables[0].TableName = "tb1"; ds.Tables.Add(t2); ds.Tables[1].TableName = "tb2"; DataColumn[] ds1 = { ds.Tables[0].Columns["Name"] }; DataColumn[] ds2 = {ds.Tables[1].Columns["IName"]}; ds.Relations.Add("OrderDetails", ds1, ds2); DataViewManager dvManager = new DataViewManager(ds); DataView dv = dvManager.CreateDataView(ds.Tables[0]); gridControl1.DataSource = dv; cardView1.OptionsBehavior.FieldAutoHeight = true; string s1 = ""; if (d1 > d2) { s1 = "选中的地区供电能力充足,剩余容量为" + Convert.ToString(d1 - d2) + "MVA。可以建设小于剩余容量的线路或下级变电站。"; } else { s1 = "选中的地区供电能力不足,缺少容量为" + Convert.ToString(Math.Abs((d1 - d2))) + "MVA。"; } memoEdit1.Text = "共选中变电站" + treeList1.Selection.Count + "座。\r\n" + str + "变电站容量之和为:"+d1.ToString()+"MVA,现有线路使用容量之和为:"+d2.ToString()+"MVA。\r\n"+s1; }