lu
2025-02-19 9cdebe64f7ce63aee080491dec6d108466527432
DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQmAql1.cs
@@ -1,14 +1,14 @@
using DevExpress.XtraGrid.Views.Grid;
using DevExpress.XtraGrid.Views.Grid.ViewInfo;
using Gs.DevApp.DevFrm.QC.Models;
using Gs.DevApp.Entity;
using Gs.DevApp.ToolBox;
using Gs.DevApp.UserControl;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace Gs.DevApp.DevFrm.QC
@@ -20,6 +20,34 @@
        public Frm_MesQmAql1()
        {
            InitializeComponent();
            object[] _objAry = {  "A",
            "B",
            "C",
            "D",
            "E",
            "F",
            "G",
            "H",
            "I",
            "J",
            "K",
            "L",
            "M",
            "N",
            "O",
            "P",
            "Q",
            "R",
            "S",
            "T"};
            this.repositoryItemComboBox1.Items.AddRange(_objAry);
            this.repositoryItemComboBox2.Items.AddRange(_objAry);
            this.repositoryItemComboBox3.Items.AddRange(_objAry);
            this.repositoryItemComboBox4.Items.AddRange(_objAry);
            this.repositoryItemComboBox5.Items.AddRange(_objAry);
            this.repositoryItemComboBox6.Items.AddRange(_objAry);
            this.repositoryItemComboBox7.Items.AddRange(_objAry);
            this.repositoryItemComboBox8.Items.AddRange(_objAry);
            this.toolBarMenu1.btnAddClick += ToolBarMenu1_btnAddClick;
            this.toolBarMenu1.btnEdtClick += ToolBarMenu1_btnEdtClick;
            this.toolBarMenu1.btnSaveClick += ToolBarMenu1_btnSaveClick;
@@ -30,49 +58,61 @@
            toolBarMenu1.btnChkClick += ToolBarMenu1_btnChkClick;
            toolBarMenu1.btnFChkClick += ToolBarMenu1_btnFChkClick;
            toolBarMenu1.btnPiZhunClick += ToolBarMenu1_btnPiZhunClick;
            gcMain.MouseDoubleClick += GcMain_MouseDoubleClick;
            getPageList(1, UtilityHelper.GetPageSize());
            Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx( gvMx1);
           Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx2);
             Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1,picCheckBox, this, "foneChecked", "", (value) =>
            {
                Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 0);
            });
            Gs.DevApp.ToolBox.UtilityHelper.SetTabParameter(gridView1, xtraTabControl1, pageBar1, (value) =>
            {
                getModel(value);
            }, (value) =>
            {
                getPageList(this.pageBar1.CurrentPage);
            });
            getPageList(1);
            pageBar1.PagerEvent += PageBar1_PagerEvent;
            gridView1.CustomDrawRowIndicator += (s, e) =>
            {
                if (e.Info.IsRowIndicator && e.RowHandle >= 0)
                {
                    e.Info.DisplayText = (e.RowHandle + 1).ToString();
                }
            };
            gridView1.CustomDrawEmptyForeground += (s, e) =>
            {
                string str = "暂未查找到匹配的数据!";
                Font f = new Font("微软雅黑", 16);
                Rectangle r = new Rectangle(gridView1.GridControl.Width / 2 - 100, e.Bounds.Top + 45, e.Bounds.Right - 5, e.Bounds.Height - 5);
                e.Graphics.DrawString(str, f, Brushes.Gray, r);
            };
        }
        private void GridView1_ColumnFilterChanged(object sender, EventArgs e)
        {
            Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1);
            Task.Delay(100);
            getPageList(1);
        }
        /// <summary>
        /// 批准
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ToolBarMenu1_btnPiZhunClick(object sender, EventArgs e)
        {
            //批准
            string rowGuid, rowName;
            (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1,
                lbGuid, txt_sampleSizeNo, gridView1);
                lbGuid, txt_sampleSizeNo, gridView1, "sampleSizeNo");
            try
            {
                string strJson = UtilityHelper.HttpPost("", _webServiceName + "Approval", JsonConvert.SerializeObject(rowGuid));
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
                ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg);
                if (_rtn.rtnCode > 0)
                {
                    UtilityHelper.JumpToTab(xtraTabControl1, 0);
                    getPageList(1, UtilityHelper.GetPageSize());
                    if (xtraTabControl1.SelectedTabPageIndex == 1)
                    {
                        getModel(lbGuid.Text.Trim());
                    }
                    int rowHandle = gridView1.LocateByValue(1, gridView1.Columns["guid"], rowGuid);
                    gridView1.FocusedRowHandle = rowHandle;
                    gridView1.SetFocusedRowCellValue("ftwoChecked", true);
                    gridView1.SetFocusedRowCellValue("isenabled", true);
                    gridView1.SetFocusedRowCellValue("ftwoCheckor", "已批准");
                    gridView1.SetFocusedRowCellValue("ftwoCheckdate", DateTime.Now.ToString());
                }
                ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg);
            }
            catch (Exception ex)
            {
                ToolBox.MsgHelper.Warning("提示:" + ex.Message);
            }
        }
        /// <summary>
