jisco_winform_wzjl/StorageMeterSystem/frmHotDeliveryActual.cs

using com.hnshituo.core.webapp.vo;
using Common;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using JC_MeasuringSystem;
using Microsoft.VisualBasic;
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Windows.Forms;

namespace StorageMeterSystem
{
    public partial class frmHotDeliveryActual : Form
    {
        private PreStorageScaleService scaleService = new PreStorageScaleService(); //预报服务
        private MeterWorkStorageActualService actualService = new MeterWorkStorageActualService(); //实绩服务
        private ComBaseInfoService comBaseInfoService = new ComBaseInfoService(); //基础数服务
        private MeterBaseScalePointService scalePointService = new MeterBaseScalePointService(); //计量点信息服务
        private MeterWorkStorageActual storageActualG = new MeterWorkStorageActual(); //预报实体类

        private Log l = Log.GetInstance(); //日志
        private string userId = "", userName = ""; //用户ID用户名
        private CoreAppUser appUser = null;//登陆信息

        public frmHotDeliveryActual()
        {
            InitializeComponent();
        }

        private void frmHotDeliveryActual_Load(object sender, EventArgs e)
        {
            ClsControlPack.SetNoEnable(ultraGridScale);
            ClsControlPack.UseFixedHeader(ultraGridScale, "netWeight");

            this.ultraGridScale.DisplayLayout.ViewStyleBand = ViewStyleBand.OutlookGroupBy;
            this.ultraGridScale.DisplayLayout.GroupByBox.Hidden = true;

            userId = ((ST_MainForm)(this.MdiParent)).UserID;
            userName = ((ST_MainForm)(this.MdiParent)).UserName;
            appUser = ((ST_MainForm)(this.MdiParent)).AppUser;

            dtStartTime.Value = Convert.ToDateTime((DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00"));
            dtEndTime.Value = Convert.ToDateTime((DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59"));

            dtStartTimeSC.Value = Convert.ToDateTime((DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00"));
            dtEndTimeSC.Value = Convert.ToDateTime((DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59"));
            #region 载入基础信息

            /*
            string sql = @"SELECT base_code baseCode,base_name baseName,memo FROM Com_Base_Info where p_base_code='001025' and valid_Flag='1'";
            PbModelDbService<List<ComBaseInfo>> pb = new PbModelDbService<List<ComBaseInfo>>();
            RESTfulResult<List<ComBaseInfo>> rmType = pb.executeSqlDataWf(sql);
            if (rmType.Succeed && rmType.Data != null && rmType.Data.Count > 0)
            {
                ClsControlPack.SetUltraComboDataSource(cmbScaleState, rmType.Data.ListToDataTable<ComBaseInfo>(), "baseCode", "baseName");
            }
            else
            {
                MessageBox.Show("产品信息载入失败");
                return;
            }

            */

            //计量点信息载入cmbPoint;cmbPointUp
            RESTfulResult<List<MeterBaseScalePoint>> rr = scalePointService.doQueryWf(new MeterBaseScalePoint { validFlag = "1", spotTypeNo = "001002004" });
            if (rr.Succeed && rr.Data != null && rr.Data.Count > 0)
            {
                ClsControlPack.SetUltraComboDataSource(cmbPoint, rr.Data.ListToDataTable<MeterBaseScalePoint>(), "baseSpotNo", "baseSpotName");
                ClsControlPack.SetUltraComboDataSource(cmbPointUp, rr.Data.ListToDataTable<MeterBaseScalePoint>(), "baseSpotNo", "baseSpotName");
            }
            else
            {
                MessageBox.Show("计量点载入失败!");
                return;
            }

            //热送磅规格信息载入cmbSpcNameUp
            RESTfulResult<List<ComBaseInfo>> rrComSpcName = comBaseInfoService.doQueryBaseList(new ComBaseInfo { validFlag = "1", pBaseCode = "001018" });
            if (rrComSpcName.Succeed && rrComSpcName.Data != null && rrComSpcName.Data.Count > 0)
            {
                rrComSpcName.Data.Sort((a, b) => a.baseName.CompareTo(b.baseName));
                ClsControlPack.SetUltraComboDataSource(cmbSpcNameUp, rrComSpcName.Data.ListToDataTable<ComBaseInfo>(), "baseCode", "baseName");
                ClsControlPack.SetUltraComboDataSource(cmbSpcName, rrComSpcName.Data.ListToDataTable<ComBaseInfo>(), "baseCode", "baseName");
            }
            else
            {
                MessageBox.Show("热送磅规格信息载入失败!");
                return;
            }

            //热送磅钢种信息载入cmbGradeNameUp
            RESTfulResult<List<ComBaseInfo>> rrComGradeName = comBaseInfoService.doQueryBaseList(new ComBaseInfo { validFlag = "1", pBaseCode = "001017" });
            if (rrComGradeName.Succeed && rrComGradeName.Data != null && rrComGradeName.Data.Count > 0)
            {
                rrComGradeName.Data.Sort((a, b) => a.baseName.CompareTo(b.baseName));
                ClsControlPack.SetUltraComboDataSource(cmbGradeNameUp, rrComGradeName.Data.ListToDataTable<ComBaseInfo>(), "baseCode", "baseName");
                ClsControlPack.SetUltraComboDataSource(cmbGradeName, rrComGradeName.Data.ListToDataTable<ComBaseInfo>(), "baseCode", "baseName");
            }
            else
            {
                MessageBox.Show("热送磅钢种信息载入失败!");
                return;
            }

            //热送磅班次信息载入cmbMeterClassUp
            RESTfulResult<List<ComBaseInfo>> rrComMeterClass = comBaseInfoService.doQueryBaseList(new ComBaseInfo { validFlag = "1", pBaseCode = "001043" });
            if (rrComMeterClass.Succeed && rrComMeterClass.Data != null && rrComMeterClass.Data.Count > 0)
            {
                ClsControlPack.SetUltraComboDataSource(cmbMeterClassUp, rrComMeterClass.Data.ListToDataTable<ComBaseInfo>(), "baseCode", "baseName");
                ClsControlPack.SetUltraComboDataSource(cmbMeterClass, rrComMeterClass.Data.ListToDataTable<ComBaseInfo>(), "baseCode", "baseName");
            }
            else
            {
                MessageBox.Show("热送磅班次信息载入失败!");
                return;
            }

            //热送磅班组信息载入cmbMeterGroupUp
            RESTfulResult<List<ComBaseInfo>> rrComMeterGroop = comBaseInfoService.doQueryBaseList(new ComBaseInfo { validFlag = "1", pBaseCode = "001044" });
            if (rrComMeterGroop.Succeed && rrComMeterGroop.Data != null && rrComMeterGroop.Data.Count > 0)
            {
                ClsControlPack.SetUltraComboDataSource(cmbMeterGroupUp, rrComMeterGroop.Data.ListToDataTable<ComBaseInfo>(), "baseCode", "baseName");
                ClsControlPack.SetUltraComboDataSource(cmbMeterGroup, rrComMeterGroop.Data.ListToDataTable<ComBaseInfo>(), "baseCode", "baseName");
            }
            else
            {
                MessageBox.Show("热送磅班组信息载入失败!");
                return;
            }

            //数据状态
            ValueList vlistScale = new ValueList();
            vlistScale.ValueListItems.Add("", "全部");
            vlistScale.ValueListItems.Add("0", "无效");
            vlistScale.ValueListItems.Add("1", "有效");
            cmbScaleState.ValueList = vlistScale;
            cmbScaleState.SelectedIndex = 0;

            ValueList vlistFlag2 = new ValueList();
            vlistFlag2.ValueListItems.Add("", "全部");
            vlistFlag2.ValueListItems.Add("0", "未审核");
            vlistFlag2.ValueListItems.Add("1", "已审核");
            cmbCheckState.ValueList = vlistFlag2;
            cmbCheckState.SelectedIndex = 0;

            ValueList vlistFlag3 = new ValueList();
            vlistFlag3.ValueListItems.Add("0", "无效");
            vlistFlag3.ValueListItems.Add("1", "有效");
            this.ultraGridScale.DisplayLayout.Bands[0].Columns["valueFlag"].ValueList = vlistFlag3;

            ValueList vlistFlag4 = new ValueList();
            vlistFlag4.ValueListItems.Add("0", "未审核");
            vlistFlag4.ValueListItems.Add("1", "已审核");
            this.ultraGridScale.DisplayLayout.Bands[0].Columns["checkFlag"].ValueList = vlistFlag4;
            //ClsControlPack.SetUltraGridRowFilter(ref ultraGridScale, true);

            #endregion 载入基础信息
        }

        #region 点击事件

        /// <summary>
        /// 点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "btnQuery": //btnInsert
                    {
                        btnQuery();
                        break;
                    }
                case "btnInsert": //新增
                    {
                        btnInsert();
                        break;
                    }
                case "btnCancel": //作废
                    {
                        btnUpdate("0");
                    }
                    break;

                case "btnUnCancel": //还原
                    {
                        btnUpdate("1");
                    }
                    break;

                case "btnUpdate": //修改
                    {
                        btnUpdate("");
                    }
                    break;

                case "btnCheck": //审核
                    {
                        btnUpdate("审核");
                    }
                    break;
                case "btnEditXh": //编辑序号：将序号置为可编辑
                    {
                        //ClsControlPack.SetNoEnable(ultraGridScale, new List<string> { "packageNo" });
                        ultraGridScale.DisplayLayout.Bands[0].Columns["packageNo"].CellClickAction = CellClickAction.Edit;
                        ultraGridScale.DisplayLayout.Bands[0].Columns["packageNo"].CellActivation = Activation.AllowEdit;
                        ultraGridScale.DisplayLayout.Bands[0].Columns["packageNo"].CellAppearance.BackColor = Color.Orange;
                    }
                    break;
                case "btnUpdateXh": //批量修改序号
                    {
                        btnUpdateXh();
                    }
                    break;
                case "btnExcelOut": //导出
                    {
                        string str = Interaction.InputBox("请输入要导出的文件名", "提示", "", 100, 100);
                        string pqath = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);

                        this.ultraGridExcelExporter1.Export(this.ultraGridScale, pqath + "\\" + str + ".xls");
                        //MessageUtil.ShowTips("导出成功，请查看桌面！是否有[" + str + ".xls]表格");
                        MessageBox.Show("导出成功，请查看桌面！是否有[" + str + ".xls]表格");
                    }
                    break;

                default: break;
            }
        }

        /// <summary>
        /// 选择框勾选事件，给下面的区域赋值
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGridScale_CellChange(object sender, CellEventArgs e)
        {
            clickCell();
        }

        /// <summary>
        /// 除顺序号，界面不可编辑
        /// </summary>
        private void updateBoxUnEnable()
        {
            cmbPointUp.Enabled = false;
            tbHeatNoUp.Enabled = false;
            cmbSpcNameUp.Enabled = false;
            cmbGradeNameUp.Enabled = false;
            tbTheoreticalWeightUp.Enabled = false;
            cmbMeterClassUp.Enabled = false;
            cmbMeterGroupUp.Enabled = false;
            //tbPackageNoUp.Enabled = false; //使用中的预报，顺序号可以修改，服务端取预报与实绩表中相对大的那一个值 +1  作为最新的顺序号
            tbBlockNumUp.Enabled = false;
        }

        /// <summary>
        /// 界面可编辑
        /// </summary>
        private void updateBoxEnable()
        {
            cmbPointUp.Enabled = true;
            tbHeatNoUp.Enabled = true;
            cmbSpcNameUp.Enabled = true;
            cmbGradeNameUp.Enabled = true;
            tbTheoreticalWeightUp.Enabled = true;
            cmbMeterClassUp.Enabled = true;
            cmbMeterGroupUp.Enabled = true;
            tbPackageNoUp.Enabled = true;
            tbBlockNumUp.Enabled = true;
        }

        /// <summary>
        /// 全选点击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cbAll_CheckedChanged(object sender, EventArgs e)
        {
            foreach (UltraGridRow ugr in ultraGridScale.Rows)
            {
                if (!ugr.HiddenResolved)
                {
                    ugr.Cells["UNCK"].Value = cbAll.Checked;
                }
            }
        }

        /// <summary>
        /// 界面重量变化的时候，重新计算一遍重量
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void numCollectWeight_ValueChanged(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(numCollectWeight.Text) || string.IsNullOrEmpty(numReferWeight.Text)
                || string.IsNullOrEmpty(numTareWeight.Text) || string.IsNullOrEmpty(numNetWeight.Text))
            {
                MessageBox.Show("采集重量、仪表底数、零点值、净重的值均不允许为空！");
                return;
            }
            //净重；净重=采集重量 + 零点值- 仪表底数
            numNetWeight.Value = (decimal)(Convert.ToDouble(numCollectWeight.Value) + Convert.ToDouble(numTareWeight.Value) - Convert.ToDouble(numReferWeight.Value));
        }

        /// <summary>
        /// 按照炉号查询预报信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tbHeatNoUp_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                queryHeatNo();
            }
        }

        /// <summary>
        /// 按照炉号查询预报信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tbPredictionNo_KeyDown(object sender, KeyEventArgs e)
        {
            queryPredictionNo();
        }

        /// <summary>
        /// 过磅时间复选框
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cbCrt_CheckedChanged(object sender, EventArgs e)
        {
            if (cbCrt.Checked)
            {
                cbPrd.Checked = false;
            }
            else
            {
                cbPrd.Checked = true;
            }
        }

        /// <summary>
        /// 生产时间复选框
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cbPrd_CheckedChanged(object sender, EventArgs e)
        {
            if (cbPrd.Checked)
            {
                cbCrt.Checked = false;
            }
            else
            {
                cbCrt.Checked = true;
            }
        }

        /// <summary>
        /// 是否开启过滤
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ckFilter_CheckedChanged(object sender, EventArgs e)
        {
            if (ckFilter.Checked)
            {
                this.ultraGridScale.DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.True;
            }
            else
            {
                this.ultraGridScale.DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.False;
            }
        }

        #endregion 点击事件

        /// <summary>
        /// 行点击事件
        /// </summary>
        private void clickCell()
        {
            try
            {
                if (ultraGridScale.ActiveRow == null)
                {
                    return;
                }
                ultraGridScale.UpdateData();
                UltraGridRow ugr = ultraGridScale.ActiveRow;
                if (ugr.Cells["UNCK"].Value.ToString().ToUpper().Equals("TRUE"))
                {
                    //界面赋值
                    if (ugr != null)
                    {
                        storageActualG.actualNo = ugr.Cells["actualNo"].Text.Trim(); //实绩编号
                        storageActualG.predictionNo = ugr.Cells["predictionNo"].Text.Trim(); //预报编号
                        storageActualG.specName = ugr.Cells["specName"].Text.Trim();         //规格
                        storageActualG.gradeName = ugr.Cells["gradeName"].Text.Trim();       //钢号
                        storageActualG.batchNo = ugr.Cells["batchNo"].Text.Trim();           //批次号
                        storageActualG.heatNo = ugr.Cells["heatNo"].Text.Trim();         //炉号
                        storageActualG.packageNo = ugr.Cells["packageNo"].Text.Trim();       //顺序号
                        storageActualG.blockNum = ugr.Cells["blockNum"].Text.Trim();         //总支数
                        storageActualG.theoreticalWeight = (double.Parse(ugr.Cells["theoreticalWeight"].Text.Trim()) * 1000) + "";         //理论重量
                        storageActualG.meterClass = ugr.Cells["meterClass"].Text.Trim();     //班次
                        storageActualG.meterGroup = ugr.Cells["meterGroup"].Text.Trim();     //班组
                        storageActualG.baseSpotNo = ugr.Cells["baseSpotNo"].Text.Trim();     //计量点的编号
                        storageActualG.baseSpotName = ugr.Cells["baseSpotName"].Text.Trim();     //计量点名称
                        storageActualG.memo = ugr.Cells["memo"].Text.Trim(); //备注信息

                        storageActualG.productDate = Convert.ToDateTime(ugr.Cells["productDate"].Value.ToString()); //生产日期

                        //净重计算时；净重=采集重量+零点值-仪表底数
                        storageActualG.netWeight = Convert.ToDouble(ugr.Cells["netWeight"].Text.Trim()) * 1000; //净重
                        storageActualG.grossWeight = Convert.ToDouble(ugr.Cells["grossWeight"].Text.Trim()) * 1000;  //采集的重量
                        storageActualG.referWeight = Convert.ToDouble(ugr.Cells["referWeight"].Text.Trim()) * 1000; //仪表的底数
                        storageActualG.tareWeight = Convert.ToDouble(ugr.Cells["tareWeight"].Text.Trim()) * 1000; //仪表零点值
                        storageActualG.actualWeight = storageActualG.netWeight;
                        autoAutoFill(storageActualG); //点击行进行自动填充界面字段

                        ugr.Appearance.BackColor = Color.Aquamarine;
                    }
                }
                else
                {
                    ugr.Appearance.BackColor = Color.White;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("ultraGridScale_ClickCell方法处理异常：" + ex);
            }
        }

        /// <summary>
        /// 按照预报编号查询数据，并填充到界面
        /// </summary>
        private void queryPredictionNo()
        {
            CommonPage<PreStorageScale> cp = new CommonPage<PreStorageScale>();

            cp.param = new PreStorageScale(); //{ valueFlag = "1", baseSpotNo = cmbPoint.Value?.ToString() };
            cp.param.predictionNo = tbPredictionNo.Text;
            cp.param.valueFlag = "8";//VALUE_FLAG in ('1','2','3')
            RESTfulResult<List<PreStorageScale>> rms = scaleService.doQueryWf(cp.param);
            if (rms.Succeed && rms.Data != null && rms.Data.Count > 0)
            {
                storageActualG.predictionNo = rms.Data[0].predictionNo; //预报编号
                storageActualG.specName = rms.Data[0].specName;         //规格
                storageActualG.gradeName = rms.Data[0].gradeName;       //钢号
                storageActualG.batchNo = rms.Data[0].batchNo;           //批次号
                storageActualG.heatNo = rms.Data[0].heatNo;         //炉号
                storageActualG.blockNum = rms.Data[0].blockNum;         //总支数
                storageActualG.theoreticalWeight = rms.Data[0].theoreticalWeight + "";         //理论重量
                autoAutoFill(storageActualG); //点击行进行自动填充界面字段
            }
        }

        /// <summary>
        /// 按照炉号查询数据，并填充到界面
        /// </summary>
        private void queryHeatNo()
        {
            CommonPage<PreStorageScale> cp = new CommonPage<PreStorageScale>();

            cp.param = new PreStorageScale(); //{ valueFlag = "1", baseSpotNo = cmbPoint.Value?.ToString() };
            cp.param.heatNo = tbHeatNoUp.Text;
            cp.param.valueFlag = "8";//VALUE_FLAG in ('1','2','3')
            RESTfulResult<List<PreStorageScale>> rms = scaleService.doQueryWf(cp.param);
            if (rms.Succeed && rms.Data != null && rms.Data.Count > 0)
            {
                storageActualG.predictionNo = rms.Data[0].predictionNo; //预报编号
                storageActualG.specName = rms.Data[0].specName;         //规格
                storageActualG.gradeName = rms.Data[0].gradeName;       //钢号
                storageActualG.batchNo = rms.Data[0].batchNo;           //批次号
                storageActualG.heatNo = rms.Data[0].heatNo;         //炉号
                storageActualG.blockNum = rms.Data[0].blockNum;         //总支数
                storageActualG.theoreticalWeight = rms.Data[0].theoreticalWeight + "";         //理论重量
                autoAutoFill(storageActualG); //点击行进行自动填充界面字段
            }
        }

        /// <summary>
        /// 自动填充界面的数据
        /// </summary>
        private void autoAutoFill(MeterWorkStorageActual storageActualG)
        {
            if (storageActualG == null || string.IsNullOrEmpty(storageActualG.actualNo))
            {
                return;
            }
            cmbPointUp.Text = storageActualG.baseSpotName; //计量点名称1
            tbHeatNoUp.Text = storageActualG.heatNo; //炉号2
            cmbSpcNameUp.Text = storageActualG.specName; //规格名称3
            cmbGradeNameUp.Text = storageActualG.gradeName; //钢号名称4
            tbPackageNoUp.Text = storageActualG.packageNo;//顺序号5
            tbBlockNumUp.Text = storageActualG.blockNum;//总支数6
            cmbMeterClassUp.Text = storageActualG.meterClass;//班次7
            tbTheoreticalWeightUp.Text = storageActualG.theoreticalWeight + "";//理论重量8
            tbPredictionNo.Text = storageActualG.predictionNo; //预报编号9

            numCollectWeight.Value = (decimal)storageActualG.grossWeight;//采集的重量
            numTareWeight.Value = (decimal)storageActualG.tareWeight;//仪表零点值
            numReferWeight.Value = (decimal)storageActualG.referWeight;//仪表的底数
            numNetWeight.Value = (decimal)storageActualG.netWeight;//净重
            cmbMeterGroupUp.Text = storageActualG.meterGroup;//班组8
            tbMemo.Text = storageActualG.memo;//备注

            dtpProductDate.Value = (DateTime)storageActualG.productDate;//产量时间
        }

        /// <summary>
        /// 界面的值给storageActual赋值；用于新增、修改
        /// </summary>
        /// <param name="storageActual"></param>
        private MeterWorkStorageActual setTableValue(MeterWorkStorageActual storageActual)
        {
            storageActual.predictionNo = tbPredictionNo.Text;
            storageActual.baseSpotName = cmbPointUp.Text;
            storageActual.baseSpotNo = cmbPointUp.Value + "";
            storageActual.heatNo = tbHeatNoUp.Text;
            storageActual.specName = cmbSpcNameUp.Text;
            storageActual.specNo = cmbSpcNameUp.Value + "";
            storageActual.gradeName = cmbGradeNameUp.Text;
            storageActual.gradeNo = cmbGradeNameUp.Value + "";
            storageActual.theoreticalWeight = tbTheoreticalWeightUp.Text;
            storageActual.meterClass = cmbMeterClassUp.Text;
            storageActual.meterGroup = cmbMeterGroupUp.Text;
            storageActual.blockNum = tbBlockNumUp.Text;
            storageActual.productDate = dtpProductDate.Value;
            storageActual.packageNo = tbPackageNoUp.Text;
            storageActual.memo = tbMemo.Text;

            storageActual.grossWeight = Convert.ToDouble(numCollectWeight.Value); //采集的重量
            storageActual.referWeight = Convert.ToDouble(numReferWeight.Value);//仪表的底数
            storageActual.tareWeight = Convert.ToDouble(numTareWeight.Value);//仪表零点值
            //净重；净重=采集重量+零点值-仪表底数
            storageActual.netWeight = Convert.ToDouble(numNetWeight.Value);
            storageActual.actualWeight = storageActual.netWeight;
            return storageActual;
        }

        /// <summary>
        /// 新增数据
        /// </summary>
        /// <param name="vFlag"></param>
        private void btnInsert()
        {
            if (string.IsNullOrEmpty(numCollectWeight.Text) || string.IsNullOrEmpty(numReferWeight.Text)
                || string.IsNullOrEmpty(numTareWeight.Text) || string.IsNullOrEmpty(numNetWeight.Text))
            {
                MessageBox.Show("采集重量、仪表底数、零点值、净重的值均不允许为空！");
                return;
            }
            MeterWorkStorageActual storageActual = new MeterWorkStorageActual();
            storageActual.createManName = userName;
            storageActual.createManNo = userId;

            storageActual = setTableValue(storageActual);
            RESTfulResult<string> rm = actualService.doAddHotDeliveryBelt(storageActual);

            if (rm.Succeed)
            {
                //actNo = rm.Data;
                MessageBox.Show("新增成功" + rm.Data.Split('#')[1]);
                btnQuery();
                return;
            }
            else
            {
                MessageBox.Show("保存失败：" + rm.Data);
                l.WriteLog(19, "保存失败：" + rm.Data + rm.Message);
                return;
            }
        }

        /// <summary>
        /// 修改数据(作废还原)
        /// </summary>
        /// <param name="vFlag"></param>
        private void btnUpdate(string vFlag)
        {
            try
            {
                int iCount = 0;
                List<MeterWorkStorageActual> lt = new List<MeterWorkStorageActual>();
                ultraGridScale.UpdateData();
                foreach (UltraGridRow ugr in ultraGridScale.Rows)
                {
                    if (ugr.Cells["UNCK"].Value.ToString().Trim().ToUpper() == "TRUE")
                    {
                        //除了还原，都不能修改
                        if (!vFlag.Equals("1") && "0".Equals(ugr.Cells["valueFlag"].Value + ""))
                        {
                            MessageBox.Show("已作废的数据，请先还原再进行审核或修改！");
                            return;
                        }
                        if ("1".Equals(ugr.Cells["checkFlag"].Value + ""))
                        {
                            MessageBox.Show("已审核的数据不允许再修改或审核，请联系计量系统管理员！");
                            return;
                        }
                        MeterWorkStorageActual preStorageUpdate = new MeterWorkStorageActual();
                        preStorageUpdate.actualNo = ugr.Cells["actualNo"].Text.Trim();
                        preStorageUpdate.predictionNo = ugr.Cells["predictionNo"].Text.Trim();
                        preStorageUpdate.updateManNo = userId;
                        preStorageUpdate.updateManName = userName;
                        if ("审核".Equals(vFlag))
                        {
                            preStorageUpdate.checkManNo = userId;
                            preStorageUpdate.checkManName = userName;
                            preStorageUpdate.checkFlag = vFlag;//已审核；服务端进行数据转换；将审核转换为 1
                            if (string.IsNullOrEmpty(ugr.Cells["heatNo"].Value + ""))
                            {
                                MessageBox.Show("存在炉号为空的数据，不允许进行审核！");
                                return;
                            }
                            if (!ugr.Cells["referWeight"].Value.ToString().Equals("0"))
                            {
                                MessageBox.Show("存在仪表底数不为 0 的数据，不允许进行审核！");
                                return;
                            }
                        }
                        else if (!string.IsNullOrEmpty(vFlag))
                        {
                            preStorageUpdate.valueFlag = vFlag;
                        }
                        else
                        {
                            if (string.IsNullOrEmpty(numCollectWeight.Text) || string.IsNullOrEmpty(numReferWeight.Text)
                               || string.IsNullOrEmpty(numTareWeight.Text) || string.IsNullOrEmpty(numNetWeight.Text))
                            {
                                MessageBox.Show("采集重量、仪表底数、零点值、净重的值均不允许为空！");
                                return;
                            }
                            preStorageUpdate = setTableValue(preStorageUpdate);
                        }

                        lt.Add(preStorageUpdate);
                        iCount++;
                    }
                }
                if (lt == null || lt.Count == 0)
                {
                    MessageBox.Show("请至少勾选一条数据后再进行修改或审核操作！");
                    return;
                }
                string msg = "审核".Equals(vFlag) ? "审核" : "修改";
                if ("审核".Equals(vFlag))
                {
                    DialogResult dr = MessageBox.Show("共" + msg + "选择[  " + iCount + "  ]条数据，是否继续操作！", "提示", MessageBoxButtons.OKCancel);
                    if (dr == DialogResult.Cancel)
                    {
                        return;
                    }
                }
                else
                {
                    DialogResult dr = MessageBox.Show("共" + msg + "选择[  " + iCount + "  ]条数据进行修改！！！\r\n \r\n " +
                  "注意：若批量修改，计量重量也会修改成同一个值，是否继续操作！", "提示", MessageBoxButtons.OKCancel);
                    if (dr == DialogResult.Cancel)
                    {
                        return;
                    }
                }
                RESTfulResult<String> rms = actualService.doUpdateClient(lt);
                if (rms.Succeed)
                {
                    MessageBox.Show(msg + "成功！");
                    btnQuery();
                }
                else
                {
                    MessageBox.Show("操作失败：" + rms.Data);
                    l.WriteLog(19, "操作失败：" + rms.Data + rms.Message);
                }
            }
            catch (Exception)
            {
                throw;
            }
        }

        /// <summary>
        /// 批量修改序号
        /// </summary>
        /// <param name="vFlag"></param>
        private void btnUpdateXh()
        {
            try
            {
                int iCount = 0;
                List<MeterWorkStorageActual> lt = new List<MeterWorkStorageActual>();
                ultraGridScale.UpdateData();
                foreach (UltraGridRow ugr in ultraGridScale.Rows)
                {
                    if (ugr.Cells["UNCK"].Value.ToString().Trim().ToUpper() == "TRUE")
                    {
                        if ("0".Equals(ugr.Cells["valueFlag"].Value + ""))
                        {
                            MessageBox.Show("已作废的数据，请先还原再进行审核或修改！");
                            return;
                        }
                        if ("1".Equals(ugr.Cells["checkFlag"].Value + ""))
                        {
                            MessageBox.Show("已审核的数据不允许再修改或审核，请联系计量系统管理员！");
                            return;
                        }
                        MeterWorkStorageActual preStorageUpdate = new MeterWorkStorageActual();
                        preStorageUpdate.actualNo = ugr.Cells["actualNo"].Text.Trim();
                        preStorageUpdate.updateManNo = userId;
                        preStorageUpdate.updateManName = userName;
                        preStorageUpdate.packageNo = ugr.Cells["packageNo"].Text.Trim();
                        lt.Add(preStorageUpdate);
                        iCount++;
                    }
                }
                if (lt == null || lt.Count == 0)
                {
                    MessageBox.Show("请至少勾选一条数据后再进行修改或审核操作！");
                    return;
                }
                DialogResult dr = MessageBox.Show("共选择[  " + iCount + "  ]条数据，进行序号修改，是否继续操作！", "提示", MessageBoxButtons.OKCancel);
                if (dr == DialogResult.Cancel)
                {
                    return;
                }
                RESTfulResult<String> rms = actualService.doUpdateClientXH(lt);
                if (rms.Succeed)
                {
                    MessageBox.Show("序号批龙修改成功！");
                    btnQuery();
                }
                else
                {
                    MessageBox.Show("操作失败：" + rms.Data);
                    l.WriteLog(19, "操作失败：" + rms.Data + rms.Message);
                }
            }
            catch (Exception)
            {
                throw;
            }
        }

        /// <summary>
        /// 查询数据
        /// </summary>

        private void btnQuery()
        {
            DataTable dtScale = dataTable1.Clone();
            if (string.IsNullOrEmpty(cmbPoint.Value?.ToString()))
            {
                MessageBox.Show("请选择计量点");
                return;
            }

            CommonPage<MeterWorkStorageActual> cp = new CommonPage<MeterWorkStorageActual>();

            cp.param = new MeterWorkStorageActual(); //{ valueFlag = "1", baseSpotNo = cmbPoint.Value?.ToString() };
            cp.param.valueFlag = cmbScaleState.Value + "";
            cp.param.checkFlag = cmbCheckState.Value + "";
            cp.param.baseSpotNo = cmbPoint.Value + "";

            cp.param.meterClass = cmbMeterClass.Text + "";
            cp.param.meterGroup = cmbMeterGroup.Text + "";

            cp.param.specNo = cmbSpcName.Value + "";
            cp.param.gradeNo = cmbGradeName.Value + "";
            cp.param.heatNo = tbHeatNo.Text + "";

            if (cbCrt.Checked)
            {
                cp.param.startTime = dtStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
                cp.param.endTime = dtEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
                if (DateTime.Compare(dtStartTime.Value, dtEndTime.Value) > 0)
                {
                    MessageBox.Show("开始时间不能大于结束时间");
                    return;
                }
                if ((dtEndTime.Value - dtStartTime.Value).Days > 30)
                {
                    MessageBox.Show("时间跨度不能大于30天");
                    return;
                }
            }
            else
            {
                cp.param.createTime1 = dtStartTimeSC.Value.ToString("yyyy-MM-dd HH:mm:ss");
                cp.param.createTime2 = dtEndTimeSC.Value.ToString("yyyy-MM-dd HH:mm:ss");
                if (DateTime.Compare(dtStartTimeSC.Value, dtEndTimeSC.Value) > 0)
                {
                    MessageBox.Show("开始时间不能大于结束时间");
                    return;
                }
                if ((dtEndTimeSC.Value - dtStartTimeSC.Value).Days > 30)
                {
                    MessageBox.Show("时间跨度不能大于30天");
                    return;
                }
            }

            RESTfulResult<List<MeterWorkStorageActual>> rms = actualService.doQuery(cp.param);
            if (rms.Succeed)
            {
                if (rms.Data != null && rms.Data.Count > 0)
                {
                    dtScale = rms.Data.ListToDataTable<MeterWorkStorageActual>();

                    ClsControlPack.CopyDataToDatatable(ref dtScale, ref dataTable1, true);
                    ClsControlPack.RefreshAndAutoSize(ultraGridScale);

                    foreach (UltraGridRow ugr in ultraGridScale.Rows)
                    {
                        if (ugr.Cells["valueFlag"].Value.ToString() == "0")
                        {
                            ugr.Appearance.BackColor = Color.Red;
                        }
                        else if (ugr.Cells["checkFlag"].Value.ToString() == "1")
                        {
                            ugr.Appearance.BackColor = Color.YellowGreen;
                        }
                        else
                        {
                            ugr.Appearance.BackColor = Color.White;
                        }
                        ugr.Cells["acDiffweight"].Value = double.Parse(ugr.Cells["theoreticalWeight"].Value.ToString()) - double.Parse(ugr.Cells["netWeight"].Value.ToString());
                        ugr.Cells["theoreticalWeight"].Value = double.Parse(string.IsNullOrEmpty(ugr.Cells["theoreticalWeight"].Value.ToString()) ? "0" : ugr.Cells["theoreticalWeight"].Value.ToString()) / 1000;
                        ugr.Cells["grossWeight"].Value = double.Parse(string.IsNullOrEmpty(ugr.Cells["grossWeight"].Value.ToString()) ? "0" : ugr.Cells["grossWeight"].Value.ToString()) / 1000;
                        ugr.Cells["tareWeight"].Value = double.Parse(string.IsNullOrEmpty(ugr.Cells["tareWeight"].Value.ToString()) ? "0" : ugr.Cells["tareWeight"].Value.ToString()) / 1000;
                        ugr.Cells["netWeight"].Value = double.Parse(string.IsNullOrEmpty(ugr.Cells["netWeight"].Value.ToString()) ? "0" : ugr.Cells["netWeight"].Value.ToString()) / 1000;
                        ugr.Cells["referWeight"].Value = double.Parse(string.IsNullOrEmpty(ugr.Cells["referWeight"].Value.ToString()) ? "0" : ugr.Cells["referWeight"].Value.ToString()) / 1000;
                        ugr.Cells["actualWeight"].Value = double.Parse(string.IsNullOrEmpty(ugr.Cells["actualWeight"].Value.ToString()) ? "0" : ugr.Cells["actualWeight"].Value.ToString()) / 1000;
                    }
                }
                else
                {
                    dtScale.Clear();
                    ClsControlPack.CopyDataToDatatable(ref dtScale, ref dataTable1, true);
                    ClsControlPack.RefreshAndAutoSize(ultraGridScale);
                }
                btnCheckQuery();
            }
        }

        /// <summary>
        /// 设置界面显示的格式
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGridScale_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {
            e.Layout.Bands[0].Columns["netWeight"].MaskInput = "nnnn.nnn";
            e.Layout.Bands[0].Columns["grossWeight"].MaskInput = "nnnn.nnn";
            e.Layout.Bands[0].Columns["actualWeight"].MaskInput = "nnnn.nnn";
            e.Layout.Bands[0].Columns["theoreticalWeight"].MaskInput = "nnnn.nnn";
        }

        /// <summary>
        /// 查询审核的数据
        /// </summary>

        private void btnCheckQuery()
        {
            CommonPage<MeterWorkStorageActual> cp = new CommonPage<MeterWorkStorageActual>();
            cp.param = new MeterWorkStorageActual(); //{ valueFlag = "1", baseSpotNo = cmbPoint.Value?.ToString() };
            cp.param.valueFlag = "1";
            cp.param.checkFlag = cmbCheckState.Value + "";
            cp.param.baseSpotNo = cmbPoint.Value + "";

            cp.param.meterClass = cmbMeterClass.Text + "";
            cp.param.meterGroup = cmbMeterGroup.Text + "";

            cp.param.specNo = cmbSpcName.Value + "";
            cp.param.gradeNo = cmbGradeName.Value + "";
            cp.param.heatNo = tbHeatNo.Text + "";
            if (cbCrt.Checked)
            {
                cp.param.startTime = dtStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
                cp.param.endTime = dtEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
            }
            else
            {
                cp.param.createTime1 = dtStartTimeSC.Value.ToString("yyyy-MM-dd HH:mm:ss");
                cp.param.createTime2 = dtEndTimeSC.Value.ToString("yyyy-MM-dd HH:mm:ss");
            }

            RESTfulResult<List<MeterWorkStorageActual>> rms = actualService.doQueryCheckCount(cp.param);
            if (rms.Succeed)
            {
                if (rms.Data != null && rms.Data.Count > 0)
                {
                    if (rms.Data.Count == 2)
                    {
                        foreach (var item in rms.Data)
                        {
                            //审核状态(0=未审核，1=已审核)
                            if ("1".Equals(item.checkFlag))
                            {
                                tbChecked.Text = "已审核支数：" + item.actualNo + "支，" + item.netWeight + " t";
                            }
                            if ("0".Equals(item.checkFlag))
                            {
                                lbNotChecked.Text = "未审核支数：" + item.actualNo + "支，" + item.netWeight + " t";
                            }
                        }
                    }
                    if (rms.Data.Count == 1)
                    {
                        if ("1".Equals(rms.Data[0].checkFlag))
                        {
                            tbChecked.Text = "已审核支数：" + rms.Data[0].actualNo + " 支，" + rms.Data[0].netWeight + " t";
                            lbNotChecked.Text = "未审核支数：0 支";
                        }
                        else
                        {
                            tbChecked.Text = "已审核支数：0 支";
                            lbNotChecked.Text = "未审核支数：" + rms.Data[0].actualNo + "支，" + rms.Data[0].netWeight + " t";
                        }
                    }
                }
                else
                {
                    tbChecked.Text = "已审核支数：0";
                    lbNotChecked.Text = "已审核支数：0";
                }
            }
        }
    }
}