仲国强
2021-10-08 d2e25f51a7fb6cf8bb77135f371db51957803582
工序工价资料新增保存功能
11个文件已修改
5个文件已添加
10961 ■■■■■ 已修改文件
DAL/仓库管理/ClsKf_ProductInBill.cs 136 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
LMES/ClsShowMod.cs 21 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/GZGL/Gy_DuSubsidyItemBillController.cs 218 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/Sc_MouldRepairOutBillController.cs 4785 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/DLL/ClsGy_DuSubsidyItemBill.cs 89 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/DLL/ClsSc_MouldRepairChangeBill.cs 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/DLL/ClsSc_MouldRepairInBill.cs 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/DLL/ClsSc_MouldRepairOutBill.cs 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/ListModels.cs 12 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user 192 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/WebAPI.csproj 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/WebAPI.csproj.user 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/WorkM.csproj 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/流转卡管理/MES_StationOutBillList_Bad.cs 707 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/流转卡管理/MES_StationOutBillList_Bad.designer.cs 673 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WorkM/流转卡管理/MES_StationOutBillList_Bad.resx 4101 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
DAL/²Ö¿â¹ÜÀí/ClsKf_ProductInBill.cs
@@ -440,7 +440,143 @@
        }
        public bool AddBill_StationOut_Bad(string sHSourceType, Pub_Class.ClsXt_SystemParameterMain oSystemParameterMain,ref string sErrMsg)
        {
            //上传前必填项判断
            try
            {
                DataSet Ds;
                if (oSystemParameterMain.WMS_CampanyName == "杭州智见" || oSystemParameterMain.WMS_CampanyName == "杭州斯莫尔") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称     ç©ºç™½ä¸ºé€šç”¨
                {
                }
                else
                {
                    oCn.BeginTran();
                }
                //生成出入库单据
                //插入子表
                DataSet DS2 = oCn.RunProcReturn("EXEC h_p_Kf_ProductInBillSub_Insert_StationOutBad " + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + sHSourceType + "'", "h_p_Kf_ProductInBillSub_Insert_StationOutBad");
                if (DS2 == null || DS2.Tables[0].Rows.Count == 0)
                {
                    sErrMsg = "判断写入子表状态失败,未知错误!";
                    if (oSystemParameterMain.WMS_CampanyName == "杭州智见" || oSystemParameterMain.WMS_CampanyName == "杭州斯莫尔") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称     ç©ºç™½ä¸ºé€šç”¨
                    {
                    }
                    else
                    {
                        oCn.RollBack();
                    }
                    return false;
                }
                else
                {
                    if (DBUtility.ClsPub.isStrNull(DS2.Tables[0].Rows[0][0]) != "OK")
                    {
                        sErrMsg = "写入子表失败!";
                        return false;
                    }
                }
                        //插入主表
                oCn.RunProc("Insert Into Kf_ICStockBillMain   " +
                "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMainSourceBillType" +
                ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" +
                ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" +
                ") " +
                " values('1202','1202'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "',convert(varchar(10),getdate(),120),'" + omodel.HMainSourceBillType + "'" +
                ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',convert(varchar(10),getdate(),120)" +
                ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() +
                ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) +
                ") ");
                //新增K3子表、主表
                oCn.RunProc("exec h_p_IFK3_ToERP_ProductInBill_Insert_New " + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillerID.ToString() + ",'" + sHSourceType + "'");
                //更新关联数量
                if (sHSourceType == "3710")         //生产任务单
                {
                    oCn.RunProc("exec h_p_Sc_UpDateRelation_ICMOToProductIn_Add " + omodel.HInterID.ToString());
                    //回填K3关联数量
                    oCn.RunProc("exec h_p_IFK3_ToERP_ProductInBill_UpdateBillRelateData_ICMO_New " + omodel.HInterID.ToString());
                }
                else    //无源单
                {
                    //回填K3关联数量
                    oCn.RunProc("exec h_p_IFK3_ToERP_ProductInBill_UpdateBillRelateData_New " + omodel.HInterID.ToString());
                }
                //判断库存更新控制状态(0为审核改变库存,1为保存改变库存)
                DataSet DS = oCn.RunProcReturn("exec h_p_IFK3_SaveUpdateStock ", "h_p_IFK3_SaveUpdateStock");
                if (DS == null || DS.Tables[1].Rows.Count == 0)
                {
                    sErrMsg = "判断库存更新控制状态,未知错误!";
                    if (oSystemParameterMain.WMS_CampanyName == "杭州智见" || oSystemParameterMain.WMS_CampanyName == "杭州斯莫尔") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称     ç©ºç™½ä¸ºé€šç”¨
                    {
                    }
                    else
                    {
                        oCn.RollBack();
                    }
                    return false;
                }
                else
                {
                    if (DBUtility.ClsPub.isLong(DS.Tables[1].Rows[0][0]) == 1)
                    {
                        //更新K3库存
                        oCn.RunProc("exec h_p_IFK3_ToERP_ProductInBill_UpdateStock_New " + omodel.HInterID.ToString());
                        oCn.RunProc("exec h_p_IFK3_ToERP_ProductInBill_UpdateOrderStock_New " + omodel.HInterID.ToString());
                        //审核单据
                        if (oSystemParameterMain.Kf_ProductInBill_AutoCheck == "Y") //系统参数  è‡ªåŠ¨å®¡æ ¸
                        {
                            //审核单据
                            oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + omodel.HMaker + "',HCheckDate=convert(varchar(10),getdate(),120) where HInterID= " + omodel.HInterID.ToString());
                            //审核K3单据
                            oCn.RunProc("exec h_p_IFK3_ToERP_ProductInBill_Check_New " + omodel.HInterID.ToString() + "," + omodel.HBillerID.ToString());
                        }
                    }
                    else
                    {
                        //审核单据
                        if (oSystemParameterMain.Kf_ProductInBill_AutoCheck == "Y") //系统参数  è‡ªåŠ¨å®¡æ ¸
                        {
                            //审核单据
                            oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + omodel.HMaker + "',HCheckDate=convert(varchar(10),getdate(),120) where HInterID= " + omodel.HInterID.ToString());
                            //审核K3单据
                            oCn.RunProc("exec h_p_IFK3_ToERP_ProductInBill_Check_New " + omodel.HInterID.ToString() + "," + omodel.HBillerID.ToString());
                            //更新K3库存
                            oCn.RunProc("exec h_p_IFK3_ToERP_ProductInBill_UpdateStock_New " + omodel.HInterID.ToString());
                            oCn.RunProc("exec h_p_IFK3_ToERP_ProductInBill_UpdateOrderStock_New " + omodel.HInterID.ToString());
                        }
                    }
                }
                sErrMsg = "新增单据成功!";
                if (oSystemParameterMain.WMS_CampanyName == "杭州智见" || oSystemParameterMain.WMS_CampanyName == "杭州斯莫尔") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称     ç©ºç™½ä¸ºé€šç”¨
                {
                }
                else
                {
                    oCn.Commit();
                }
                return true;
            }
            catch (Exception e)
            {
                sErrMsg = "生成产品入库单失败!" + e.Message;
                if (oSystemParameterMain.WMS_CampanyName == "杭州智见" || oSystemParameterMain.WMS_CampanyName == "杭州斯莫尔") //系统参数  å®¢æˆ·å®šåˆ¶åŒ–名称     ç©ºç™½ä¸ºé€šç”¨
                {
                }
                else
                {
                    oCn.RollBack();
                }
                return false;
            }
        }