@@ -83,11 +123,7 @@
        /// <exception cref="NotImplementedException"></exception>
        private void ToolBarMenu1_btnFChkClick(object sender, EventArgs e)
        {
            toolBarMenu1.guidKey = "";
            string rowGuid, rowName;
            (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1,
                lbGuid, txt_sampleSizeNo, gridView1);
            toolBarMenu1.guidKey = rowGuid;
            _toolCk(0);
        }
        /// <summary>
@@ -97,24 +133,9 @@
        /// <param name="e"></param>
        private void ToolBarMenu1_btnChkClick(object sender, EventArgs e)
        {
            toolBarMenu1.guidKey = "";
            string rowGuid, rowName;
            (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1,
                lbGuid, txt_sampleSizeNo, gridView1);
            toolBarMenu1.guidKey = rowGuid;
            _toolCk(1);
        }
        /// <summary>
        /// 双击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void GcMain_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            string rowGuid = Gs.DevApp.ToolBox.UtilityHelper.GetCurrentDoubleRow(gridView1, e, "guid");
            if (!string.IsNullOrEmpty(rowGuid))
                getModel(rowGuid, false, 999);
        }
        /// <summary>
        /// 分页事件
        /// </summary>
@@ -122,7 +143,7 @@
        /// <param name="pageSize"></param>
        private void PageBar1_PagerEvent(int curPage, int pageSize)
        {
            getPageList(curPage, pageSize);
            getPageList(curPage);
        }
        /// <summary>
        /// 查询事件
@@ -131,7 +152,10 @@
        /// <param name="e"></param>
        private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e)
        {
            Gs.DevApp.UserControl.ShowFilter frm = new Gs.DevApp.UserControl.ShowFilter(gridView1.Columns, _filterList);
            gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
            gridView1.ActiveFilter.Clear();
            gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
            var frm = new ShowFilter(gridView1.Columns, _filterList);
            frm.UpdateParent += Frm_UpdateParent;
            frm.ShowDialog();
        }
@@ -143,9 +167,8 @@
        private void Frm_UpdateParent(object sender, UpdateParentEventArgs e)
        {
            _filterList = e.FilterList;
            getPageList(1, pageBar1.RowsCount);
            getPageList(1);
        }
        /// <summary>
        /// 取消事件
        /// </summary>
@@ -153,7 +176,7 @@
        /// <param name="e"></param>
        private void ToolBarMenu1_btnEscClick(object sender, EventArgs e)
        {
            UtilityHelper.JumpToTab(xtraTabControl1, 0);
            Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 1);
        }
        /// <summary>
@@ -164,7 +187,7 @@
        private void ToolBarMenu1_btnDelClick1(object sender, EventArgs e)
        {
            string rowGuid = "", rowName = "";
             (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_sampleSizeNo, gridView1);
            (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_sampleSizeNo, gridView1, "sampleSizeNo");
            if (string.IsNullOrEmpty(rowGuid))
            {
                ToolBox.MsgHelper.Warning("请先选择你要操作的行!");
@@ -181,8 +204,11 @@
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
                if (_rtn.rtnCode > 0)
                {
                    UtilityHelper.JumpToTab(xtraTabControl1, 0);
                    getPageList(1, UtilityHelper.GetPageSize());
                    if (xtraTabControl1.SelectedTabPageIndex == 0)
                    { }
                    else
                        Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 2);
                    getPageList(this.pageBar1.CurrentPage);
                }
                ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg);
            }
