| | |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | //自定车间 |
| | | if (colType is UcLookWorkshop) |
| | | { |
| | | var txt = colType as UcLookWorkshop; |
| | | txt.SetIdOrCode(strVal); |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | //自定产线 |
| | | if (colType is UcLookWorkline) |
| | | { |
| | | var txt = colType as UcLookWorkline; |
| | | txt.SetIdOrCode(strVal); |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | //自定单位 |
| | | if (colType is UcLookUnit) |
| | | { |
| | | var txt = colType as UcLookUnit; |
| | | txt.SetIdOrCode(strVal); |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | |
| | | //自定客户 |
| | | if (colType is UcLookCustomer) |
| | | { |
| | | var txt = colType as UcLookCustomer; |
| | | txt.SetIdOrCode(strVal); |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | //自定员工 |
| | | if (colType is UcLookStaff) |
| | | { |
| | | var txt = colType as UcLookStaff; |
| | | txt.SetIdOrCode(strVal); |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | |
| | | if (colType is SimpleButton) |
| | | { |
| | | var txt = colType as SimpleButton; |
| | |
| | | txt.Enabled = !isEdt; |
| | | continue; |
| | | } |
| | | //自定车间 |
| | | if (ctrl is UcLookWorkshop) |
| | | { |
| | | var txt = ctrl as UcLookWorkshop; |
| | | txt.SetIdOrCode("-1"); |
| | | txt.Enabled = !isEdt; |
| | | continue; |
| | | } |
| | | //自定产线 |
| | | if (ctrl is UcLookWorkline) |
| | | { |
| | | var txt = ctrl as UcLookWorkline; |
| | | txt.SetIdOrCode("-1"); |
| | | txt.Enabled = !isEdt; |
| | | continue; |
| | | } |
| | | //自定单位 |
| | | if (ctrl is UcLookUnit) |
| | | { |
| | | var txt = ctrl as UcLookUnit; |
| | | txt.SetIdOrCode("-1"); |
| | | txt.Enabled = !isEdt; |
| | | continue; |
| | | } |
| | | //自定客户 |
| | | if (ctrl is UcLookCustomer) |
| | | { |
| | | var txt = ctrl as UcLookCustomer; |
| | | txt.SetIdOrCode("-1"); |
| | | txt.Enabled = !isEdt; |
| | | continue; |
| | | } |
| | | //自定客户 |
| | | if (ctrl is UcLookStaff) |
| | | { |
| | | var txt = ctrl as UcLookStaff; |
| | | txt.SetIdOrCode("-1"); |
| | | txt.Enabled = !isEdt; |
| | | continue; |
| | | } |
| | | if (ctrl is SimpleButton) |
| | | { |
| | | var txt = ctrl as SimpleButton; |
| | |
| | | ctrl.Enabled = !isEdt; |
| | | continue; |
| | | } |
| | | |
| | | // |
| | | if (ctrl is CheckEdit) |
| | | { |
| | | var txt = ctrl as CheckEdit; |
| | | txt.ReadOnly = isEdt; |
| | | continue; |
| | | } |
| | | //自定义仓库 |
| | | if (ctrl is UcLookCk) |
| | | { |
| | | var txt = ctrl as UcLookCk; |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | //自定义供应商 |
| | | if (ctrl is UcLookSupplier) |
| | | { |
| | | var txt = ctrl as UcLookSupplier; |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | //自定义物料 |
| | | if (ctrl is UcLookItems) |
| | | { |
| | | var txt = ctrl as UcLookItems; |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | //自定义车间 |
| | | if (ctrl is UcLookWorkshop) |
| | | { |
| | | var txt = ctrl as UcLookWorkshop; |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | //自定义产线 |
| | | if (ctrl is UcLookWorkline) |
| | | { |
| | | var txt = ctrl as UcLookWorkline; |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | //自定义单位 |
| | | if (ctrl is UcLookUnit) |
| | | { |
| | | var txt = ctrl as UcLookUnit; |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | //自定义客户 |
| | | if (ctrl is UcLookCustomer) |
| | | { |
| | | var txt = ctrl as UcLookCustomer; |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | //自定义员工 |
| | | if (ctrl is UcLookStaff) |
| | | { |
| | | var txt = ctrl as UcLookStaff; |
| | | if (txt.IsReadly == false) |
| | | txt.Enabled = !isEdt; |
| | | else |
| | | txt.Enabled = false; |
| | | continue; |
| | | } |
| | | } |
| | |
| | | , Label lbGuid |
| | | , TextEdit txtName |
| | | , GridView gridView1 |
| | | , string fileName = "" |
| | | , int SelectedTabPageIndex = 1) |
| | | { |
| | | var _strGuid = ""; |
| | |
| | | else |
| | | { |
| | | _strGuid = dr["guid"].ToString(); |
| | | _strName = dr[1].ToString(); |
| | | if (string.IsNullOrEmpty(fileName)) |
| | | _strName = dr[1].ToString(); |
| | | else |
| | | _strName = dr[fileName].ToString(); |
| | | } |
| | | } |
| | | |
| | |
| | | /// <param name="fm"></param> |
| | | /// <param name="fileName">对应的审核字段名称</param> |
| | | /// <param name="icoName"></param> |
| | | public static void SetCheckIco(object s, PictureBox btnChkIco, Form fm,string fileName= "checkStatus", string icoName="") |
| | | public static void SetCheckIco(object s, PictureBox btnChkIco, Form fm, string fileName = "checkStatus", string icoName = "") |
| | | { |
| | | GridView dgv = s as GridView; |
| | | if (dgv != null) { |
| | | if (dgv.GetSelectedRows() != null) { |
| | | if (dgv != null) |
| | | { |
| | | if (dgv.GetSelectedRows() != null) |
| | | { |
| | | var selectedRow = dgv.GetSelectedRows()[0]; // 获取第一个选中行的索引 |
| | | if (selectedRow >= 0) { |
| | | if (selectedRow >= 0) |
| | | { |
| | | var checkStatus = dgv.GetRowCellValue(selectedRow, fileName).ToString(); // 获取指定列的值 |
| | | btnChkIco.Text = checkStatus; |
| | | btnChkIco.Visible = true; |
| | |
| | | } |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | #region 设置搜索 |
| | | public static string getQueryWord(string str) |
| | | { |
| | | return str.ToUpper().Replace("query_".ToUpper(), ""); |
| | | } |
| | | public static FilterEntity getFilterEntityWord(string id, string idDec, string val) |
| | | { |
| | | return new FilterEntity(getQueryWord(id), idDec + ")", " like ", "包含)", "%" + val + "%"); |
| | | } |
| | | public static List<FilterEntity> GetDilter(GridColumnCollection Columns) |
| | | { |
| | | List<FilterEntity> fiList = new List<FilterEntity>(); |
| | | foreach (DevExpress.XtraGrid.Columns.GridColumn col in Columns) |
| | | { |
| | | ColumnFilterInfo filter = col.FilterInfo; |
| | | if (string.IsNullOrEmpty(filter.FilterString)) |
| | | continue; |
| | | // fiList.Add(new FilterEntity("b.FNumber", "使用组织", " like ", "包含", "%" + filter.Value + "%")); |
| | | string[] ddd = filter.FilterString.Replace("Contains","").Replace("(","").Replace(")","").Replace("'", "").Replace("'", "").Split(','); |
| | | //Contains([fSubsidiary], '005') |
| | | fiList.Add(getFilterEntityWord(col.Tag.ToString(), col.Caption.Trim(), ddd[1].Trim())); |
| | | } |
| | | return fiList; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 根据过滤器,读取查询条件,org表为组织 |
| | | /// </summary> |
| | | /// <param name="_filterList"></param> |
| | | /// <returns></returns> |
| | | public static string GetSearchWhere(List<FilterEntity> _filterList) |
| | | { |
| | | var _sbSqlWhere = new StringBuilder(); |
| | | foreach (var itm in _filterList) |
| | | { |
| | | if (itm.fileId.ToUpper().Contains("org".ToUpper())) |
| | | { |
| | | if (IsNumeric(itm.fileValue.Replace("%", ""))) |
| | | _sbSqlWhere.Append(" and org.FNumber " + itm.fileOper + "'" + itm.fileValue + "'"); |
| | | else |
| | | { |
| | | _sbSqlWhere.Append(" and org.NAME " + itm.fileOper + "'" + itm.fileValue.Trim() + "'"); |
| | | } |
| | | } |
| | | else |
| | | _sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" + |
| | | itm.fileValue + "'"); |
| | | } |
| | | return _sbSqlWhere.ToString(); |
| | | } |
| | | /// <summary> |
| | | /// 初始化gridview |
| | | /// </summary> |
| | | /// <param name="gridView1"></param> |
| | | public static void SetGridSear(GridView gridView1) |
| | | { |
| | | foreach (GridColumn column in gridView1.Columns) |
| | | { |
| | | column.OptionsFilter.AutoFilterCondition = AutoFilterCondition.Contains; |
| | | column.OptionsFilter.ImmediateUpdateAutoFilter = false; |
| | | column.OptionsColumn.AllowEdit = false; |
| | | if (column.Tag==null || column.Tag.ToString().Length <= 0) |
| | | column.OptionsFilter.AllowAutoFilter = false; |
| | | } |
| | | gridView1.OptionsFilter.AllowAutoFilterConditionChange = DevExpress.Utils.DefaultBoolean.False; |
| | | gridView1.OptionsFilter.AllowFilterEditor = false; |
| | | gridView1.OptionsFilter.ShowCustomFunctions = DevExpress.Utils.DefaultBoolean.False; |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | public static bool IsNumeric(string str) |
| | | { |
| | | Regex regex = new Regex("^[0-9]+$"); |
| | | return regex.IsMatch(str); |
| | | } |
| | | } |
| | | |
| | |
| | | { |
| | | return Text.ToString(); |
| | | } |
| | | |
| | | } |
| | | |
| | | /// <summary> |