LMES/ClsShowMod.cs
@@ -5189,6 +5189,27 @@
            {
                switch (gnsy.ToLower())
                {
                    case "mes_stationoutbilllist_bad":
                        MES_StationOutBillList_Bad oMES_StationOutBillList_Bad = new MES_StationOutBillList_Bad();
                        oMES_StationOutBillList_Bad.MdiParent = oMain;
                        oMES_StationOutBillList_Bad.ModCaption = gnmc;
                        oMES_StationOutBillList_Bad.Show();
                        oMainForm.AddTabPage(oMES_StationOutBillList_Bad);
                        break;
                    case "sc_prodwiptotalreport":
                        Sc_ProdWIPTotalReport oSc_ProdWIPTotalReport = new Sc_ProdWIPTotalReport();
                        oSc_ProdWIPTotalReport.MdiParent = oMain;
                        oSc_ProdWIPTotalReport.ModCaption = gnmc;
                        oSc_ProdWIPTotalReport.Show();
                        oMainForm.AddTabPage(oSc_ProdWIPTotalReport);
                        break;
                    case "mes_wipprocreport":
                        MES_WIPProcReport oMES_WIPProcReport = new MES_WIPProcReport();
                        oMES_WIPProcReport.MdiParent = oMain;
                        oMES_WIPProcReport.ModCaption = gnmc;
                        oMES_WIPProcReport.Show();
                        oMainForm.AddTabPage(oMES_WIPProcReport);
                        break;
                    case "mes_icmobillstatusreport":
                        MES_ICMOBillStatusReport oMES_ICMOBillStatusReport = new MES_ICMOBillStatusReport();
                        oMES_ICMOBillStatusReport.MdiParent = oMain;
WebAPI/Controllers/GZGL/Gy_DuSubsidyItemBillController.cs
New file
@@ -0,0 +1,218 @@
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;
using WebAPI.Models;
namespace WebAPI.Controllers.GZGL
{
    public class Gy_DuSubsidyItemBillController : ApiController
    {
        public DBUtility.ClsPub.Enum_BillStatus BillStatus;
        private json objJsonResult = new json();
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        public DataSet ds = new DataSet();
        public DLL.ClsGy_DuSubsidyItemBill BillNew0 = new DLL.ClsGy_DuSubsidyItemBill();
        public DLL.ClsGy_DuSubsidyItemBill BillOld0 = new DLL.ClsGy_DuSubsidyItemBill();
        #region æ‰£è¡¥èµ„料列表数据
        /// <summary>
        /// è¿”回扣补资料列表
        ///参数:string sql。
        ///返回值:object。
        /// </summary>
        [Route("Gy_DuSubsidyItemBill/Gy_DuSubsidyItemlist")]
        [HttpGet]
        public object Gy_DuSubsidyItemlist(string sWhere)
        {
            try
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Gy_DuSubsidyItemList " + sWhere, "h_v_Gy_DuSubsidyItemList");
                }
                else
                {
                    string sql1 = "select * from h_v_Gy_DuSubsidyItemList where 1 = 1 ";
                    string sql = sql1 + sWhere;
                    ds = oCN.RunProcReturn(sql, "h_v_Gy_DuSubsidyItemList");
                }
                if (ds == null || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "false!";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "Sucess!";
                    objJsonResult.data = ds.Tables[0];
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception!" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
        #region åˆ é™¤å·¥èµ„类型
        /// <summary>
        /// å·¥èµ„类型列表删除按钮
        ///参数:string sql。
        ///返回值:object。
        /// </summary>
        [Route("Gy_DuSubsidyItemBill/Delete_Json")]
        [HttpGet]
        public object Delete_Json(string HInterID)
        {
            //用id查到该对象
            string sql = "select * from Gy_DuSubsidyItem where HItemID =  " + HInterID;
            ds = oCN.RunProcReturn(sql, "Gy_DuSubsidyItem");
            if (ds == null)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "不存在此对象!";
                objJsonResult.data = null;
                return objJsonResult;
            }
            else
            {
                //if (ds.Tables[0].Columns[12].ToString()!="未使用")
                //{
                //    objJsonResult.code = "0";
                //    objJsonResult.count = 0;
                //    objJsonResult.Message = "此项目已使用或者未检测,不能删除!请重新检测再删除!";
                //    objJsonResult.data = null;
                //    return objJsonResult;
                //}
                //else
                //{
                string sql2 = "delete from Gy_DuSubsidyItem where HItemID = " + HInterID;
                ds = oCN.RunProcReturn(sql2, "Gy_DuSubsidyItem");
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功";
                objJsonResult.data = null;
                return objJsonResult;
                //}
            }
        }
        #endregion
        #region æ‰£è¡¥èµ„料修改获取绑定数据
        /// <summary>
        /// æ‰£è¡¥èµ„料列表修改按钮方法
        ///参数:string sql。
        ///返回值:object。
        /// </summary>
        [Route("Gy_DuSubsidyItemBill/xg")]
        [HttpGet]
        public object xg(long HID)
        {
            try
            {
                ds = oCN.RunProcReturn("select * from Gy_DuSubsidyItem where HItemID=" + HID, "Gy_DuSubsidyItem");
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception!" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion
        #region æ‰£è¡¥èµ„料保存
        /// <summary>
        /// ä¿å­˜æŒ‰é’®
        ///参数:string sql。
        ///返回值:object。
        /// </summary>
        [Route("Gy_DuSubsidyItemBill/SaveGetGy_DuSubsidyItemBill")]
        [HttpPost]
        public object SaveGetGy_DuSubsidyItemBill([FromBody] JObject oMain)
        {
            var _value = oMain["oMain"].ToString();
            string msg1 = _value.ToString();
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();
            ListModels oListModels = new ListModels();
            try
            {
                DLL.ClsGy_DuSubsidyItemBill oBill = new DLL.ClsGy_DuSubsidyItemBill();
                List<Model.ClsGy_DuSubsidyItem_Model> lsmain = new List<Model.ClsGy_DuSubsidyItem_Model>();
                msg2 = msg2.Replace("\\", "");
                msg2 = msg2.Replace("\n", "");  //\n
                lsmain = oListModels.getObjectByJson_Gy_DuSubsidyItemBill(msg2);
                foreach (Model.ClsGy_DuSubsidyItem_Model oItem in lsmain)
                {
                    oBill.omodel = oItem;
                }
                //保存
                //保存完毕后处理
                bool bResult;
                if (oBill.omodel.HItemID == 0)
                {
                    // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                }
                else
                {
                    bResult = oBill.ModifyBill(oBill.omodel.HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
                }
                if (bResult)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 1;
                    objJsonResult.Message = "保存成功!";
                    //WebAPIController.Add_Log("送货单下推", UserName, "生成送货单");
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
                else
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "保存失败!" + DBUtility.ClsPub.sExeReturnInfo;
                    objJsonResult.data = 1;
                    return objJsonResult;
                }
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "保存失败!" + e.ToString();
                objJsonResult.data = 1;
                return objJsonResult;
            }
        }
        #endregion
    }
}
WebAPI/Controllers/Sc_MouldRepairOutBillController.cs
Diff too large
WebAPI/DLL/ClsGy_DuSubsidyItemBill.cs
New file
@@ -0,0 +1,89 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace WebAPI.DLL
{
    public class ClsGy_DuSubsidyItemBill : DBUtility.ClsXt_BaseBill
    {
        public Model.ClsGy_DuSubsidyItem_Model omodel = new Model.ClsGy_DuSubsidyItem_Model();
        public ClsGy_DuSubsidyItemBill()
        {
            base.MvarItemKeySub = "";
            base.MvarItemKeySub2 = "";
            base.MvarItemKeySub3 = "";
            base.MvarItemKeySub4 = "";
            base.MvarItemKey = "Gy_DuSubsidyItem";
            base.MvarReportTitle = "扣补资料";
            base.BillType = "";
            base.HBillSubType = "";
        }
        //新增单据
        public override bool AddBill(ref string sReturn)
        {
            try
            {
                //若MAINDI重复则重新获取
                oCn.BeginTran();
                //主表
                oCn.RunProc("Insert Into Gy_DuSubsidyItem   " +
                "(HNumber,HName,HHelpCode,HRemark,HStopflag,HUseFlag,HShortNumber,HParentID,HLevel,HEndFlag,HSno,HType,HCaption,HSQLColumnName,HDataType,HDefaultValue" +
                    ",HLength,HSys,HSearch,HMustSave,HSearchTable,HTable" +
                ") " +
                " values('" + omodel.HNumber + "','" + omodel.HName + "','" +
                          omodel.HHelpCode + "','" + omodel.HRemark + "','" + Convert.ToString(omodel.HStopflag ? 1 : 0) + "','未使用','" +
                          omodel.HNumber + "',0,0,0" + "," + omodel.HSno.ToString() + ",'"+ omodel.HType + "','" + omodel.HCaption + "','"+ omodel.HSQLColumnName + "','" +
                          omodel.HDataType + "','" + omodel.HDefaultValue + "',"+ omodel.HLength.ToString() + ",0,'',0,'',''"+
                ") ");
                sReturn = "新增单据成功!";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }
        //修改单据
        public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                //
                oCn.BeginTran();
                //更新主表
                oCn.RunProc("UpDate Gy_DuSubsidyItem set  " +
                " HNumber='" + omodel.HNumber + "'" +  //固定赋值===============
                ",HName='" + omodel.HName + "'" +
                ",HHelpCode='" + omodel.HHelpCode + "'" +
                ",HRemark='" + omodel.HRemark + "'" +
                ",HStopflag='" + Convert.ToString(omodel.HStopflag ? 1 : 0) + "'" +
                ",HShortNumber='" + omodel.HNumber + "'" +
                ",HSno=" + omodel.HSno.ToString() +
                ",HType='" + omodel.HType + "'" +
                ",HCaption='" + omodel.HCaption + "'" +
                ",HSQLColumnName='" + omodel.HSQLColumnName + "'" +
                ",HDataType='" + omodel.HDataType + "'" +
                ",HDefaultValue='" + omodel.HDefaultValue + "'" +
                ",HLength=" + omodel.HLength.ToString() +
                " where HItemID=" + lngBillKey.ToString());
                sReturn = "修改单据成功!";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }
    }
}
WebAPI/DLL/ClsSc_MouldRepairChangeBill.cs
@@ -103,7 +103,7 @@
                ",HChangeNum=" + omodel.HChangeNum.ToString() +
                ",HEmpID=" + omodel.HEmpID.ToString() +
                ",HManagerID=" + omodel.HManagerID.ToString() +
                ",HRepairType='" + omodel.HRepairID + "'" +
                ",HRepairType='" + omodel.HRepairType + "'" +
                ",HSupID=" + omodel.HSupID.ToString() +
                ",HNewMaterID=" + omodel.HNewMaterID.ToString() +
                ",HNewName='" + omodel.HNewName + "'" +
WebAPI/DLL/ClsSc_MouldRepairInBill.cs
@@ -46,12 +46,12 @@
                "(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
                ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" +
                ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" +
                ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag,HRepairType" +
                ") " +
                " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" +
                ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() +
                ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) +
                ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + ",'" + omodel.HRepairType + "'" +
                ") ");
                //插入子表
@@ -129,6 +129,7 @@
                ",HDeptID=" + omodel.HDeptID.ToString() +
                ",HExplanation='" + omodel.HExplanation + "'" +
                ",HInnerBillNo='" + omodel.HInnerBillNo + "'" +
                ",HRepairType='" + omodel.HRepairType + "'" +
                " where HInterID=" + lngBillKey.ToString());
                //删除关联
WebAPI/DLL/ClsSc_MouldRepairOutBill.cs
@@ -46,12 +46,12 @@
                "(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
                ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" +
                ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" +
                ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag,HRepairType" +
                ") " +
                " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" +
                ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() +
                ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) +
                ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) +",'"+ omodel.HRepairType+"'"+
                ") ");
                //插入子表
@@ -129,6 +129,7 @@
                ",HDeptID=" + omodel.HDeptID.ToString() +
                ",HExplanation='" + omodel.HExplanation + "'" +
                ",HInnerBillNo='" + omodel.HInnerBillNo + "'" +
                ",HRepairType='" + omodel.HRepairType + "'" +
                " where HInterID=" + lngBillKey.ToString());
                //删除关联
WebAPI/ListModels.cs
@@ -644,6 +644,18 @@
        }
        /// <summary>
        /// å¤„理新增扣补资料记录表主表的json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Model.ClsGy_DuSubsidyItem_Model> getObjectByJson_Gy_DuSubsidyItemBill(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Model.ClsGy_DuSubsidyItem_Model> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_DuSubsidyItem_Model>>(jsonString);
            return list;
        }
        /// <summary>
        /// å¤„理新增模具点检记录表主表的json
        /// </summary>
        /// <param name="jsonString"></param>
WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user
@@ -9,40 +9,40 @@
  </PropertyGroup>
  <ItemGroup>
    <File Include="apiapp.json">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:16</publishTime>
    </File>
    <File Include="bin/Antlr3.Runtime.dll">
      <publishTime>02/22/2013 16:43:40</publishTime>
      <publishTime>02/22/2013 08:43:40</publishTime>
    </File>
    <File Include="bin/Antlr3.Runtime.pdb">
      <publishTime>02/22/2013 16:43:40</publishTime>
      <publishTime>02/22/2013 08:43:40</publishTime>
    </File>
    <File Include="bin/BLL.dll">
      <publishTime>10/08/2021 14:56:42</publishTime>
      <publishTime>09/30/2021 15:48:05</publishTime>
    </File>
    <File Include="bin/BLL.pdb">
      <publishTime>10/08/2021 14:56:42</publishTime>
      <publishTime>09/30/2021 15:48:05</publishTime>
    </File>
    <File Include="bin/DAL.dll">
      <publishTime>10/08/2021 14:56:40</publishTime>
      <publishTime>09/30/2021 15:48:03</publishTime>
    </File>
    <File Include="bin/DAL.pdb">
      <publishTime>10/08/2021 14:56:40</publishTime>
      <publishTime>09/30/2021 15:48:03</publishTime>
    </File>
    <File Include="bin/Dapper.dll">
      <publishTime>07/22/2016 22:52:40</publishTime>
      <publishTime>07/22/2016 14:52:40</publishTime>
    </File>
    <File Include="bin/DBUtility.dll">
      <publishTime>10/08/2021 14:56:39</publishTime>
      <publishTime>09/30/2021 15:47:59</publishTime>
    </File>
    <File Include="bin/DBUtility.pdb">
      <publishTime>10/08/2021 14:56:39</publishTime>
      <publishTime>09/30/2021 15:47:59</publishTime>
    </File>
    <File Include="bin/Interop.gregn6Lib.dll">
      <publishTime>08/25/2021 10:28:25</publishTime>
    </File>
    <File Include="bin/Kingdee.BOS.WebApi.Client.dll">
      <publishTime>08/25/2021 20:46:09</publishTime>
      <publishTime>08/16/2021 17:23:13</publishTime>
    </File>
    <File Include="bin/Kingdee.BOS.WebApi.FormService.dll">
      <publishTime>09/20/2018 19:23:20</publishTime>
@@ -51,49 +51,49 @@
      <publishTime>09/20/2018 19:28:34</publishTime>
    </File>
    <File Include="bin/Microsoft.Azure.AppService.ApiApps.Service.dll">
      <publishTime>03/19/2015 01:02:50</publishTime>
      <publishTime>03/18/2015 17:02:50</publishTime>
    </File>
    <File Include="bin/Microsoft.CSharp.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/Microsoft.Web.Infrastructure.dll">
      <publishTime>07/25/2012 19:48:56</publishTime>
      <publishTime>07/25/2012 11:48:56</publishTime>
    </File>
    <File Include="bin/Model.dll">
      <publishTime>10/08/2021 14:56:39</publishTime>
      <publishTime>09/30/2021 15:47:59</publishTime>
    </File>
    <File Include="bin/Model.pdb">
      <publishTime>10/08/2021 14:56:39</publishTime>
      <publishTime>09/30/2021 15:47:59</publishTime>
    </File>
    <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="bin/Newtonsoft.Json.dll">
      <publishTime>08/04/2014 04:33:56</publishTime>
      <publishTime>08/03/2014 20:33:56</publishTime>
    </File>
    <File Include="bin/Pub_Class.dll">
      <publishTime>10/08/2021 14:56:37</publishTime>
      <publishTime>09/30/2021 15:47:57</publishTime>
    </File>
    <File Include="bin/Pub_Class.pdb">
      <publishTime>10/08/2021 14:56:37</publishTime>
      <publishTime>09/30/2021 15:47:57</publishTime>
    </File>
    <File Include="bin/Pub_Control.dll">
      <publishTime>10/08/2021 14:56:38</publishTime>
      <publishTime>09/30/2021 15:47:58</publishTime>
    </File>
    <File Include="bin/Pub_Control.pdb">
      <publishTime>10/08/2021 14:56:38</publishTime>
      <publishTime>09/30/2021 15:47:58</publishTime>
    </File>
    <File Include="bin/SQLHelper.dll">
      <publishTime>10/08/2021 14:56:38</publishTime>
      <publishTime>09/30/2021 15:47:58</publishTime>
    </File>
    <File Include="bin/SQLHelper.pdb">
      <publishTime>10/08/2021 14:56:38</publishTime>
      <publishTime>09/30/2021 15:47:58</publishTime>
    </File>
    <File Include="bin/stdole.dll">
      <publishTime>05/09/2021 13:35:37</publishTime>
    </File>
    <File Include="bin/Swashbuckle.Core.dll">
      <publishTime>02/16/2015 01:57:08</publishTime>
      <publishTime>02/15/2015 17:57:08</publishTime>
    </File>
    <File Include="bin/System.ComponentModel.DataAnnotations.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -117,13 +117,13 @@
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.IdentityModel.Tokens.Jwt.dll">
      <publishTime>08/19/2014 18:03:34</publishTime>
      <publishTime>08/19/2014 10:03:34</publishTime>
    </File>
    <File Include="bin/System.Net.Http.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.Net.Http.Formatting.dll">
      <publishTime>11/28/2018 21:00:36</publishTime>
      <publishTime>11/28/2018 13:00:36</publishTime>
    </File>
    <File Include="bin/System.Runtime.Serialization.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -132,7 +132,7 @@
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.Web.Cors.dll">
      <publishTime>11/28/2018 20:58:44</publishTime>
      <publishTime>11/28/2018 12:58:44</publishTime>
    </File>
    <File Include="bin/System.Web.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -147,37 +147,37 @@
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.Web.Helpers.dll">
      <publishTime>01/28/2015 12:04:30</publishTime>
      <publishTime>01/28/2015 04:04:30</publishTime>
    </File>
    <File Include="bin/System.Web.Http.Cors.dll">
      <publishTime>11/28/2018 21:01:26</publishTime>
      <publishTime>11/28/2018 13:01:26</publishTime>
    </File>
    <File Include="bin/System.Web.Http.dll">
      <publishTime>11/28/2018 21:01:00</publishTime>
      <publishTime>11/28/2018 13:01:00</publishTime>
    </File>
    <File Include="bin/System.Web.Http.WebHost.dll">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="bin/System.Web.Mvc.dll">
      <publishTime>01/28/2015 12:02:18</publishTime>
      <publishTime>01/28/2015 04:02:18</publishTime>
    </File>
    <File Include="bin/System.Web.Optimization.dll">
      <publishTime>02/11/2014 23:26:04</publishTime>
      <publishTime>02/11/2014 15:26:04</publishTime>
    </File>
    <File Include="bin/System.Web.Razor.dll">
      <publishTime>01/28/2015 12:02:32</publishTime>
      <publishTime>01/28/2015 04:02:32</publishTime>
    </File>
    <File Include="bin/System.Web.Services.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/System.Web.WebPages.Deployment.dll">
      <publishTime>01/28/2015 12:04:30</publishTime>
      <publishTime>01/28/2015 04:04:30</publishTime>
    </File>
    <File Include="bin/System.Web.WebPages.dll">
      <publishTime>01/28/2015 12:04:30</publishTime>
      <publishTime>01/28/2015 04:04:30</publishTime>
    </File>
    <File Include="bin/System.Web.WebPages.Razor.dll">
      <publishTime>01/28/2015 12:04:30</publishTime>
      <publishTime>01/28/2015 04:04:30</publishTime>
    </File>
    <File Include="bin/System.Xml.dll">
      <publishTime>09/26/2012 03:16:08</publishTime>
@@ -186,184 +186,184 @@
      <publishTime>09/26/2012 03:16:08</publishTime>
    </File>
    <File Include="bin/WebActivatorEx.dll">
      <publishTime>11/24/2014 19:18:48</publishTime>
      <publishTime>11/24/2014 11:18:48</publishTime>
    </File>
    <File Include="bin/WebAPI.dll">
      <publishTime>10/08/2021 14:56:43</publishTime>
      <publishTime>09/30/2021 15:48:08</publishTime>
    </File>
    <File Include="bin/WebAPI.pdb">
      <publishTime>10/08/2021 14:56:43</publishTime>
      <publishTime>09/30/2021 15:48:08</publishTime>
    </File>
    <File Include="bin/WebGrease.dll">
      <publishTime>07/18/2013 01:03:52</publishTime>
      <publishTime>07/17/2013 17:03:52</publishTime>
    </File>
    <File Include="bin/zh-Hans/System.Net.Http.Formatting.resources.dll">
      <publishTime>11/29/2018 21:26:02</publishTime>
      <publishTime>11/29/2018 13:26:02</publishTime>
    </File>
    <File Include="bin/zh-Hans/System.Web.Http.resources.dll">
      <publishTime>11/29/2018 21:26:30</publishTime>
      <publishTime>11/29/2018 13:26:30</publishTime>
    </File>
    <File Include="Content/bootstrap.css">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Content/bootstrap.min.css">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Content/Site.css">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="DLL/BLL.dll">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="DLL/DAL.dll">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="DLL/DBUtility.dll">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="DLL/Kingdee.BOS.WebApi.Client.dll">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="DLL/Model.dll">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="DLL/Newtonsoft.Json.Net35.dll">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="DLL/Pub_Class.dll">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="DLL/Pub_Control.dll">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="DLL/SQLHelper.dll">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.eot">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:16</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.svg">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:16</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.ttf">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:16</publishTime>
    </File>
    <File Include="fonts/glyphicons-halflings-regular.woff">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:16</publishTime>
    </File>
    <File Include="Global.asax">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Index.html">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="packages.config">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:16</publishTime>
    </File>
    <File Include="Views/Scripts/bootstrap.js">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/Scripts/bootstrap.min.js">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.js">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.min.js">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/Scripts/jquery-1.10.2.min.map">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.js">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.min.js">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.unobtrusive.js">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/Scripts/modernizr-2.6.2.js">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/Shared/Error.cshtml">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/Shared/_Layout.cshtml">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/web.config">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Views/_ViewStart.cshtml">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Department_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Customer_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Department_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Employee_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Group_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Source_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource">
      <publishTime>08/25/2021 20:46:11</publishTime>
      <publishTime>08/16/2021 17:23:15</publishTime>
    </File>
    <File Include="Web References/WebS/Reference.map">
      <publishTime>08/06/2021 22:57:28</publishTime>
    </File>
    <File Include="Web.config">
      <publishTime>10/08/2021 14:56:49</publishTime>
      <publishTime>09/30/2021 15:48:15</publishTime>
    </File>
  </ItemGroup>