@@ -199,8 +225,20 @@
        /// <param name="e"></param>
        private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e)
        {
            UtilityHelper.JumpToTab(xtraTabControl1, 0);
            getPageList(1, UtilityHelper.GetPageSize());
            if (xtraTabControl1.SelectedTabPageIndex == 1)
                getModel(lbGuid.Text.Trim());
            else
            {
                //_filterList.Clear();
                //if (gridView1.ActiveFilter.Count > 0)
                //{
                //    gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
                //    gridView1.ActiveFilter.Clear();
                //    gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
                //}
                //getPageList(1);
                getPageList(this.pageBar1.CurrentPage);
            }
        }
        /// <summary>
        /// 修改事件
@@ -210,13 +248,23 @@
        private void ToolBarMenu1_btnEdtClick(object sender, EventArgs e)
        {
            string rowGuid = "", rowName = "";
             (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_sampleSizeNo, gridView1);
            (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_sampleSizeNo, gridView1);
            if (string.IsNullOrEmpty(rowGuid))
            {
                ToolBox.MsgHelper.Warning("请先选择你要操作的行!");
                return;
            }
            getModel(rowGuid, true, 1);
            Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 3);
            if (xtraTabControl1.SelectedTabPageIndex == 1)
            {
                getModel(rowGuid);
            }
            else {
                List<GridView> gridViews = new List<GridView>();
                gridViews.Add(gvMx1);
                gridViews.Add(gvMx2);
                UtilityHelper.ChangeEnableByControl(panel1.Controls, true, gridViews);
            }
        }
        /// <summary>
        /// 新增事件
@@ -225,31 +273,15 @@
        /// <param name="e"></param>
        private void ToolBarMenu1_btnAddClick(object sender, EventArgs e)
        {
            UtilityHelper.JumpToTab(xtraTabControl1, 1);
            lbGuid.Text = "";
            Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 4);
            List<GridView> gridViews = new List<GridView>();
            gridViews.Add(gvMx1);
            gridViews.Add(gvMx2);
            UtilityHelper.CleanValueByControl(this.panel1.Controls, true, gridViews);
            UtilityHelper.SetDefaultTable(gcMx1, gvMx1);
             UtilityHelper.SetDefaultTable(gcMx1, gvMx1);
            UtilityHelper.SetDefaultTable(gcMx2, gvMx2);
            txt_createDate.Text = DateTime.Now.ToString("G");
            txt_createDate.Enabled = false;
            txt_ftwoChecked.Text = "False";
            txt_ftwoChecked.Enabled = false;
            txt_isenabled.Text = "False";
            txt_isenabled.Enabled = false;
            txt_foneChecked.Text = "False";
            txt_foneChecked.Enabled = false;
            txt_createName.Enabled = false;
            txt_foneCheckor.Enabled = false;
            txt_ftwoCheckor.Enabled = false;
            txt_ftwoCheckdate.Enabled = false;
            txt_foneCheckdate.Enabled = false;
            txt_fversion.Text = "1";
        }
        /// <summary>
