|
public CreateDataView ( |
||
| table | ||
| Résultat | ||
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;
}