</Project>
WebAPI/WebAPI.csproj
@@ -318,6 +318,7 @@
    <Compile Include="Controllers\CJGL\Cj_StationOutBillController.cs" />
    <Compile Include="Controllers\CJGL\Cj_StationInBillController.cs" />
    <Compile Include="Controllers\CJGL\Cj_StationEntrustOutBillController.cs" />
    <Compile Include="Controllers\GZGL\Gy_DuSubsidyItemBillController.cs" />
    <Compile Include="Controllers\GZGL\Gy_WorkPayTypeBillController.cs" />
    <Compile Include="Controllers\GZGL\Gy_WorkTypeBillController.cs" />
    <Compile Include="Controllers\JHGL\Gy_RoutingBillController.cs" />
@@ -335,6 +336,7 @@
    <Compile Include="Controllers\ReportFromController.cs" />
    <Compile Include="Controllers\ReportPlatFormController.cs" />
    <Compile Include="Controllers\SCGL\Sc_MESProductReportBillController.cs" />
    <Compile Include="Controllers\Pay_SingleBalBillController.cs" />
    <Compile Include="Controllers\Sc_MouldRepairOutBillController.cs" />
    <Compile Include="Controllers\Sc_MouldRepairInBillListController - .cs" />
    <Compile Include="Controllers\Sc_MouldController.cs" />
@@ -372,6 +374,7 @@
    <Compile Include="Dapper\SqlPools.cs" />
    <Compile Include="DbUntil\DataFormatUntil.cs" />
    <Compile Include="DLL\ClsGy_BadReason_Ctl.cs" />
    <Compile Include="DLL\ClsGy_DuSubsidyItemBill.cs" />
    <Compile Include="DLL\ClsGy_Material_Ctl.cs" />
    <Compile Include="DLL\ClsGy_Source_Ctl.cs" />
    <Compile Include="DLL\ClsGy_WorkPayTypeBill.cs" />
WebAPI/WebAPI.csproj.user
@@ -9,7 +9,7 @@
    <WebStackScaffolding_IsAsyncSelected>False</WebStackScaffolding_IsAsyncSelected>
    <NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>D:\Git\houduan\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>D:\Git仓库\智云迈思\项目\MESWMS\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile>
    <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig>
    <UseIISExpress>false</UseIISExpress>
    <Use64BitIISExpress />
WorkM/WorkM.csproj
@@ -359,6 +359,12 @@
    <Compile Include="流转卡管理\MES_StationOutBill.designer.cs">
      <DependentUpon>MES_StationOutBill.cs</DependentUpon>
    </Compile>
    <Compile Include="流转卡管理\MES_StationOutBillList_Bad.cs">
      <SubType>Form</SubType>
    </Compile>
    <Compile Include="流转卡管理\MES_StationOutBillList_Bad.designer.cs">
      <DependentUpon>MES_StationOutBillList_Bad.cs</DependentUpon>
    </Compile>
    <Compile Include="流转卡管理\MES_StationOutBillList.cs">
      <SubType>Form</SubType>
    </Compile>
@@ -987,6 +993,10 @@
      <DependentUpon>MES_StationOutBill.cs</DependentUpon>
      <SubType>Designer</SubType>
    </EmbeddedResource>
    <EmbeddedResource Include="流转卡管理\MES_StationOutBillList_Bad.resx">
      <DependentUpon>MES_StationOutBillList_Bad.cs</DependentUpon>
      <SubType>Designer</SubType>
    </EmbeddedResource>
    <EmbeddedResource Include="流转卡管理\MES_StationOutBillList.resx">
      <DependentUpon>MES_StationOutBillList.cs</DependentUpon>
      <SubType>Designer</SubType>