@@ -273,97 +305,136 @@
                txt_sampleSizeName.Focus();
                return;
            }
            gvMx1.CloseEditor();
            gvMx1.UpdateCurrentRow();
            gvMx2.CloseEditor();
            gvMx2.UpdateCurrentRow();
            var qmaql2 = new List<MesQmAql2>();
            for (var i = 0; i < gvMx1.DataRowCount; i++)
            {
                var row = gvMx1.GetDataRow(i);
                if (row != null)
                    qmaql2.Add(new MesQmAql2
                    {
                        Guid = UtilityHelper.ToGuid(row["Guid"].ToString()),
                        LotFrom =  Convert.ToInt32(row["LotFrom"].ToString()),
                        LotTo =  Convert.ToInt32(row["LotTo"].ToString()),
                        FlevelS1 =   row["FlevelS1"].ToString(),
                        FlevelS2 =  row["FlevelS2"].ToString(),
                        FlevelS3 =  row["FlevelS3"].ToString(),
                        FlevelS4 =  row["FlevelS4"].ToString(),
                        FlevelI =  row["FlevelI"].ToString(),
                        FlevelIi = row["FlevelIi"].ToString(),
                        FlevelIii = row["FlevelIii"].ToString(),
                        Memo = row["Memo"].ToString()
                    });
            }
            var qmaql3 = new List<MesQmAql3>();
            for (var i = 0; i < gvMx2.DataRowCount; i++)
            {
                var row = gvMx2.GetDataRow(i);
                if (row != null)
                    qmaql3.Add(new MesQmAql3
                    {
                        Guid = UtilityHelper.ToGuid(row["Guid"].ToString()),
                        FsampleSizeWord = Convert.ToInt32(row["FsampleSizeWord"].ToString()),
                        SampleSizeWord =  row["SampleSizeWord"].ToString(),
                        Aql00010 = Convert.ToInt32(row["Aql00010"].ToString()),
                        Aql00015 = Convert.ToInt32(row["Aql00015"].ToString()),
                        Aql00025 = Convert.ToInt32(row["Aql00025"].ToString()),
                        Aql00040 = Convert.ToInt32(row["Aql00040"].ToString()),
                        Aql00065 = Convert.ToInt32(row["Aql00065"].ToString()),
                        Aql0010 = Convert.ToInt32(row["Aql0010"].ToString()),
                        Aql0015 = Convert.ToInt32(row["Aql0015"].ToString()),
                        Aql0025 = Convert.ToInt32(row["Aql0025"].ToString()),
                        Aql0040 = Convert.ToInt32(row["Aql0040"].ToString()),
                        Aql0065 = Convert.ToInt32(row["Aql0065"].ToString()),
                        Aql0100 = Convert.ToInt32(row["Aql0100"].ToString()),
                        Aql0150 = Convert.ToInt32(row["Aql0150"].ToString()),
                        Aql0250 = Convert.ToInt32(row["Aql0250"].ToString()),
                        Aql0400 = Convert.ToInt32(row["Aql0400"].ToString()),
                        Aql0650 = Convert.ToInt32(row["Aql0650"].ToString()),
                        Aql1000 = Convert.ToInt32(row["Aql1000"].ToString()),
                        Memo = row["Memo"].ToString()
                    });
            }
            var _obj = new MesQmAql1
            {
                Guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()),
                SampleSizeNo = txt_sampleSizeNo.Text.Trim(),
                SampleSizeName = txt_sampleSizeName.Text.Trim(),
                Memo = txt_memo.Text.Trim(),
                CreateDate = DateTime.Now,
                FtwoChecked = false,
                Isenabled = false,
                FoneChecked = false,
                Fversion =  Convert.ToInt32(txt_fversion.Text.Trim()),
                MesQmAql2s = qmaql2,
                MesQmAql3s = qmaql3
            };
            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)
                var qmaql2 = new List<MesQmAql2>();
                for (var i = 0; i < gvMx1.DataRowCount; i++)
                {
                    lbGuid.Text = _rtn.rtnData;
                    toolBarMenu1.isSetBtn = true;
                    UtilityHelper.ChangeEnableByControl(this.panel1.Controls, false);
                    var row = gvMx1.GetDataRow(i);
                    if (row != null)
                    {
                        if (string.IsNullOrEmpty(row["LotFrom"].ToString()))
                        {
                            MsgHelper.ShowError("批量开始不能为空!");
                            return;
                        }
                        if (string.IsNullOrEmpty(row["LotTo"].ToString()))
                        {
                            MsgHelper.ShowError("批量结束不能为空!");
                            return;
                        }
                        qmaql2.Add(new MesQmAql2
                        {
                            Guid = UtilityHelper.ToGuid(row["Guid"].ToString()),
                            LotFrom = Convert.ToInt32(row["LotFrom"].ToString()),
                            LotTo = Convert.ToInt32(row["LotTo"].ToString()),
                            FlevelS1 = row["FlevelS1"].ToString(),
                            FlevelS2 = row["FlevelS2"].ToString(),
                            FlevelS3 = row["FlevelS3"].ToString(),
                            FlevelS4 = row["FlevelS4"].ToString(),
                            FlevelI = row["FlevelI"].ToString(),
                            FlevelIi = row["FlevelIi"].ToString(),
                            FlevelIii = row["FlevelIii"].ToString(),
                            Memo = row["Memo"].ToString()
                        });
                    }
                }
                var qmaql3 = new List<MesQmAql3>();
                for (var i = 0; i < gvMx2.DataRowCount; i++)
                {
                    var row = gvMx2.GetDataRow(i);
                    if (row != null)
                    {
                        if (string.IsNullOrEmpty(row["FsampleSizeWord"].ToString()))
                        {
                            MsgHelper.ShowError("样本大小不能为空!");
                            return;
                        }
                        if (string.IsNullOrEmpty(row["SampleSizeWord"].ToString()))
                        {
                            MsgHelper.ShowError("样本字码不能为空!");
                            return;
                        }
                        qmaql3.Add(new MesQmAql3
                        {
                            Guid = UtilityHelper.ToGuid(row["Guid"].ToString()),
                            FsampleSizeWord = Convert.ToInt32(row["FsampleSizeWord"].ToString()),
                            SampleSizeWord = row["SampleSizeWord"].ToString(),
                            Aql00010 = Convert.ToInt32(row["Aql00010"].ToString()),
                            Aql00015 = Convert.ToInt32(row["Aql00015"].ToString()),
                            Aql00025 = Convert.ToInt32(row["Aql00025"].ToString()),
                            Aql00040 = Convert.ToInt32(row["Aql00040"].ToString()),
                            Aql00065 = Convert.ToInt32(row["Aql00065"].ToString()),
                            Aql0010 = Convert.ToInt32(row["Aql0010"].ToString()),
                            Aql0015 = Convert.ToInt32(row["Aql0015"].ToString()),
                            Aql0025 = Convert.ToInt32(row["Aql0025"].ToString()),
                            Aql0040 = Convert.ToInt32(row["Aql0040"].ToString()),
                            Aql0065 = Convert.ToInt32(row["Aql0065"].ToString()),
                            Aql0100 = Convert.ToInt32(row["Aql0100"].ToString()),
                            Aql0150 = Convert.ToInt32(row["Aql0150"].ToString()),
                            Aql0250 = Convert.ToInt32(row["Aql0250"].ToString()),
                            Aql0400 = Convert.ToInt32(row["Aql0400"].ToString()),
                            Aql0650 = Convert.ToInt32(row["Aql0650"].ToString()),
                            Aql1000 = Convert.ToInt32(row["Aql1000"].ToString()),
                            Memo = row["Memo"].ToString()
                        });
                    }
                }
                if (qmaql2.Count <= 0)
                {
                    Gs.DevApp.ToolBox.MsgHelper.Warning("样本量子码不能为空!");
                    return;
                }
                if (qmaql3.Count <= 0)
                {
                    Gs.DevApp.ToolBox.MsgHelper.Warning("抽样方案不能为空!");
                    return;
                }
                var _obj = new MesQmAql1
                {
                    Guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()),
                    SampleSizeNo = txt_sampleSizeNo.Text.Trim(),
                    SampleSizeName = txt_sampleSizeName.Text.Trim(),
                    Memo = txt_memo.Text.Trim(),
                    CreateDate = DateTime.Now,
                    FtwoChecked = false,
                    Isenabled = false,
                    FoneChecked = false,
                    Fversion = Convert.ToInt32(txt_fversion.Text.Trim()),
                    MesQmAql2s = qmaql2,
                    MesQmAql3s = qmaql3
                };
                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;
                        toolBarMenu1.isSetBtn = true;
                        List<GridView> gridViews = new List<GridView>();
                        gridViews.Add(gvMx1);
                        gridViews.Add(gvMx2);
                        UtilityHelper.ChangeEnableByControl(this.panel1.Controls, false, gridViews);
                        toolBarMenu1.currentAction = "";
                    }
                }
                catch (Exception ex)
                {
                    ToolBox.MsgHelper.Warning("提示:" + ex.Message);
                }
            }
            catch (Exception ex)
            {
                ToolBox.MsgHelper.Warning("提示:" + ex.Message);
                ToolBox.MsgHelper.ShowError("提示:" + ex.Message);
            }
        }
        /// <summary>
