private void FrmTransferOut_Load(object sender, EventArgs e) { if (_type == "QD") { BUS.LIST_QDControl control = new BUS.LIST_QDControl(); dt = control.GetTransferOut_LIST_QD(_db, QD_CODE, ref sErr); } else if (_type == "QDADD") { BUS.LIST_QD_SCHEMAControl control = new BUS.LIST_QD_SCHEMAControl(); if (QD_CODE != "") { DTO.LIST_QD_SCHEMAInfo inf = control.Get(_db, QD_CODE, ref sErr); dt = inf.ToDataTable(); dt.Rows.Add(inf.ToDataRow(dt)); dt.TableName = "Table"; } else { dt = control.GetAll(_db, ref sErr); } } else if (_type == "TASK") { BUS.LIST_TASKControl control = new BUS.LIST_TASKControl(); if (QD_CODE != "") { DTO.LIST_TASKInfo inf = control.Get(_db, QD_CODE, ref sErr); dt = DTO.LIST_TASKInfo.ToDataTable(); dt.Rows.Add(inf.ToDataRow(dt)); dt.TableName = "Table"; } else { dt = control.GetAll(_db, ref sErr); } } else if (_type == "POD") { BUS.PODControl control = new BUS.PODControl(); if (QD_CODE != "") { DTO.PODInfo inf = control.Get(QD_CODE, ref sErr); dt = DTO.PODInfo.ToDataTable(); dt.Rows.Add(inf.ToDataRow(dt)); dt.TableName = "Table"; } else { dt = control.GetAll(ref sErr); } } dtEnd = dt.Copy(); radGridView1.DataSource = dtEnd; radGridView1.RetrieveStructure(); }
private void btnRefresh_Click(object sender, EventArgs e) { string sErr = ""; BUS.LIST_QD_SCHEMAControl ctr = new BUS.LIST_QD_SCHEMAControl(); DataTable dt = ctr.GetAll(_conn_ID, ref sErr); dt.Columns["SCHEMA_ID"].ColumnName = "Code"; //dgvQDADDView.AutoGenerateColumns = false; dgvQDADDView.DataSource = dt; //dgvQDADDView.AutoSizeColumns(); SaveLayout(dgvQDADDView); }
private void toolStripButton1_Click(object sender, EventArgs e) { string sErr = ""; BUS.LIST_QD_SCHEMAControl ctr = new BUS.LIST_QD_SCHEMAControl(); DataTable dt = ctr.GetAll(_db, ref sErr); foreach (DataRow row in dt.Rows) { DTO.LIST_QD_SCHEMAInfo inf = new DTO.LIST_QD_SCHEMAInfo(row); try { if (inf.FROM_TEXT[0] == '<') { } _data.Tables["_TableName"].Rows.Clear(); _data.Tables["fromcode"].Rows.Clear(); _data = ReadScheme(inf); DataTable dtfield = _data.Tables["_TableName"]; string field = "<?xml version=\"1.0\" encoding=\"utf-8\" ?><SUN_SCHEMA>{0}</SUN_SCHEMA>"; string tmp = ""; string from = ""; foreach (DataRow jrow in dtfield.Rows) { tmp += string.Format("<row table=\"{0}\" node=\"{1}\" name=\"{2}\" nodeDesc=\"{3}\" type=\"{4}\" conn_id=\"{5}\"/>", jrow["table"], jrow["node"], jrow["name"], jrow["nodeDesc"], jrow["type"], inf.DEFAULT_CONN); } DataTable dtfrom = _data.Tables["fromcode"]; field = string.Format(field, tmp); tmp = ""; foreach (DataRow jrow in dtfrom.Rows) { tmp += string.Format("<row fromcode=\"{0}\" lookup=\"{1}\"/> ", jrow["fromcode"], frmQDADD.XmlEncode(jrow["lookup"].ToString())); } from = tmp; //result = doc.InnerXml; inf.FIELD_TEXT = field; inf.FROM_TEXT = Form_QD.StringToBase64(from); ctr.Update(inf); } catch (Exception ex) { } } }
private void frmLookup_Load(object sender, EventArgs e) { string sErr = ""; BUS.LIST_QD_SCHEMAControl ctr = new BUS.LIST_QD_SCHEMAControl(); DataTable dt = ctr.GetAll(_db, ref sErr); if (_conn_ID != "") { dt.DefaultView.RowFilter = "DEFAULT_CONN='" + _conn_ID + "'"; } dt.Columns["SCHEMA_ID"].ColumnName = "Code"; //dgvQDADDView.AutoGenerateColumns = false; string DAField = "DAG"; if (_user != "TVC") { sErr = BUS.LIST_DAControl.SetDataAccessGroup(DAField, dt, _user); } LoadDataGrid(dgvQDADDView, dt); }