¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.Data.SqlTypes; |
| | | using System.Text; |
| | | using System.Windows.Forms; |
| | | using DevExpress.Pdf.Native.BouncyCastle.Utilities.Collections; |
| | | using DevExpress.PivotGrid.OLAP.Mdx; |
| | | using DevExpress.Utils.DirectXPaint; |
| | | using DevExpress.XtraEditors; |
| | | using DevExpress.XtraEditors.Controls; |
| | | using DevExpress.XtraEditors.Repository; |
| | | using DevExpress.XtraGrid.Columns; |
| | | using DevExpress.XtraGrid.Views.Base.ViewInfo; |
| | | using FastReport.MSChart; |
| | | using Gs.DevApp.Entity; |
| | | using Gs.DevApp.ToolBox; |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Linq; |
| | | |
| | | namespace Gs.DevApp.UserControl |
| | | { |
| | | public partial class ShowFilter : XtraForm |
| | | { |
| | | private readonly GridColumnCollection _columns; |
| | | private readonly string _fullName; |
| | | /// <summary> |
| | | /// |
| | | /// </summary> |
| | | /// <param name="Columns">åå</param> |
| | | /// <param name="list">é»è®¤å¼</param> |
| | | /// <param name="FullName">ç±»å</param> |
| | | public ShowFilter(GridColumnCollection Columns, |
| | | List<FilterEntity> list = null, string FullName = "") |
| | | { |
| | | FilterList = list; |
| | | _columns = Columns; |
| | | _fullName = FullName; |
| | | InitializeComponent(); |
| | | repositoryItemComboBox1.TextEditStyle = |
| | | TextEditStyles.DisableTextEditor; |
| | | repositoryItemComboBox1.SelectedIndexChanged += |
| | | RepositoryItemComboBox1_SelectedIndexChanged; |
| | | repositoryItemComboBox1.ParseEditValue += |
| | | RepositoryItemComboBox1_ParseEditValue; |
| | | repositoryItemComboBox2.TextEditStyle = |
| | | TextEditStyles.DisableTextEditor; |
| | | repositoryItemComboBox2.SelectedIndexChanged += |
| | | RepositoryItemComboBox2_SelectedIndexChanged; |
| | | repositoryItemComboBox2.ParseEditValue += |
| | | RepositoryItemComboBox2_ParseEditValue; |
| | | gridView1.OptionsFind.ShowSearchNavButtons = false; |
| | | // this.gridView1.OptionsView.ShowAutoFilterRow = true; |
| | | gridView1.OptionsView.ShowGroupPanel = false; |
| | | gvQuery.OptionsView.ShowGroupPanel = false; |
| | | gvTable.OptionsView.ShowGroupPanel = false; |
| | | btnEsc.Click += BtnEsc_Click; |
| | | btnQuery.Click += BtnQuery_Click; |
| | | getPageList(); |
| | | //ä¸é¢ä¸ºæ¥è¯¢é
ç½® |
| | | this.btnSqlTable.Click += BtnSqlTable_Click; |
| | | getPageListQuery(); |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// æ¥è¯¢éå |
| | | /// </summary> |
| | | public List<FilterEntity> FilterList { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åè°äºä»¶ |
| | | /// </summary> |
| | | public event EventHandler<UpdateParentEventArgs> UpdateParent; |
| | | |
| | | private void BtnQuery_Click(object sender, EventArgs e) |
| | | { |
| | | gridView1.CloseEditor(); |
| | | gridView1.UpdateCurrentRow(); |
| | | var sbWhere = new StringBuilder(); |
| | | var list = new List<FilterEntity>(); |
| | | for (var i = 0; i < gridView1.DataRowCount; i++) |
| | | { |
| | | if (string.IsNullOrEmpty(gridView1.GetRowCellValue(i, "field") |
| | | .ToString()) |
| | | || string.IsNullOrEmpty(gridView1 |
| | | .GetRowCellValue(i, "fieldWhere").ToString()) |
| | | || string.IsNullOrEmpty(gridView1 |
| | | .GetRowCellValue(i, "fieldValue").ToString()) |
| | | ) |
| | | continue; |
| | | string _fieId, _fileIdDec; |
| | | (_fieId, _fileIdDec) = |
| | | _getFiled(gridView1.GetRowCellValue(i, "field").ToString()); |
| | | string _fileWhere, _fileWhereDec; |
| | | (_fileWhere, _fileWhereDec) = _getFiled(gridView1 |
| | | .GetRowCellValue(i, "fieldWhere").ToString()); |
| | | var _fieldValue = gridView1.GetRowCellValue(i, "fieldValue") |
| | | .ToString(); |
| | | if (_fileWhere.Contains("like")) |
| | | { |
| | | _fileWhere = " like "; |
| | | _fieldValue = "%" + _fieldValue + "%"; |
| | | } |
| | | |
| | | list.Add(new FilterEntity(_fieId, _fileIdDec, _fileWhere, |
| | | _fileWhereDec, _fieldValue)); |
| | | } |
| | | |
| | | UpdateParent?.Invoke(this, |
| | | new UpdateParentEventArgs { FilterList = list }); |
| | | Close(); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// </summary> |
| | | private void getPageList() |
| | | { |
| | | foreach (GridColumn col in _columns) |
| | | if (col.Tag != null && col.Tag.ToString().StartsWith("query")) |
| | | { |
| | | var item = new CboItemEntity(); |
| | | item.Text = col.Tag.ToString().Replace("query_", "") + |
| | | "ï¼" + col.Caption + "ï¼"; |
| | | //item.Value = col.FieldName; |
| | | item.Value = col.Tag.ToString().Replace("query_", ""); |
| | | repositoryItemComboBox1.Items.Add(item); |
| | | } |
| | | |
| | | var d2 = new Dictionary<string, string>(); |
| | | d2.Add(">", "大äº"); |
| | | d2.Add("<", "å°äº"); |
| | | d2.Add("=", "çäº"); |
| | | d2.Add("<>", "ä¸çäº"); |
| | | d2.Add("like", "å
å«"); |
| | | foreach (var kvp in d2) |
| | | { |
| | | var item = new CboItemEntity(); |
| | | item.Text = kvp.Key + "ï¼" + kvp.Value + "ï¼"; |
| | | item.Value = kvp.Key; |
| | | repositoryItemComboBox2.Items.Add(item); |
| | | } |
| | | try |
| | | { |
| | | var dt = new DataTable(); |
| | | dt.Columns.Add("field", typeof(string)); |
| | | dt.Columns.Add("fieldWhere", typeof(string)); |
| | | dt.Columns.Add("fieldValue", typeof(string)); |
| | | foreach (var _sql in FilterList) |
| | | { |
| | | var dr = dt.NewRow(); |
| | | dr["field"] = _sql.fileId + "ï¼" + _sql.fileIdDec; |
| | | dr["fieldWhere"] = _sql.fileOper + "ï¼" + _sql.fileOperDec; |
| | | dr["fieldValue"] = _sql.fileValue.Replace("%", ""); |
| | | dt.Rows.Add(dr); |
| | | } |
| | | gcMain.BindingContext = new BindingContext(); |
| | | gcMain.DataSource = dt; |
| | | gcMain.ForceInitialize(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | MsgHelper.Warning("æç¤ºï¼" + ex.Message); |
| | | } |
| | | } |
| | | |
| | | private (string, string) _getFiled(string _field) |
| | | { |
| | | return (_field.Split('ï¼')[0], _field.Split('ï¼')[1]); |
| | | } |
| | | |
| | | private void BtnEsc_Click(object sender, EventArgs e) |
| | | { |
| | | Close(); |
| | | } |
| | | |
| | | private void RepositoryItemComboBox2_ParseEditValue(object sender, |
| | | ConvertEditValueEventArgs e) |
| | | { |
| | | if (e.Value != null) |
| | | { |
| | | e.Value = e.Value.ToString(); |
| | | e.Handled = true; |
| | | } |
| | | } |
| | | |
| | | private void RepositoryItemComboBox2_SelectedIndexChanged(object sender, |
| | | EventArgs e) |
| | | { |
| | | } |
| | | |
| | | private void RepositoryItemComboBox1_ParseEditValue(object sender, |
| | | ConvertEditValueEventArgs e) |
| | | { |
| | | if (e.Value != null) |
| | | { |
| | | e.Value = e.Value.ToString(); |
| | | e.Handled = true; |
| | | } |
| | | } |
| | | |
| | | private void RepositoryItemComboBox1_SelectedIndexChanged(object sender, |
| | | EventArgs e) |
| | | { |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// ç§»åºä¸è¡ |
| | | /// </summary> |
| | | /// <param name="sender"></param> |
| | | /// <param name="e"></param> |
| | | private void repositoryItemButtonEdit1_ButtonClick(object sender, ButtonPressedEventArgs e) |
| | | { |
| | | gridView1.CloseEditor(); |
| | | gridView1.UpdateCurrentRow(); |
| | | var rowhandle = gridView1.FocusedRowHandle; |
| | | if (rowhandle < 0) |
| | | return; |
| | | if (e.Button.Index == 0) |
| | | { |
| | | var dr = gridView1.GetDataRow(rowhandle); |
| | | gridView1.DeleteRow(rowhandle); |
| | | return; |
| | | } |
| | | } |
| | | |
| | | |
| | | #region MyRegion |
| | | /// <summary> |
| | | /// æªå表å |
| | | /// </summary> |
| | | /// <param name="strName"></param> |
| | | /// <returns></returns> |
| | | private string _getTableName(string strName) |
| | | { |
| | | var _tableName = strName.Split('(')[0]; |
| | | return _tableName; |
| | | } |
| | | private void BtnSqlTable_Click(object sender, EventArgs e) |
| | | { |
| | | //System.Text.StringBuilder sb = new System.Text.StringBuilder(); |
| | | //var list = txt_table.Properties.Items.GetCheckedValues(); |
| | | //foreach (var obj in list) |
| | | //{ |
| | | // if (sb.Length > 0) |
| | | // sb.Append(","); |
| | | // sb.Append(_getTableName(obj.ToString())); |
| | | |
| | | //} |
| | | |
| | | //if (sb.Length < 0) |
| | | //{ |
| | | // Gs.DevApp.ToolBox.MsgHelper.Warning("è¯·éæ©å
³è表ï¼"); |
| | | // txt_table.Focus(); |
| | | // return; |
| | | //} |
| | | |
| | | //var _obj = new |
| | | //{ |
| | | // guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //主建 |
| | | // djlx = djlx,//åæ®ç±»å |
| | | // salesId = _sqGuid,//éå®åå· |
| | | // inRemark = FNote.Trim(),//夿³¨ |
| | | // list = new List<dynamic>(), |
| | | //}; |
| | | //try |
| | | //{ |
| | | // string strJson = UtilityHelper.HttpPost("", _webServiceName + "EditModel", JsonConvert.SerializeObject(_obj)); |
| | | // ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); |
| | | // ToolBox.MsgHelper.Warning("æç¤ºï¼" + _rtn.rtnMsg); |
| | | // if (_rtn.rtnCode > 0) |
| | | // { |
| | | // lbGuid.Text = _rtn.rtnData.outGuid; |
| | | // txt_billNo.Text = _rtn.rtnData.outNo; |
| | | // toolBarMenu1.isSetBtn = true; |
| | | // List<DevExpress.XtraGrid.Views.Grid.GridView> gvList = new List<DevExpress.XtraGrid.Views.Grid.GridView>(); |
| | | // gvList.Add(gvMx1); |
| | | // UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, false, gvList); |
| | | // toolBarMenu1.currentAction = ""; |
| | | // } |
| | | //} |
| | | //catch (Exception ex) |
| | | //{ |
| | | // ToolBox.MsgHelper.Warning("æç¤ºï¼" + ex.Message); |
| | | //} |
| | | |
| | | } |
| | | private void getPageListQuery() |
| | | { |
| | | repositoryItemComboBoxSql.Items.Clear(); |
| | | repositoryItemComboBoxSql.Items.Add("1"); |
| | | repositoryItemComboBoxSql.Items.Add("1"); |
| | | repositoryItemComboBoxSql.Items.Add("1"); |
| | | var _obj = new |
| | | { |
| | | formPath = this._fullName, |
| | | list = new List<dynamic>(), |
| | | }; |
| | | foreach (GridColumn col in _columns) |
| | | { |
| | | _obj.list.Add(new |
| | | { |
| | | colName = col.Name.ToString(), |
| | | colCap = col.Caption |
| | | }); |
| | | } |
| | | try |
| | | { |
| | | var strJson = UtilityHelper.HttpPost("", |
| | | "Fm/GetQuery", JsonConvert.SerializeObject(_obj)); |
| | | ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); |
| | | JObject _job = JObject.Parse(strJson); |
| | | //////////// |
| | | JArray array = new JArray(); |
| | | foreach (var a in _job["rtnData"]["list"]) |
| | | { |
| | | array.Add(a); |
| | | } |
| | | DataTable dt = JsonConvert.DeserializeObject<DataTable>(array.ToString()); |
| | | gcTable.BindingContext = new BindingContext(); |
| | | gcTable.DataSource = dt; |
| | | gcTable.ForceInitialize(); |
| | | //////////// |
| | | JArray array2 = new JArray(); |
| | | foreach (var a in _job["rtnData"]["list2"]) |
| | | { |
| | | array2.Add(a); |
| | | } |
| | | DataTable dt2 = JsonConvert.DeserializeObject<DataTable>(array2.ToString()); |
| | | gcQuery.BindingContext = new BindingContext(); |
| | | gcQuery.DataSource = dt2; |
| | | gcQuery.ForceInitialize(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | MsgHelper.Warning("æç¤ºï¼" + ex.Message); |
| | | } |
| | | } |
| | | #endregion |
| | | } |
| | | } |