@@ -371,14 +442,10 @@
        /// </summary>
        /// <param name="curPage">第几页</param>
        /// <param name="pageSize">每页几条</param>
        private void getPageList(int curPage, int pageSize)
        private void getPageList(int curPage)
        {
            System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
            foreach (FilterEntity itm in _filterList)
            {
                _sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" + itm.fileValue + "'");
            }
            PageQueryModel pgq = new PageQueryModel(curPage, pageSize, "create_date", "asc", "", _sbSqlWhere.ToString());
            var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList);
            PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "create_date", "asc", "", _sbSqlWhere.ToString());
            string json = JsonConvert.SerializeObject(pgq);
            try
            {
@@ -388,14 +455,19 @@
                {
                    DataTable dt = dd.rtnData.list;
                    gcMain.BindingContext = new BindingContext();
                    gcMain.DataSource = dt;
                    gcMain.ForceInitialize();
                    int dddd = dd.rtnData.pages;//总页
                    pageBar1.TotalPages = dddd;
                    pageBar1.RecordCount = dd.rtnData.total;//记录总数
                    gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
                    if (dt.Rows.Count > 0)
                    {
                        gcMain.DataSource = dt;
                        gcMain.ForceInitialize();
                        gridView1.BestFitColumns();
                    }
                    else
                        UtilityHelper.SetDefaultTable(gcMain, gridView1);
                    gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
                    pageBar1.TotalPages = dd.rtnData.pages;//总页
                    pageBar1.CurrentPage = curPage;//当前页
                    pageBar1.RowsCount = pageSize;//每页显示
                    pageBar1.setTxt();
                    pageBar1.RecordCount = dd.rtnData.total;//总记录数
                }
                else
                {
@@ -407,14 +479,16 @@
                ToolBox.MsgHelper.Warning("提示:" + ex.Message);
            }
        }
        private void getModel(string strGuid, bool isEdit, int tabIdx)
        private void getModel(string strGuid)
        {
            bool isEdit = false;
            if (toolBarMenu1.currentAction == "add") return;
            if (toolBarMenu1.currentAction == "edit") isEdit = true;
            if (string.IsNullOrEmpty(strGuid))
            {
                ToolBox.MsgHelper.Warning("请先选择你要操作的行!");
                return;
            }
            UtilityHelper.JumpToTab(xtraTabControl1, tabIdx);
            var _obj = new
            {
                guid = strGuid,//主建
@@ -438,37 +512,34 @@
                    {
                        array.Add(a);
                    }
                    DataTable dt = JsonConvert.DeserializeObject<DataTable>(array.ToString());
                    if (dt.Rows.Count > 0)
                    {
                        gcMx1.BindingContext = new BindingContext();
                        gcMx1.DataSource = dt;
                        gcMx1.ForceInitialize();
                        gvMx1.BestFitColumns();
                    }
                    else
                    {
                        Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcMx1, gvMx1);
                    }
                    foreach (var a in _job["rtnData"]["mesQmAql3s"])
                    {
                        mesQmAql3s.Add(a);
                    }
                    DataTable dt1 = JsonConvert.DeserializeObject<DataTable>(mesQmAql3s.ToString());
                    if (dt1.Rows.Count > 0)
                    {
                        gcMx2.BindingContext = new BindingContext();
                        gcMx2.DataSource = dt1;
                        gcMx2.ForceInitialize();
                        gvMx2.BestFitColumns();
                    }
                    else
                    {
                        Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcMx2, gvMx2);
                    }
                }
                else
                    ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg);