WorkM/Á÷ת¿¨¹ÜÀí/MES_StationOutBillList_Bad.cs
New file
@@ -0,0 +1,707 @@
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using gregn6Lib;
using SQLHelper;
using DBUtility;
using System.IO;
using System.Reflection;
namespace WorkM
{
    public partial class MES_StationOutBillList_Bad : Form
    {
        public MES_StationOutBillList_Bad()
        {
            InitializeComponent();
        }
        public DBUtility.frmBillQueryCondition_New frmCondition;
        public string ViewName = "h_v_MES_StationOutBillList_Bad";
        public string ModCaption = "工序出站汇报不良品列表";
        public const string ModName = "3791";
        public const string ModRightName = "MES_StationOutBill";
        public const string ModRightNameEdit = ModRightName + "_Edit";
        public const string ModRightNameCheck = ModRightName + "_Check";
        public const string ModRightNameClose = ModRightName + "_Close";
        public const string ModRightNameDelete = ModRightName + "_Delete";
        DAL.ClsSc_StationOutBill oBill = new DAL.ClsSc_StationOutBill();
        public MES_StationOutBill oFrm;
        Pub_Class.ClsGridListSum oSumGrid = new Pub_Class.ClsGridListSum();
        public string sDlgWhere = "";  //外窗体递入
        //
        private void initGrid()
        {
            DBUtility.Xt_BaseBillFun.initGridList(grdMain,this.Name);
        }
        //
        private void Display()
        {
            ClsCN SubCn = new ClsCN();
            DataSet DSet;
            string sSql = "";
            string sWhere = "";
            if (frmCondition.SqlStr.Trim().Length == 0)
            {
                sSql = "Select top 5000 * from " + ViewName + " Where 1=1 " + sWhere + sDlgWhere + " order by hmainid desc ";
            }
            else
            {
                sSql = frmCondition.SqlStr + sWhere + sDlgWhere + " order by hmainid desc ";
            }
            //
            DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
            //生成首行标题
            if (DSet == null)
            {
                MessageBox.Show("没有返回任何结果,请在过滤框中点击【恢复】按钮,尝试再次查询!" + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            //释放冻结
            DBUtility.Xt_BaseBillFun.CancelFrozenCol(grdMain);
            //
            grdMain.DataSource = DSet.Tables[0].DefaultView;
            //设置合计列
            string sTotalCol = "";
            sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
            string[] sT;
            sT = sTotalCol.Split(Convert.ToChar(","));
            oSumGrid.BuildTotalCols(sT);
            //
            //冻结
            int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
            string s = frmCondition.cmbHComplete.Text;
            DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol);
            //画线
            GraphLine();
            Total();
            //
        }
        //
        private void timer1_Tick(object sender, EventArgs e)
        {
            timer1.Enabled=false;
            initGrid();
            Display();
        }
        private void tc_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        private void sx_Click(object sender, EventArgs e)
        {
            timer1.Enabled = true;
        }
        private void dj_Click(object sender, EventArgs e)
        {
            Sub_ShowBill();
        }
        //显示单据
        private void Sub_ShowBill()
        {
            Int64 lngBillKey = 0;
            if (grdMain.CurrentRow == null)
                return;
            lngBillKey =DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value);
            if (lngBillKey == 0)
                return;
            DAL.ClsSc_StationOutBill oBill = new DAL.ClsSc_StationOutBill();
            if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
            {
                oFrm = new MES_StationOutBill();
                oFrm.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_View;
                oFrm.BillOld = oBill;
                oFrm.ShowDialog();
                if (oFrm.BillChange)
                {
                    if (MessageBox.Show("单据列表已经发生变化,是否刷新", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                    {
                        timer1.Enabled = true;
                    }
                }
            }
            else
            {
                MessageBox.Show("单据未找到", "提示");
            }
            oBill = null;
        }
        //
        private Int32 Fun_GetCol(string sCol)
        {
            return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
        }
        //
        private void MES_StationOutBillList_Bad_Load(object sender, EventArgs e)
        {
            //
            frmCondition = new frmBillQueryCondition_New();
            this.Text = ModCaption;
            lblCaption.Text = ModCaption;
            oSumGrid.ogrdMain = grdMain;  //初始化 new
            oSumGrid.oGridsum = grdSum;
            initGrid();
        }
        private void grdMain_DblClick(object sender, EventArgs e)
        {
            Sub_ShowBill();
        }
        private void cx_Click(object sender, EventArgs e)
        {
            frmCondition = new frmBillQueryCondition_New();
            SetCondition(frmCondition, ViewName, this.Name);
            frmCondition.ShowDialog();
            if (frmCondition.Tag.ToString() == "OK")
            {
                Display();
            }
        }
        public void SetCondition(frmBillQueryCondition_New frmCondition, string ViewName, string Name)
        {
            frmCondition.Tag = "";
            frmCondition.ViewName = ViewName;
            frmCondition.ModName = Name;
        }
        private void xz_Click(object sender, EventArgs e)
        {
            //
            MES_StationOutBill oMES_StationOutBill = new MES_StationOutBill();
            oMES_StationOutBill.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
            oMES_StationOutBill.ModCaption = "工序出站汇报不良品清单";
            oMES_StationOutBill.ShowDialog();
        }
        private void sc_Click(object sender, EventArgs e)
        {
            Sub_DeleteBill();
        }
        //删除
        private void Sub_DeleteBill()
        {
            //编辑权限
            if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true, DBUtility.ClsPub.CurUserName))
            {
                return;
            }
            //
            Int64 lngBillKey = 0;
            if (grdMain.CurrentRow == null)
                return;
            lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value);
            if (lngBillKey == 0)
                return;
            DAL.ClsSc_StationOutBill  oBill = new DAL.ClsSc_StationOutBill();
            if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
            {
                if (MessageBox.Show("确定要删除当前单据?", "提示", MessageBoxButtons.OKCancel)==DialogResult.OK)
                {
                    if (oBill.omodel.HMaker != ClsPub.CurUserName && (ClsPub.CurUserName != "admin" && ClsPub.CurUserName != "Admin"))
                    {
                        MessageBox.Show("只能删除本人的单据!", "提示");
                        return;
                    }
                    string c = "";
                    SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
                    DataSet ds;
                    //判断生产订单是否已结案,要求计划手工反结案  åˆ¤æ–­æ˜¯å¦å­˜åœ¨ ç›¸åŒå•据号 çš„入库单 , ä¸‹é“工序是否进站
                    ds = oCn.RunProcReturn("exec h_p_MES_StationOutBill_DelCtrl  '" + oBill.omodel.HBillNo + "'", "h_p_MES_StationOutBill_DelCtrl");
                    if (ds == null)
                    {
                        MessageBox.Show("判断关联失败!");
                        return;
                    }
                    if (ds.Tables[0].Rows.Count > 0 && Pub_Class.ClsPub.isInt(ds.Tables[0].Rows[0][0]) == 2)
                    {
                        MessageBox.Show(Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0][1]));
                        return;
                    }
                    //if (oBill.DeleteCheck(oBill.omodel.HInterID,"出站单", ref c) == false)
                    //{
                    //    MessageBox.Show(c, "提示");
                    //    return;
                    //}
                    //if (oBill.omodel.HChecker != "")
                    //{
                    //    MessageBox.Show("单据已经审核,不能删除!", "提示");
                    //    return;
                    //}
                    //if (!oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo))
                    //写入删除日志
                    string WorkList = "删除出站单:" + oBill.omodel.HBillNo;
                    //BLL.ClsPub_BLL.System_Log_DropAdd(WorkList);
                    if (!oBill.DeleteBill(oBill.omodel.HInterID, oBill.omodel.HProcExchInterID, oBill.omodel.HProcExchEntryID, ref DBUtility.ClsPub.sExeReturnInfo))
                    {
                        MessageBox.Show(DBUtility.ClsPub.sExeReturnInfo, "提示");
                        return;
                    }
                    else
                    {
                        Display();
                    }
                }
            }
            else
            {
                MessageBox.Show("单据未找到", "提示");
            }
        }
        private void timer2_Tick(object sender, EventArgs e)
        {
            timer2.Enabled = false;
            frmCondition = new frmBillQueryCondition_New();
            SetCondition(frmCondition, ViewName, this.Name);
            frmCondition.ShowDialog();
            if (frmCondition.Tag.ToString() == "OK")
            {
                timer1.Enabled = true;
            }
        }
        private void bclk_Click(object sender, EventArgs e)
        {
            //保存列宽
            DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
        }
        private void mrlk_Click(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
        }
        //
        private void GraphLine()
        {
            int MainIDCol = Fun_GetCol("hmainid");
            int SubIDCol = Fun_GetCol("hsubid");
            string s = frmCondition.cmbHComplete.Text;
            long n=0;
            DBUtility.Xt_BaseBillFun.GraphLine(grdMain, MainIDCol, SubIDCol, s,ref n);
            //显示
            lbldj.Text = "查询出 " + n.ToString() + " å¼ å•据";
            lbljl.Text = "共有 " + grdMain.RowCount.ToString() + " æ¡è®°å½•";
        }
        //审核
        private void sh_Click(object sender, EventArgs e)
        {
            this.Sub_CheckBill();
        }
        //审核单据
        private void Sub_CheckBill()
        {
            //审核权限
            if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, DBUtility.ClsPub.CurUserName))
            {
                return;
            }
            //
            Int64 lngBillKey = 0;
            if (grdMain.CurrentRow == null)
                return;
            lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value);
            if (lngBillKey == 0)
                return;
            DAL.ClsSc_StationOutBill oBill = new DAL.ClsSc_StationOutBill();
            //查看是否已审核,关闭,作废
            if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
            {
                if (oBill.omodel.HChecker.Trim() != "")
                {
                    MessageBox.Show("单据已审核!不能再次审核", "提示");
                    return;
                }
            }
            else
            {
                MessageBox.Show("单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
                return;
            }
            //审核
            if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
            {
                MessageBox.Show("审核成功!", "提示");
                return;
            }
            else
            {
                MessageBox.Show("审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
                return;
            }
        }
        //反审单据
        private void Sub_AbandonCheck()
        {
            //审核权限
            if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true,DBUtility.ClsPub.CurUserName))
            {
                return;
            }
            //
            Int64 lngBillKey = 0;
            if (grdMain.CurrentRow == null)
                return;
            lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value);
            if (lngBillKey == 0)
                return;
            DAL.ClsSc_StationOutBill oBill = new DAL.ClsSc_StationOutBill();
            //查看是否已审核,关闭,作废
            if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
            {
                if (oBill.omodel.HChecker.Trim() == "")
                {
                    MessageBox.Show("单据未审核!不需要反审核!", "提示");
                    return;
                }
            }
            else
            {
                MessageBox.Show("单据不存在!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
                return;
            }
            //反审核
            if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
            {
                MessageBox.Show("反审核成功!", "提示");
                return;
            }
            else
            {
                MessageBox.Show("反审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
                return;
            }
        }
        //反审核
        private void qsh_Click(object sender, EventArgs e)
        {
            Sub_AbandonCheck();
        }
        private void GraphicsGrid()
        {
            DBUtility.Xt_BaseBillFun.GraphicsGrid(grdMain);
        }
        #region  //打印设置
        GridppReport Report;
        //预览
        private void yl_Click(object sender, EventArgs e)
        {
            //选择打印模板
            BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp();
            oFrm.sBillName = ModName;
            oFrm.sBillModel = ModCaption;
            oFrm.ShowDialog();
            if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK)
            {
                //
                Sub_SetReport(oFrm.sOpenTmp);
                Report.PrintPreview(true);
            }
        }
        private void Sub_SetReport(string sOpenTmp)
        {
            //判断行数
            for (int i = 0; i < grdMain.Rows.Count; i++)
            {
                grdMain.Rows[i].Cells[0].Value = "";
            }
            for (int i = 0; i < grdMain.SelectedRows.Count; i++)
            {
                grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[0].Value = "*";
            }
            //
            //
            Report = new GridppReport();
            Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf");  //here .
            Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
        }
        private void ReportFetchRecordByDataTable()
        {
            DataTable dt = new DataTable();
            BLL.Utility.FillRecordToReport_Sel(Report, grdMain, dt, Fun_GetCol("选择"));
        }
        #endregion
        //
        private void grdMain_Paint(object sender, PaintEventArgs e)
        {
            GraphicsGrid();
        }
        //合计 new
        private void Total()
        {
            if (grdMain.Rows.Count > 0 &&  grdMain.ColumnCount>0)
            {
                oSumGrid.SetGridsum();
                //oSumGrid.Total();
                oSumGrid.TotalAll();
            }
        }
        //合计 new
        private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
        {
            Total();
        }
        //合计 new
        private void grdMain_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e)
        {
            //Total();
        }
        //引出EXCEL
        private void dc_Click(object sender, EventArgs e)
        {
            //DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
            DataGridViewToExcel2();
        }
        private void txtHBillNo_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                Sub_FastQuery();
            }
        }
        //快速过滤
        private void Sub_FastQuery()
        {
            string sFastSQL = "";
            //LOT号
            if (txtHBillNo.Text.Trim() != "")
            {
                sFastSQL = sFastSQL + " and æµè½¬å¡å· like '%" + txtHBillNo.Text + "%'";
            }
            //工作中心
            if (txtHCenterID.Text.Trim() != "")
            {
                sFastSQL = sFastSQL + " and (工作中心 like '%" + txtHCenterID.Text + "%' or å·¥ä½œä¸­å¿ƒä»£ç  like '%" + txtHCenterID.Text + "%') ";
            }
            //订单跟踪号
            if (txtHOrderProcNO.Text.Trim() != "")
            {
                sFastSQL = sFastSQL + " and (订单跟踪号 like '%" + txtHOrderProcNO.Text + "%'  ) ";
            }
            //同步状态
            if(cmbHStatus.Text.Trim()=="未同步")
            {
                sFastSQL = sFastSQL + " and (同步状态='" + cmbHStatus.Text.Trim() + "'  ) ";
            }
            if (cmbHStatus.Text.Trim() == "已同步")
            {
                sFastSQL = sFastSQL + " and (同步状态='" + cmbHStatus.Text.Trim() + "'  ) ";
            }
            sDlgWhere = sFastSQL;
            Display();
        }
        private void DataGridViewToExcel2()
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Filter = "Execl文件(*.xls)|*.xls";
            saveFileDialog.FilterIndex = 0;
            saveFileDialog.RestoreDirectory = true;
            saveFileDialog.CreatePrompt = true;
            saveFileDialog.Title = "数据视图导出EXCEL文件";
            saveFileDialog.ShowDialog();
            if (saveFileDialog.FileName == "")
            {
                return;
            }
            Stream myStream;
            myStream = saveFileDialog.OpenFile();
            StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
            string str = "";
            DateTime start = DateTime.Now;
            try
            {
                //写标题
                for (int i = 0; i < grdMain.ColumnCount; i++)
                {
                    if (i > 0)
                    {
                        str += "\t";
                    }
                    str += grdMain.Columns[i].HeaderText;
                }
                sw.WriteLine(str);
                //写内容
                for (int j = 0; j < grdMain.Rows.Count; j++)
                {
                    string tempStr = "";
                    for (int k = 0; k < grdMain.Columns.Count; k++)
                    {
                        if (k > 0)
                        {
                            tempStr += "\t";
                        }
                        if (grdMain.Rows[j].Cells[k].Value == null)
                        {
                            tempStr += string.Empty;
                        }
                        else
                        {
                            tempStr += grdMain.Rows[j].Cells[k].Value.ToString();
                        }
                    }
                    sw.WriteLine(tempStr);
                }
                sw.Close();
                myStream.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                sw.Close();
                myStream.Close();
            }
            MessageBox.Show("将此工作表导出为excel共耗时:" + DateTime.Now.Subtract(start).TotalMilliseconds.ToString() + "毫秒");
        }
        private void txtHCenterID_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                Sub_FastQuery();
            }
        }
        private void grdMain_Scroll(object sender, ScrollEventArgs e)
        {
            if (e.ScrollOrientation == ScrollOrientation.HorizontalScroll)
            {
                Total();
            }
        }
        private void txtHOrderProcNO_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                Sub_FastQuery();
            }
        }
        private void bzd_Click(object sender, EventArgs e)
        {
            //根据选中的数据生成包装单
            int MainIDCol =  Fun_GetCol("hmainid");
            int SubIDCol = Fun_GetCol("hsubid");
            int BillNoCol = Fun_GetCol("单据号");
            int HUserK3Col = Fun_GetCol("K3用户");
            int HKeepCol = Fun_GetCol("K3保管");
            int HSecManagerCol = Fun_GetCol("K3验收");
            int HDeptCol = Fun_GetCol("K3部门");
            DAL.ClsKf_ProductInBill oClsKf_ProductInBill ;
            //获取系统参数
            Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();
            if (oSystemParameter.ShowBill(ref DBUtility.ClsPub.sExeReturnInfo) == false)
            {
                MessageBox.Show("获取系统参数失败! " + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            //判断会计期是否合理
            string s = "";
            int sYear = 0;
            int sPeriod = 0;
            if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(DateTime.Today, ref sYear, ref sPeriod, ref s) == false)
            {
                MessageBox.Show("会计期间有错误! " + DBUtility.ClsPub.sExeReturnInfo);
                return;
            }
            Int64 n = 0;
            //循环 é€‰ä¸­è¡Œ
            for (int i = 0; i < grdMain.SelectedRows.Count; i++)
            {
                oClsKf_ProductInBill = new DAL.ClsKf_ProductInBill();
                oClsKf_ProductInBill.omodel.HYear = sYear;
                oClsKf_ProductInBill.omodel.HPeriod = sPeriod;
                oClsKf_ProductInBill.omodel.HInterID = ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[MainIDCol].Value);
                oClsKf_ProductInBill.omodel.HDate = DateTime.Today;
                oClsKf_ProductInBill.omodel.HBillNo = ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[BillNoCol].Value);
                oClsKf_ProductInBill.omodel.HDeptID = ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[HDeptCol].Value);
                oClsKf_ProductInBill.omodel.HEmpID = ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[HKeepCol].Value);
                oClsKf_ProductInBill.omodel.HSecManagerID = ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[HSecManagerCol].Value);
                oClsKf_ProductInBill.omodel.HKeeperID = ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[HKeepCol].Value);
                oClsKf_ProductInBill.omodel.HBillerID = ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[i].Index].Cells[HUserK3Col].Value);
                oClsKf_ProductInBill.omodel.HRemark = "不良品同步";
                oClsKf_ProductInBill.omodel.HMaker =  DBUtility.ClsPub.CurUserName;
                oClsKf_ProductInBill.omodel.HWHID = 0;
                oClsKf_ProductInBill.omodel.HSupID = 0;
                oClsKf_ProductInBill.omodel.HExplanation = "";
                if(oClsKf_ProductInBill.omodel.HBillerID==0 || oClsKf_ProductInBill.omodel.HKeeperID==0
                    || oClsKf_ProductInBill.omodel.HEmpID==0 || oClsKf_ProductInBill.omodel.HDeptID==0
                    || oClsKf_ProductInBill.omodel.HSecManagerID ==0 )
                {
                    MessageBox.Show("没有设置金蝶用户、部门、保管、验收员! " + DBUtility.ClsPub.sExeReturnInfo);
                    continue;
                }
                if(oClsKf_ProductInBill.AddBill_StationOut_Bad("3710", oSystemParameter.omodel, ref DBUtility.ClsPub.sExeReturnInfo))
                {
                    n++;
                }
                else
                {
                    MessageBox.Show("同步单据失败!"+ DBUtility.ClsPub.sExeReturnInfo);
                }
                //休眠5秒
                System.Threading.Thread.Sleep(2000);
                //
            }
            //
            if (n > 0)
            {
                MessageBox.Show("同步单据完毕!一共有" + n.ToString() + "张入库单!");
                initGrid();
                Display();
            }
        }
        private void eXCELToolStripMenuItem_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataToExcel(this.Text, grdMain);
        }
        private void cSVToolStripMenuItem_Click(object sender, EventArgs e)
        {
            DBUtility.Gy_BaseFun.DataGridViewToExcel2(grdMain, this.Text, this.Text);
        }
        private void cmbHStatus_SelectedIndexChanged(object sender, EventArgs e)
        {
            Sub_FastQuery();
        }
    }
}
WorkM/Á÷ת¿¨¹ÜÀí/MES_StationOutBillList_Bad.designer.cs
New file
@@ -0,0 +1,673 @@
namespace WorkM
{
    partial class MES_StationOutBillList_Bad
    {
        /// <summary>
        /// å¿…需的设计器变量。
        /// </summary>
        private System.ComponentModel.IContainer components = null;
        /// <summary>
        /// æ¸…理所有正在使用的资源。
        /// </summary>
        /// <param name="disposing">如果应释放托管资源,为 true;否则为 false。</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }
        #region Windows çª—体设计器生成的代码
        /// <summary>
        /// è®¾è®¡å™¨æ”¯æŒæ‰€éœ€çš„æ–¹æ³• - ä¸è¦
        /// ä½¿ç”¨ä»£ç ç¼–辑器修改此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {
            this.components = new System.ComponentModel.Container();
            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(MES_StationOutBillList_Bad));
            this.pPic = new System.Windows.Forms.Panel();
            this.cmbHStatus = new System.Windows.Forms.ComboBox();
            this.label4 = new System.Windows.Forms.Label();
            this.label3 = new System.Windows.Forms.Label();
            this.txtHOrderProcNO = new System.Windows.Forms.TextBox();
            this.label2 = new System.Windows.Forms.Label();
            this.txtHCenterID = new System.Windows.Forms.TextBox();
            this.label1 = new System.Windows.Forms.Label();
            this.txtHBillNo = new System.Windows.Forms.TextBox();
            this.panel1 = new System.Windows.Forms.Panel();
            this.lbljl = new System.Windows.Forms.Label();
            this.lbldj = new System.Windows.Forms.Label();
            this.lblCaption = new System.Windows.Forms.Label();
            this.Tool = new System.Windows.Forms.ToolStrip();
            this.toolStripDropDownButton1 = new System.Windows.Forms.ToolStripDropDownButton();
            this.eXCELToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.cSVToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.dc = new System.Windows.Forms.ToolStripButton();
            this.yl = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator2 = new System.Windows.Forms.ToolStripSeparator();
            this.cx = new System.Windows.Forms.ToolStripButton();
            this.sx = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator1 = new System.Windows.Forms.ToolStripSeparator();
            this.xz = new System.Windows.Forms.ToolStripButton();
            this.dj = new System.Windows.Forms.ToolStripButton();
            this.sc = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator5 = new System.Windows.Forms.ToolStripSeparator();
            this.sh = new System.Windows.Forms.ToolStripButton();
            this.qsh = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator6 = new System.Windows.Forms.ToolStripSeparator();
            this.bzd = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator4 = new System.Windows.Forms.ToolStripSeparator();
            this.tc = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator3 = new System.Windows.Forms.ToolStripSeparator();
            this.toolStripSeparator9 = new System.Windows.Forms.ToolStripSeparator();
            this.mrlk = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator7 = new System.Windows.Forms.ToolStripSeparator();
            this.bclk = new System.Windows.Forms.ToolStripButton();
            this.toolStripSeparator8 = new System.Windows.Forms.ToolStripSeparator();
            this.timer1 = new System.Windows.Forms.Timer(this.components);
            this.timer2 = new System.Windows.Forms.Timer(this.components);
            this.grdMain = new System.Windows.Forms.DataGridView();
            this.grdPrint = new System.Windows.Forms.DataGridView();
            this.grdSum = new System.Windows.Forms.DataGridView();
            this.pPic.SuspendLayout();
            this.panel1.SuspendLayout();
            this.Tool.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdPrint)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).BeginInit();
            this.SuspendLayout();
            //
            // pPic
            //
            this.pPic.BackColor = System.Drawing.Color.White;
            this.pPic.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("pPic.BackgroundImage")));
            this.pPic.BackgroundImageLayout = System.Windows.Forms.ImageLayout.None;
            this.pPic.Controls.Add(this.cmbHStatus);
            this.pPic.Controls.Add(this.label4);
            this.pPic.Controls.Add(this.label3);
            this.pPic.Controls.Add(this.txtHOrderProcNO);
            this.pPic.Controls.Add(this.label2);
            this.pPic.Controls.Add(this.txtHCenterID);
            this.pPic.Controls.Add(this.label1);
            this.pPic.Controls.Add(this.txtHBillNo);
            this.pPic.Controls.Add(this.panel1);
            this.pPic.Controls.Add(this.lblCaption);
            this.pPic.Dock = System.Windows.Forms.DockStyle.Top;
            this.pPic.Location = new System.Drawing.Point(0, 62);
            this.pPic.Margin = new System.Windows.Forms.Padding(4);
            this.pPic.Name = "pPic";
            this.pPic.Size = new System.Drawing.Size(1661, 66);
            this.pPic.TabIndex = 15;
            //
            // cmbHStatus
            //
            this.cmbHStatus.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
            this.cmbHStatus.FormattingEnabled = true;
            this.cmbHStatus.Items.AddRange(new object[] {
            "未同步",
            "已同步",
            "全部"});
            this.cmbHStatus.Location = new System.Drawing.Point(461, 15);
            this.cmbHStatus.Name = "cmbHStatus";
            this.cmbHStatus.Size = new System.Drawing.Size(121, 23);
            this.cmbHStatus.TabIndex = 20;
            this.cmbHStatus.SelectedIndexChanged += new System.EventHandler(this.cmbHStatus_SelectedIndexChanged);
            //
            // label4
            //
            this.label4.AutoSize = true;
            this.label4.BackColor = System.Drawing.Color.Transparent;
            this.label4.Location = new System.Drawing.Point(374, 19);
            this.label4.Name = "label4";
            this.label4.Size = new System.Drawing.Size(67, 15);
            this.label4.TabIndex = 19;
            this.label4.Text = "同步状态";
            //
            // label3
            //
            this.label3.AutoSize = true;
            this.label3.BackColor = System.Drawing.Color.Transparent;
            this.label3.Location = new System.Drawing.Point(759, 53);
            this.label3.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            this.label3.Name = "label3";
            this.label3.Size = new System.Drawing.Size(97, 15);
            this.label3.TabIndex = 18;
            this.label3.Text = "订单跟踪号:";
            this.label3.Visible = false;
            //
            // txtHOrderProcNO
            //
            this.txtHOrderProcNO.Location = new System.Drawing.Point(865, 48);
            this.txtHOrderProcNO.Margin = new System.Windows.Forms.Padding(4);
            this.txtHOrderProcNO.Name = "txtHOrderProcNO";
            this.txtHOrderProcNO.Size = new System.Drawing.Size(215, 25);
            this.txtHOrderProcNO.TabIndex = 17;
            this.txtHOrderProcNO.Visible = false;
            this.txtHOrderProcNO.KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtHOrderProcNO_KeyDown);
            //
            // label2
            //
            this.label2.AutoSize = true;
            this.label2.BackColor = System.Drawing.Color.Transparent;
            this.label2.Location = new System.Drawing.Point(630, 19);
            this.label2.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            this.label2.Name = "label2";
            this.label2.Size = new System.Drawing.Size(82, 15);
            this.label2.TabIndex = 14;
            this.label2.Text = "工作中心:";
            //
            // txtHCenterID
            //
            this.txtHCenterID.Location = new System.Drawing.Point(720, 15);
            this.txtHCenterID.Margin = new System.Windows.Forms.Padding(4);
            this.txtHCenterID.Name = "txtHCenterID";
            this.txtHCenterID.Size = new System.Drawing.Size(215, 25);
            this.txtHCenterID.TabIndex = 15;
            this.txtHCenterID.KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtHCenterID_KeyDown);
            //
            // label1
            //
            this.label1.AutoSize = true;
            this.label1.Location = new System.Drawing.Point(944, 19);
            this.label1.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            this.label1.Name = "label1";
            this.label1.Size = new System.Drawing.Size(82, 15);
            this.label1.TabIndex = 8;
            this.label1.Text = "流转卡号:";
            //
            // txtHBillNo
            //
            this.txtHBillNo.Location = new System.Drawing.Point(1034, 15);
            this.txtHBillNo.Margin = new System.Windows.Forms.Padding(4);
            this.txtHBillNo.Name = "txtHBillNo";
            this.txtHBillNo.Size = new System.Drawing.Size(215, 25);
            this.txtHBillNo.TabIndex = 9;
            this.txtHBillNo.KeyDown += new System.Windows.Forms.KeyEventHandler(this.txtHBillNo_KeyDown);
            //
            // panel1
            //
            this.panel1.Controls.Add(this.lbljl);
            this.panel1.Controls.Add(this.lbldj);
            this.panel1.Dock = System.Windows.Forms.DockStyle.Right;
            this.panel1.Location = new System.Drawing.Point(1398, 0);
            this.panel1.Margin = new System.Windows.Forms.Padding(4);
            this.panel1.Name = "panel1";
            this.panel1.Size = new System.Drawing.Size(263, 66);
            this.panel1.TabIndex = 7;
            //
            // lbljl
            //
            this.lbljl.AutoSize = true;
            this.lbljl.Location = new System.Drawing.Point(32, 38);
            this.lbljl.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            this.lbljl.Name = "lbljl";
            this.lbljl.Size = new System.Drawing.Size(15, 15);
            this.lbljl.TabIndex = 1;
            this.lbljl.Text = " ";
            //
            // lbldj
            //
            this.lbldj.AutoSize = true;
            this.lbldj.Location = new System.Drawing.Point(32, 15);
            this.lbldj.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            this.lbldj.Name = "lbldj";
            this.lbldj.Size = new System.Drawing.Size(0, 15);
            this.lbldj.TabIndex = 0;
            //
            // lblCaption
            //
            this.lblCaption.AutoSize = true;
            this.lblCaption.BackColor = System.Drawing.Color.Transparent;
            this.lblCaption.Cursor = System.Windows.Forms.Cursors.No;
            this.lblCaption.Font = new System.Drawing.Font("宋体", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.lblCaption.Location = new System.Drawing.Point(16, 19);
            this.lblCaption.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
            this.lblCaption.Name = "lblCaption";
            this.lblCaption.Size = new System.Drawing.Size(264, 27);
            this.lblCaption.TabIndex = 4;
            this.lblCaption.Text = "工序汇报不良品列表";
            this.lblCaption.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
            //
            // Tool
            //
            this.Tool.AutoSize = false;
            this.Tool.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("Tool.BackgroundImage")));
            this.Tool.BackgroundImageLayout = System.Windows.Forms.ImageLayout.Stretch;
            this.Tool.ImageScalingSize = new System.Drawing.Size(22, 22);
            this.Tool.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.toolStripDropDownButton1,
            this.dc,
            this.yl,
            this.toolStripSeparator2,
            this.cx,
            this.sx,
            this.toolStripSeparator1,
            this.xz,
            this.dj,
            this.sc,
            this.toolStripSeparator5,
            this.sh,
            this.qsh,
            this.toolStripSeparator6,
            this.bzd,
            this.toolStripSeparator4,
            this.tc,
            this.toolStripSeparator3,
            this.toolStripSeparator9,
            this.mrlk,
            this.toolStripSeparator7,
            this.bclk,
            this.toolStripSeparator8});
            this.Tool.Location = new System.Drawing.Point(0, 0);
            this.Tool.Name = "Tool";
            this.Tool.Padding = new System.Windows.Forms.Padding(0);
            this.Tool.Size = new System.Drawing.Size(1661, 62);
            this.Tool.Stretch = true;
            this.Tool.TabIndex = 16;
            this.Tool.Text = "toolStrip1";
            //
            // toolStripDropDownButton1
            //
            this.toolStripDropDownButton1.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.eXCELToolStripMenuItem,
            this.cSVToolStripMenuItem});
            this.toolStripDropDownButton1.Image = ((System.Drawing.Image)(resources.GetObject("toolStripDropDownButton1.Image")));
            this.toolStripDropDownButton1.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.toolStripDropDownButton1.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.toolStripDropDownButton1.Name = "toolStripDropDownButton1";
            this.toolStripDropDownButton1.Size = new System.Drawing.Size(53, 59);
            this.toolStripDropDownButton1.Text = "引出";
            this.toolStripDropDownButton1.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.toolStripDropDownButton1.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            //
            // eXCELToolStripMenuItem
            //
            this.eXCELToolStripMenuItem.Name = "eXCELToolStripMenuItem";
            this.eXCELToolStripMenuItem.Size = new System.Drawing.Size(136, 26);
            this.eXCELToolStripMenuItem.Text = "EXCEL";
            this.eXCELToolStripMenuItem.Click += new System.EventHandler(this.eXCELToolStripMenuItem_Click);
            //
            // cSVToolStripMenuItem
            //
            this.cSVToolStripMenuItem.Name = "cSVToolStripMenuItem";
            this.cSVToolStripMenuItem.Size = new System.Drawing.Size(136, 26);
            this.cSVToolStripMenuItem.Text = "CSV";
            this.cSVToolStripMenuItem.Click += new System.EventHandler(this.cSVToolStripMenuItem_Click);
            //
            // dc
            //
            this.dc.AutoSize = false;
            this.dc.Image = ((System.Drawing.Image)(resources.GetObject("dc.Image")));
            this.dc.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dc.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.dc.ImageTransparentColor = System.Drawing.Color.White;
            this.dc.Name = "dc";
            this.dc.Size = new System.Drawing.Size(36, 47);
            this.dc.Text = "引出";
            this.dc.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.dc.Click += new System.EventHandler(this.dc_Click);
            //
            // yl
            //
            this.yl.AutoSize = false;
            this.yl.Image = ((System.Drawing.Image)(resources.GetObject("yl.Image")));
            this.yl.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.yl.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.yl.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.yl.Name = "yl";
            this.yl.Size = new System.Drawing.Size(36, 47);
            this.yl.Text = "预览";
            this.yl.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.yl.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.yl.Click += new System.EventHandler(this.yl_Click);
            //
            // toolStripSeparator2
            //
            this.toolStripSeparator2.Name = "toolStripSeparator2";
            this.toolStripSeparator2.Size = new System.Drawing.Size(6, 62);
            //
            // cx
            //
            this.cx.AutoSize = false;
            this.cx.Image = ((System.Drawing.Image)(resources.GetObject("cx.Image")));
            this.cx.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.cx.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.cx.ImageTransparentColor = System.Drawing.Color.White;
            this.cx.Name = "cx";
            this.cx.Size = new System.Drawing.Size(36, 47);
            this.cx.Text = "查询";
            this.cx.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.cx.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.cx.Click += new System.EventHandler(this.cx_Click);
            //
            // sx
            //
            this.sx.AutoSize = false;
            this.sx.Image = ((System.Drawing.Image)(resources.GetObject("sx.Image")));
            this.sx.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.sx.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.sx.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.sx.Name = "sx";
            this.sx.Size = new System.Drawing.Size(36, 47);
            this.sx.Text = "刷新";
            this.sx.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.sx.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.sx.Click += new System.EventHandler(this.sx_Click);
            //
            // toolStripSeparator1
            //
            this.toolStripSeparator1.Name = "toolStripSeparator1";
            this.toolStripSeparator1.Size = new System.Drawing.Size(6, 62);
            //
            // xz
            //
            this.xz.AutoSize = false;
            this.xz.Image = ((System.Drawing.Image)(resources.GetObject("xz.Image")));
            this.xz.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.xz.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.xz.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.xz.Name = "xz";
            this.xz.Size = new System.Drawing.Size(36, 47);
            this.xz.Text = "新增";
            this.xz.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.xz.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.xz.Visible = false;
            this.xz.Click += new System.EventHandler(this.xz_Click);
            //
            // dj
            //
            this.dj.AutoSize = false;
            this.dj.Image = ((System.Drawing.Image)(resources.GetObject("dj.Image")));
            this.dj.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dj.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.dj.ImageTransparentColor = System.Drawing.Color.White;
            this.dj.Name = "dj";
            this.dj.Size = new System.Drawing.Size(36, 47);
            this.dj.Text = "单据";
            this.dj.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.dj.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.dj.Visible = false;
            this.dj.Click += new System.EventHandler(this.dj_Click);
            //
            // sc
            //
            this.sc.AutoSize = false;
            this.sc.Image = ((System.Drawing.Image)(resources.GetObject("sc.Image")));
            this.sc.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.sc.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.sc.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.sc.Name = "sc";
            this.sc.Size = new System.Drawing.Size(36, 47);
            this.sc.Text = "删除";
            this.sc.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.sc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.sc.Visible = false;
            this.sc.Click += new System.EventHandler(this.sc_Click);
            //
            // toolStripSeparator5
            //
            this.toolStripSeparator5.Name = "toolStripSeparator5";
            this.toolStripSeparator5.Size = new System.Drawing.Size(6, 62);
            this.toolStripSeparator5.Visible = false;
            //
            // sh
            //
            this.sh.AutoSize = false;
            this.sh.Image = ((System.Drawing.Image)(resources.GetObject("sh.Image")));
            this.sh.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.sh.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.sh.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.sh.Name = "sh";
            this.sh.Size = new System.Drawing.Size(36, 47);
            this.sh.Text = "审核";
            this.sh.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.sh.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.sh.Visible = false;
            this.sh.Click += new System.EventHandler(this.sh_Click);
            //
            // qsh
            //
            this.qsh.AutoSize = false;
            this.qsh.Image = ((System.Drawing.Image)(resources.GetObject("qsh.Image")));
            this.qsh.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.qsh.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.qsh.ImageTransparentColor = System.Drawing.Color.Magenta;
            this.qsh.Name = "qsh";
            this.qsh.Size = new System.Drawing.Size(36, 47);
            this.qsh.Text = "反审";
            this.qsh.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.qsh.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.qsh.Visible = false;
            this.qsh.Click += new System.EventHandler(this.qsh_Click);
            //
            // toolStripSeparator6
            //
            this.toolStripSeparator6.Name = "toolStripSeparator6";
            this.toolStripSeparator6.Size = new System.Drawing.Size(6, 62);
            //
            // bzd
            //
            this.bzd.AutoSize = false;
            this.bzd.Image = ((System.Drawing.Image)(resources.GetObject("bzd.Image")));
            this.bzd.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.bzd.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.bzd.ImageTransparentColor = System.Drawing.Color.White;
            this.bzd.Name = "bzd";
            this.bzd.Size = new System.Drawing.Size(36, 47);
            this.bzd.Text = "入库";
            this.bzd.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.bzd.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.bzd.ToolTipText = "入库";
            this.bzd.Click += new System.EventHandler(this.bzd_Click);
            //
            // toolStripSeparator4
            //
            this.toolStripSeparator4.Name = "toolStripSeparator4";
            this.toolStripSeparator4.Size = new System.Drawing.Size(6, 62);
            //
            // tc
            //
            this.tc.AutoSize = false;
            this.tc.Image = ((System.Drawing.Image)(resources.GetObject("tc.Image")));
            this.tc.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.tc.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.tc.ImageTransparentColor = System.Drawing.Color.White;
            this.tc.Name = "tc";
            this.tc.Size = new System.Drawing.Size(36, 47);
            this.tc.Text = "退出";
            this.tc.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.tc.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.tc.Click += new System.EventHandler(this.tc_Click);
            //
            // toolStripSeparator3
            //
            this.toolStripSeparator3.Name = "toolStripSeparator3";
            this.toolStripSeparator3.Size = new System.Drawing.Size(6, 62);
            //
            // toolStripSeparator9
            //
            this.toolStripSeparator9.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.toolStripSeparator9.Name = "toolStripSeparator9";
            this.toolStripSeparator9.Size = new System.Drawing.Size(6, 62);
            //
            // mrlk
            //
            this.mrlk.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.mrlk.Image = ((System.Drawing.Image)(resources.GetObject("mrlk.Image")));
            this.mrlk.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.mrlk.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.mrlk.ImageTransparentColor = System.Drawing.Color.White;
            this.mrlk.Name = "mrlk";
            this.mrlk.Size = new System.Drawing.Size(73, 59);
            this.mrlk.Text = "默认列宽";
            this.mrlk.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.mrlk.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.mrlk.Click += new System.EventHandler(this.mrlk_Click);
            //
            // toolStripSeparator7
            //
            this.toolStripSeparator7.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.toolStripSeparator7.Name = "toolStripSeparator7";
            this.toolStripSeparator7.Size = new System.Drawing.Size(6, 62);
            //
            // bclk
            //
            this.bclk.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.bclk.Image = ((System.Drawing.Image)(resources.GetObject("bclk.Image")));
            this.bclk.ImageAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.bclk.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
            this.bclk.ImageTransparentColor = System.Drawing.Color.White;
            this.bclk.Name = "bclk";
            this.bclk.Size = new System.Drawing.Size(73, 59);
            this.bclk.Text = "保存列宽";
            this.bclk.TextAlign = System.Drawing.ContentAlignment.BottomCenter;
            this.bclk.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
            this.bclk.Click += new System.EventHandler(this.bclk_Click);
            //
            // toolStripSeparator8
            //
            this.toolStripSeparator8.Alignment = System.Windows.Forms.ToolStripItemAlignment.Right;
            this.toolStripSeparator8.Name = "toolStripSeparator8";
            this.toolStripSeparator8.Size = new System.Drawing.Size(6, 62);
            //
            // timer1
            //
            this.timer1.Tick += new System.EventHandler(this.timer1_Tick);
            //
            // timer2
            //
            this.timer2.Enabled = true;
            this.timer2.Tick += new System.EventHandler(this.timer2_Tick);
            //
            // grdMain
            //
            this.grdMain.AllowUserToAddRows = false;
            this.grdMain.AllowUserToDeleteRows = false;
            this.grdMain.BackgroundColor = System.Drawing.SystemColors.InactiveCaption;
            this.grdMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdMain.Dock = System.Windows.Forms.DockStyle.Fill;
            this.grdMain.Location = new System.Drawing.Point(0, 128);
            this.grdMain.Margin = new System.Windows.Forms.Padding(4);
            this.grdMain.Name = "grdMain";
            this.grdMain.ReadOnly = true;
            this.grdMain.RowHeadersWidth = 51;
            this.grdMain.RowTemplate.Height = 23;
            this.grdMain.Size = new System.Drawing.Size(1661, 512);
            this.grdMain.TabIndex = 19;
            this.grdMain.CellMouseUp += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.grdMain_CellMouseUp);
            this.grdMain.ColumnWidthChanged += new System.Windows.Forms.DataGridViewColumnEventHandler(this.grdMain_ColumnWidthChanged);
            this.grdMain.Scroll += new System.Windows.Forms.ScrollEventHandler(this.grdMain_Scroll);
            this.grdMain.Paint += new System.Windows.Forms.PaintEventHandler(this.grdMain_Paint);
            this.grdMain.DoubleClick += new System.EventHandler(this.grdMain_DblClick);
            //
            // grdPrint
            //
            this.grdPrint.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdPrint.Location = new System.Drawing.Point(1029, 182);
            this.grdPrint.Margin = new System.Windows.Forms.Padding(4);
            this.grdPrint.Name = "grdPrint";
            this.grdPrint.RowHeadersWidth = 51;
            this.grdPrint.RowTemplate.Height = 23;
            this.grdPrint.Size = new System.Drawing.Size(33, 30);
            this.grdPrint.TabIndex = 8;
            this.grdPrint.Visible = false;
            //
            // grdSum
            //
            this.grdSum.AllowUserToAddRows = false;
            this.grdSum.AllowUserToDeleteRows = false;
            this.grdSum.BackgroundColor = System.Drawing.SystemColors.Control;
            this.grdSum.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.grdSum.Dock = System.Windows.Forms.DockStyle.Bottom;
            this.grdSum.Location = new System.Drawing.Point(0, 640);
            this.grdSum.Margin = new System.Windows.Forms.Padding(4);
            this.grdSum.Name = "grdSum";
            this.grdSum.ReadOnly = true;
            this.grdSum.RowHeadersWidth = 51;
            this.grdSum.RowTemplate.Height = 23;
            this.grdSum.ScrollBars = System.Windows.Forms.ScrollBars.None;
            this.grdSum.Size = new System.Drawing.Size(1661, 24);
            this.grdSum.TabIndex = 47;
            //
            // MES_StationOutBillList_Bad
            //
            this.AutoScaleDimensions = new System.Drawing.SizeF(8F, 15F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.ClientSize = new System.Drawing.Size(1661, 664);
            this.Controls.Add(this.grdMain);
            this.Controls.Add(this.grdSum);
            this.Controls.Add(this.pPic);
            this.Controls.Add(this.Tool);
            this.Controls.Add(this.grdPrint);
            this.Margin = new System.Windows.Forms.Padding(4);
            this.Name = "MES_StationOutBillList_Bad";
            this.Text = "工序汇报不良品列表";
            this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
            this.Load += new System.EventHandler(this.MES_StationOutBillList_Bad_Load);
            this.pPic.ResumeLayout(false);
            this.pPic.PerformLayout();
            this.panel1.ResumeLayout(false);
            this.panel1.PerformLayout();
            this.Tool.ResumeLayout(false);
            this.Tool.PerformLayout();
            ((System.ComponentModel.ISupportInitialize)(this.grdMain)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdPrint)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.grdSum)).EndInit();
            this.ResumeLayout(false);
        }
        #endregion
        private System.Windows.Forms.Panel pPic;
        private System.Windows.Forms.Label lblCaption;
        private System.Windows.Forms.ToolStrip Tool;
        private System.Windows.Forms.ToolStripButton yl;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator2;
        private System.Windows.Forms.ToolStripButton cx;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator1;
        private System.Windows.Forms.ToolStripButton tc;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator3;
        public System.Windows.Forms.Timer timer1;
        private System.Windows.Forms.ToolStripButton sx;
        private System.Windows.Forms.ToolStripButton dj;
        private System.Windows.Forms.ToolStripButton xz;
        private System.Windows.Forms.ToolStripButton sc;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator4;
        private System.Windows.Forms.Timer timer2;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator9;
        private System.Windows.Forms.ToolStripButton mrlk;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator7;
        private System.Windows.Forms.ToolStripButton bclk;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator8;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator5;
        private System.Windows.Forms.ToolStripButton sh;
        private System.Windows.Forms.ToolStripButton qsh;
        private System.Windows.Forms.DataGridView grdMain;
        private System.Windows.Forms.Panel panel1;
        private System.Windows.Forms.Label lbljl;
        private System.Windows.Forms.Label lbldj;
        private System.Windows.Forms.DataGridView grdPrint;
        private System.Windows.Forms.DataGridView grdSum;
        private System.Windows.Forms.ToolStripButton dc;
        private System.Windows.Forms.Label label1;
        private System.Windows.Forms.TextBox txtHBillNo;
        private System.Windows.Forms.Label label2;
        private System.Windows.Forms.TextBox txtHCenterID;
        private System.Windows.Forms.TextBox txtHOrderProcNO;
        private System.Windows.Forms.Label label3;
        private System.Windows.Forms.ToolStripSeparator toolStripSeparator6;
        private System.Windows.Forms.ToolStripButton bzd;
        private System.Windows.Forms.ToolStripDropDownButton toolStripDropDownButton1;
        private System.Windows.Forms.ToolStripMenuItem eXCELToolStripMenuItem;
        private System.Windows.Forms.ToolStripMenuItem cSVToolStripMenuItem;
        private System.Windows.Forms.ComboBox cmbHStatus;
        private System.Windows.Forms.Label label4;
    }
}
WorkM/Á÷ת¿¨¹ÜÀí/MES_StationOutBillList_Bad.resx
New file
Diff too large