~tjx/GsMesClient.git

			@@ -6,40 +6,68 @@
			using DevExpress.XtraEditors;
			using DevExpress.XtraEditors.Controls;
			using DevExpress.XtraGrid.Columns;
			using DevExpress.XtraGrid.Views.Grid;
			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)
			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;
			//
			gridView1.IndicatorWidth = gvTable.IndicatorWidth = gvQuery.IndicatorWidth = 50;
			gridView1.CustomDrawRowIndicator += (s, e) =>
			{
			if (e.Info.IsRowIndicator && e.RowHandle >= 0)
			e.Info.DisplayText = (e.RowHandle + 1).ToString();
			};
			gvTable.CustomDrawRowIndicator += (s, e) =>
			{
			if (e.Info.IsRowIndicator && e.RowHandle >= 0)
			e.Info.DisplayText = (e.RowHandle + 1).ToString();
			};
			gvQuery.CustomDrawRowIndicator += (s, e) =>
			{
			if (e.Info.IsRowIndicator && e.RowHandle >= 0)
			e.Info.DisplayText = (e.RowHandle + 1).ToString();
			};
			getPageList();
			//下面为查询配置
			this.btnSqlTable.Click += BtnSqlTable_Click;
			xtraTabControl1.SelectedPageChanged += (s, e) =>
			{
			if (xtraTabControl1.SelectedTabPageIndex == 1)
			getPageListQuery();
			};
			}


			/// <summary>
			/// 查询集合
			/// </summary>
			@@ -74,16 +102,16 @@
			.GetRowCellValue(i, "fieldWhere").ToString());
			var _fieldValue = gridView1.GetRowCellValue(i, "fieldValue")
			.ToString();
			var _fieldType = gridView1.GetRowCellValue(i, "fieldType")
			.ToString();
			if (_fileWhere.Contains("like"))
			{
			_fileWhere = " like ";
			_fieldValue = "%" + _fieldValue + "%";
			}

			list.Add(new FilterEntity(_fieId, _fileIdDec, _fileWhere,
			_fileWhereDec, _fieldValue));
			_fileWhereDec, _fieldValue, _fieldType));
			}

			UpdateParent?.Invoke(this,
			new UpdateParentEventArgs { FilterList = list });
			Close();
			@@ -94,13 +122,13 @@
			private void getPageList()
			{
			foreach (GridColumn col in _columns)
			if (col.Tag != null && col.Tag.ToString().StartsWith("query"))
			if (col.Tag != null && !string.IsNullOrEmpty(col.Tag.ToString()))
			{
			var item = new CboItemEntity();
			item.Text = col.Tag.ToString().Replace("query_a.", "") +
			"（" + col.Caption + "）";
			item.Text = col.Tag.ToString() + "(" + col.Caption + ")";
			//item.Value = col.FieldName;
			item.Value = col.Tag.ToString().Replace("query_a.", "");
			item.Value = col.Tag.ToString();
			item.FType = col.UnboundExpression;
			repositoryItemComboBox1.Items.Add(item);
			}

			@@ -113,26 +141,26 @@
			foreach (var kvp in d2)
			{
			var item = new CboItemEntity();
			item.Text = kvp.Key + "（" + kvp.Value + "）";
			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));
			dt.Columns.Add("fieldValue", typeof(string));
			dt.Columns.Add("fieldType", typeof(string));
			foreach (var _sql in FilterList)
			{
			var dr = dt.NewRow();
			dr["field"] = _sql.fileId + "（" + _sql.fileIdDec;
			dr["fieldWhere"] = _sql.fileOper + "（" + _sql.fileOperDec;
			dr["field"] = _sql.fileId + "(" + _sql.fileIdDec;
			dr["fieldWhere"] = _sql.fileOper + "(" + _sql.fileOperDec;
			dr["fieldValue"] = _sql.fileValue.Replace("%", "");
			dr["fieldType"] = _sql.fileType;
			dt.Rows.Add(dr);
			}

			gcMain.BindingContext = new BindingContext();
			gcMain.DataSource = dt;
			gcMain.ForceInitialize();
			@@ -145,7 +173,7 @@

			private (string, string) _getFiled(string _field)
			{
			return (_field.Split('（')[0], _field.Split('（')[1]);
			return (_field.Split('(')[0], _field.Split('(')[1]);
			}

			private void BtnEsc_Click(object sender, EventArgs e)
			@@ -163,11 +191,6 @@
			}
			}

			private void RepositoryItemComboBox2_SelectedIndexChanged(object sender,
			EventArgs e)
			{
			}

			private void RepositoryItemComboBox1_ParseEditValue(object sender,
			ConvertEditValueEventArgs e)
			{
			@@ -175,12 +198,297 @@
			{
			e.Value = e.Value.ToString();
			e.Handled = true;

			}
			}
			private void repositoryItemComboBox1_SelectedValueChanged(object sender, EventArgs e)
			{
			ComboBoxEdit comboBox = sender as ComboBoxEdit;
			if (comboBox != null)
			{
			CboItemEntity _itm = comboBox.EditValue as CboItemEntity;
			string dddd = _itm.Value.ToString();
			string ccc = _itm.Text.ToString();
			string yyy = _itm.FType.ToString();
			GridView myView = (gcMain.MainView as GridView);
			int dataIndex = myView.GetDataSourceRowIndex(myView.FocusedRowHandle);
			myView.CloseEditor();
			myView.UpdateCurrentRow();
			myView.SetRowCellValue(dataIndex, "fieldType", yyy);
			}
			}

			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

			private void BtnSqlTable_Click(object sender, EventArgs e)
			{
			if (string.IsNullOrEmpty(_fullName))
			{
			Gs.DevApp.ToolBox.MsgHelper.Warning("请选择页面！");
			return;
			}
			var _obj = new
			{
			formPath = _fullName,
			list = new List<dynamic>(),
			};
			gvTable.CloseEditor();
			gvTable.UpdateCurrentRow();
			if (gvTable.DataRowCount <= 0)
			{
			MsgHelper.ShowError("明细不能为空，请选择你的明细！");
			return;
			}
			for (var i = 0; i < gvTable.DataRowCount; i++)
			{
			var row = gvTable.GetDataRow(i);
			if (row != null)
			{
			string _msl = row["tableOtherName"].ToString();
			if (string.IsNullOrEmpty(_msl))
			{
			MsgHelper.ShowError("别名不能为空！");
			return;
			}
			_obj.list.Add(new
			{
			tableName = (row["tableName"].ToString()),
			tableOtherName = row["tableOtherName"].ToString(),
			});
			}
			}
			try
			{
			string strJson = UtilityHelper.HttpPost("", "Fm/EditQuery", JsonConvert.SerializeObject(_obj));
			ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
			ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);
			if (_rtn.rtnCode > 0)
			{
			getPageListQuery();
			}
			}
			catch (Exception ex)
			{
			ToolBox.MsgHelper.Warning("提示：" + ex.Message);
			}

			}
			private void getPageListQuery()
			{
			repositoryItemComboBoxSql.Items.Clear();
			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 array00 = new JArray();
			foreach (var a in _job["rtnData"]["list3"])
			{
			array00.Add(a);
			}
			DataTable dt00 = JsonConvert.DeserializeObject<DataTable>(array00.ToString());
			this.repositoryItemSearchLookUpEdit1.DataSource = dt00;
			//读前选择
			JArray array01 = new JArray();
			foreach (var a in _job["rtnData"]["list4"])
			{
			array01.Add(a);
			repositoryItemComboBoxSql.Items.Add(a["tableOtherName"].ToString());
			}
			////////////
			JArray array = new JArray();
			foreach (var a in _job["rtnData"]["list"])
			{
			array.Add(a);
			}
			DataTable dt = JsonConvert.DeserializeObject<DataTable>(array.ToString());
			if (dt.Rows.Count > 0)
			{
			gcTable.BindingContext = new BindingContext();
			gcTable.DataSource = dt;
			gcTable.ForceInitialize();
			gvTable.BestFitColumns();
			}
			else
			{
			Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcTable, gvTable);
			}
			////////////
			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();
			gvQuery.BestFitColumns();
			}
			catch (Exception ex)
			{
			MsgHelper.Warning("提示：" + ex.Message);
			}
			}

			private void repositoryItemSearchLookUpEdit1_EditValueChanged(object sender, EventArgs e)
			{
			SearchLookUpEdit LookupEdit = sender as SearchLookUpEdit;
			DataRowView SelectedDataRow = (DataRowView)LookupEdit.GetSelectedDataRow();
			gvTable.SetFocusedRowCellValue("tableName", SelectedDataRow["tableName"].ToString());
			gvTable.SetFocusedRowCellValue("tableCap", SelectedDataRow["tableCap"].ToString());
			gvTable.CloseEditor();
			gvTable.PostEditor();
			gvTable.UpdateCurrentRow();
			}
			private void repositoryItemButtonEdit2_ButtonClick(object sender, ButtonPressedEventArgs e)
			{
			var rowhandle = gvTable.FocusedRowHandle;
			if (rowhandle < 0)
			return;
			if (e.Button.Index == 0)
			{
			var dr = gvTable.GetDataRow(rowhandle);
			var mxGuid = dr["guid"].ToString();
			if (!MsgHelper.AskQuestion("你选择了1条数据，确定删除吗？"))
			return;
			if (string.IsNullOrEmpty(mxGuid))
			{
			gvTable.DeleteRow(rowhandle);
			return;
			}
			var _obj = new
			{
			guid = mxGuid,
			};
			try
			{
			var strJson = UtilityHelper.HttpPost("",
			"Fm/DeleteQuery",
			JsonConvert.SerializeObject(_obj));
			var _rtn = UtilityHelper.ReturnToDynamic(strJson);
			if (_rtn.rtnCode > 0)
			{
			// getPageListQuery();
			}
			MsgHelper.Warning("提示：" + _rtn.rtnMsg);
			}
			catch (Exception ex)
			{
			MsgHelper.Warning("提示：" + ex.Message);
			}
			}
			}
			private void repositoryItemComboBoxSql_EditValueChanged(object sender, EventArgs e)
			{
			ComboBoxEdit comboBox = sender as ComboBoxEdit;
			if (comboBox != null)
			{
			GridView myView = (gcQuery.MainView as GridView);
			int dataIndex = myView.GetDataSourceRowIndex(myView.FocusedRowHandle);
			string _txt = comboBox.Text.Trim();
			var dr = myView.GetDataRow(dataIndex);
			var mxGuid = dr["guid"].ToString();
			if (mxGuid.Length > 0 && _txt.Length > 0)
			{
			var _obj = new
			{
			guid = mxGuid,
			sqlField = _txt,
			fType=0,
			};
			try
			{
			var strJson = UtilityHelper.HttpPost("",
			"Fm/EditCol",
			JsonConvert.SerializeObject(_obj));
			var _rtn = UtilityHelper.ReturnToDynamic(strJson);
			if (_rtn.rtnCode <= 0)
			{
			MsgHelper.ShowError("提示：" + _rtn.rtnMsg);
			}
			}
			catch (Exception ex)
			{
			MsgHelper.Warning("提示：" + ex.Message);
			}
			}
			}
			}

			private void repositoryItemComboBox3Sql_EditValueChanged(object sender, EventArgs e)
			{
			ComboBoxEdit comboBox = sender as ComboBoxEdit;
			if (comboBox != null)
			{
			GridView myView = (gcQuery.MainView as GridView);
			int dataIndex = myView.GetDataSourceRowIndex(myView.FocusedRowHandle);
			string _txt = comboBox.Text.Trim();
			var dr = myView.GetDataRow(dataIndex);
			var mxGuid = dr["guid"].ToString();
			if (mxGuid.Length > 0 )
			{
			var _obj = new
			{
			guid = mxGuid,
			fType = 1,
			sqlFieldType = _txt
			};
			try
			{
			var strJson = UtilityHelper.HttpPost("",
			"Fm/EditCol",
			JsonConvert.SerializeObject(_obj));
			var _rtn = UtilityHelper.ReturnToDynamic(strJson);
			if (_rtn.rtnCode <= 0)
			{
			MsgHelper.ShowError("提示：" + _rtn.rtnMsg);
			}
			}
			catch (Exception ex)
			{
			MsgHelper.Warning("提示：" + ex.Message);
			}
			}
			}
			}

			#endregion
			}
			}