@@ -479,5 +550,138 @@
            }
        }
        private void repositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            gvMx1.CloseEditor();
            gvMx1.UpdateCurrentRow();
            var rowhandle = gvMx1.FocusedRowHandle;
            if (rowhandle < 0)
                return;
            if (e.Button.Index == 0)
            {
                var dr = gvMx1.GetDataRow(rowhandle);
                var mxGuid = dr["guid"].ToString();
                if (!MsgHelper.AskQuestion("你选择了1条数据,确定删除吗?"))
                    return;
                if (string.IsNullOrEmpty(mxGuid))
                {
                    gvMx1.DeleteRow(rowhandle);
                    return;
                }
                var strJson = "";
                var lst = new List<string>();
                lst.Add(mxGuid);
                try
                {
                    strJson = UtilityHelper.HttpPost("",
                        _webServiceName + "DeleteModelMx",
                        JsonConvert.SerializeObject(lst));
                    var _rtn =
                        UtilityHelper.ReturnToDynamic(strJson);
                    if (_rtn.rtnCode > 0) getModel(lbGuid.Text);
                    MsgHelper.Warning("提示:" + _rtn.rtnMsg);
                }
                catch (Exception ex)
                {
                    MsgHelper.Warning("提示:" + ex.Message);
                }
            }
        }
        private void repositoryItemButtonEdit2_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            gvMx2.CloseEditor();
            gvMx2.UpdateCurrentRow();
            var rowhandle = gvMx2.FocusedRowHandle;
            if (rowhandle < 0)
                return;
            if (e.Button.Index == 0)
            {
                var dr = gvMx2.GetDataRow(rowhandle);
                var mxGuid = dr["guid"].ToString();
                if (!MsgHelper.AskQuestion("你选择了1条数据,确定删除吗?"))
                    return;
                if (string.IsNullOrEmpty(mxGuid))
                {
                    gvMx1.DeleteRow(rowhandle);
                    return;
                }
                var strJson = "";
                var lst = new List<string>();
                lst.Add(mxGuid);
                try
                {
                    strJson = UtilityHelper.HttpPost("",
                        _webServiceName + "DeleteModelMx2",
                        JsonConvert.SerializeObject(lst));
                    var _rtn =
                        UtilityHelper.ReturnToDynamic(strJson);
                    if (_rtn.rtnCode > 0) getModel(lbGuid.Text);
                    MsgHelper.Warning("提示:" + _rtn.rtnMsg);
                }
                catch (Exception ex)
                {
                    MsgHelper.Warning("提示:" + ex.Message);
                }
            }
        }
        /// <summary>
        /// 工具条事件
        /// </summary>
        /// <param name="inFieldValue"></param>
        private void _toolCk(int _inFieldValue)
        {
            string strMsg = "";
            switch (_inFieldValue)
            {
                case 1:
                    strMsg = "审核";
                    break;
                case 0:
                    strMsg = "反审核";
                    break;
            };
            toolBarMenu1.guidKey = "";
            string rowGuid, rowName;
            (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_sampleSizeNo, gridView1, "sampleSizeNo");
            if (string.IsNullOrEmpty(rowGuid))
            {
                MsgHelper.Warning("请先选择你要操作的行!");
                return;
            }
            if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】,确定" + strMsg + "吗?"))
                return;
            var _obj = new
            {
                guid = rowGuid,
                ckValue = _inFieldValue,
                parameter = "MES_QM_AQL1,FONE_CHECKDATE,FONE_CHECKED,FONE_CHECKOR,chk_mesQmAql1"
            };
            try
            {
                var strJson = UtilityHelper.HttpPost("", "General/GeneralCheck",
                    JsonConvert.SerializeObject(_obj));
                var _rtn = UtilityHelper.ReturnToDynamic(strJson);
                MsgHelper.Warning(_rtn.rtnData.outMsg.ToString());
                if (_rtn.rtnCode > 0)
                {
                    if (xtraTabControl1.SelectedTabPageIndex == 1)
                    {
                        getModel(lbGuid.Text.Trim());
                    }
                    int rowHandle = gridView1.LocateByValue(1, gridView1.Columns["guid"], rowGuid);
                    gridView1.FocusedRowHandle = rowHandle;
                    UtilityHelper.SetCheckIco(gridView1, "foneChecked", "foneCheckor", "foneCheckdate", picCheckBox, this, _inFieldValue.ToString());
                }
            }
            catch (Exception ex)
            {
                MsgHelper.Warning("提示:" + ex.Message);
            }
        }
    }
}