班组职员清单

王 垚

2021-12-21 d0db3d916857cfade2b781217849de6d5ce49c1e

班组职员清单

 Pub_Class/CustomerCls/ClsXt_SystemParameter.cs

@@ -812,6 +812,11 @@
                        omodel.MES_StationEntrustOutBill_SaveAutoAddnew = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]);
                    }

                    //报工台，工序汇报自动审核参数
                    if (ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HKey"]) == "Sc_MESProceReportWorkBill_AutoCheck")
                    {
                        omodel.Sc_MESProceReportWorkBill_AutoCheck = ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HValue"]);
                    }
                }
                sReturn = "显示单据成功！";
                return true;

 Pub_Class/CustomerCls/ClsXt_SystemParameterMain.cs

@@ -221,6 +221,8 @@
        public string Sc_MaterToSourceBill_MouldLifeCtrlType;       //保存时器具寿命控制类型 ï¼ˆY å¼ºåˆ¶æŽ§åˆ¶ï¼Œ N ä»…提示）
        //异常反馈单
        public string OA_ErrMsgBackBill_AutoCheck;  //自动审核
        //报工台工序汇报
        public string Sc_MESProceReportWorkBill_AutoCheck; //自动审核

        //QMS


 WebAPI/Controllers/ProductInController.cs

@@ -469,6 +469,7 @@
            //string sSourceBillType = lsmain[0].HBillType;
            //BLL.ClsKf_ProductInBill bll = new BLL.ClsKf_ProductInBill();
            //return bll.set_SaveProductInBill_New(lsmain[0], sSourceBillType, ref DBUtility.ClsPub.sErrInfo);
            
            try
            {
                List<Model.ClsKf_ProductInBillMain> lsmain = new List<Model.ClsKf_ProductInBillMain>();

 WebAPI/Controllers/Éú²ú¹ÜÀí/±¨¹¤Ì¨¹¤Ðò/Sc_MESBeginStepWorkBillController.cs

@@ -597,15 +597,20 @@
        public static DataSet Sc_GetMESProductReportBillList(string sWhere)
        {
            string sql = string.Format(@"select a.HInterID, a.HBillNo,a.HDate,a.HBillType,a.HBillStatus,a.HMaterID,m.HNumber HMaterCode,m.HName HMaterName,m.HModel HMaterSpec 
                                   ,a.HSourceID,s.HNumber HSourceCode,s.HName HSourceName,a.HGroupID,g.HNumber HGroupCode,g.HName HGroupName
                                   ,a.HWorkManID,e.HName HWorkManName,a.HMaker,a.HMakeDate, a.HReportType  
                                   ,a.HQty,a.HICMOBillNo,a.HICMOInterID,a.HICMOEntryID 
                                   ,a.HSourceInterID,a.HSourceEntryID,a.HSourceBillNo, a.HSourceBillType
                                   from Sc_ICMOBillWorkQtyStatus_Tmp a 
                                   left join Gy_Material m on a.HMaterID=m.hitemid
                                   left join Gy_Source s on a.HSourceID=s.HItemID
                                   left join Gy_Group g on a.HGroupID=g.HItemID
                                   left join Gy_Employee e on a.HWorkManID=e.HItemID " + sWhere + " and HRelationInterID='0'");
                                         ,b.HSourceID,s.HNumber HSourceCode,s.HName HSourceName,a.HGroupID,g.HNumber HGroupCode,g.HName HGroupName
                                         ,b.HEmpID,b.HEmpNumber,e.HName HEmpName,a.HMaker,a.HMakeDate, '工序汇报' HReportType  
                                         ,b.HQty,a.HICMOBillNo,a.HICMOInterID,pr.HProcNo,b.HProcID,p.HNumber HProcNumber,p.HName HProcName
                                         ,b.HSourceInterID,b.HSourceEntryID,b.HSourceBillNo,b.HSourceBillType
                                         from Sc_ProcessReportMain a 
                                         inner join Sc_ProcessReportSub b on a.HInterID=B.HInterID
                                         inner join (select max(HProcNo) HProcNo,HBillNo,HProcID,HSourceInterID,HSourceEntryID,HSourceBillNo 
                                         from Sc_ProcessPlanSub group by HBillNo,HProcID,HSourceInterID,HSourceEntryID,HSourceBillNo) 
                                         pr on b.HSourceBillNo=pr.HSourceBillNo and b.HSourceInterID=pr.HSourceInterID and b.HSourceEntryID=pr.HSourceEntryID
                                         left join Gy_Process p on b.HProcID=p.HItemID
                                         left join Gy_Material m on a.HMaterID=m.hitemid
                                         left join Gy_Source s on b.HSourceID=s.HItemID
                                         left join Gy_Group g on a.HGroupID=g.HItemID
                                         left join Gy_Employee e on b.HEmpID=e.HItemID "+sWhere+"  and HRelationInterID='0'");
            return new SQLHelper.ClsCN().RunProcReturn(sql, "Sc_ICMOBillWorkQtyStatus_Tmp");
        }
        #endregion
@@ -622,7 +627,7 @@
        {
            try
            {
                ds = new SQLHelper.ClsCN().RunProcReturn("select isnull(sum(HQty),0) HQty,isnull(sum(HBadQty),0) HBadQty,isnull(sum(HWasterQty),0) HWasterQty   from Sc_ICMOBillWorkQtyStatus_Tmp with (nolock)" + sWhere, "Sc_ICMOBillWorkQtyStatus_Tmp");
                ds = new SQLHelper.ClsCN().RunProcReturn("select isnull(sum(HQty),0) HQty,isnull(sum(HBadQty),0) HBadQty,isnull(sum(HWasterQty),0) HWasterQty   from Sc_ProcessReportSub with (nolock)" + sWhere, "Sc_ProcessReportSub");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    objJsonResult.code = "1";
@@ -650,9 +655,9 @@
        }
        #endregion

        #region æŠ¥å·¥å¹³å°äº§é‡æ±‡æŠ¥ä¿å­˜/编辑
        #region æŠ¥å·¥å¹³å°å·¥åºæ±‡æŠ¥ä¿å­˜/编辑
        /// <summary>
        /// å¼€å·¥å•
        /// å·¥åºæ±‡æŠ¥æäº¤
        /// </summary>
        /// <param name="msg"></param>
        /// <returns></returns>
@@ -669,12 +674,12 @@
            ListModels oListModels = new ListModels();
            try
            {
                DLL.ClsSc_ICMOBillWorkQtyStatus_Tmp oBill = new DLL.ClsSc_ICMOBillWorkQtyStatus_Tmp();
                List<Models.ClsSc_ICMOBillWorkQtyStatus_Tmp> lsmain = new List<Models.ClsSc_ICMOBillWorkQtyStatus_Tmp>();
                DLL.ClsSc_ProcessReport oBill = new DLL.ClsSc_ProcessReport();
                List<Models.ClsSc_ProcessReportMain> lsmain = new List<Models.ClsSc_ProcessReportMain>();
                msg2 = msg2.Replace("\\", "");
                msg2 = msg2.Replace("\n", "");  //\n
                lsmain = oListModels.getObjectByJson_Gy_MESProductReportFrom(msg2);
                foreach (Models.ClsSc_ICMOBillWorkQtyStatus_Tmp oItem in lsmain)
                lsmain = oListModels.getObjectByJson_ProcessReportMain(msg2);
                foreach (Models.ClsSc_ProcessReportMain oItem in lsmain)
                {
                    if (refSav == "Add")
                    {
@@ -725,10 +730,11 @@
                        }
                    }

                    oItem.HBillType = "3724";
                    oItem.HBillSubType = "3724";
                    oItem.HReportType = 3;//（1条码扫描，2机器汇报，3手工录入）
                    oItem.HBillType = "3714";
                    oItem.HBillSubType = "3714";
                    oItem.HBillStatus = 1;   //单据状态（1未审，2审核通过，3关闭，4作废，5审核退回,6审核中,7已阅，8已回复，9结案，10验证,11下达，12开工,13申请审批,15申请检验，16 åˆ¤å®šåˆæ ¼ï¼Œ17判定不合格）     
                    oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
                    oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"));
                    if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "")
                    {
                        objJsonResult.code = "0";
@@ -738,6 +744,30 @@
                        return objJsonResult;
                    }
                    oBill.omodel = oItem;
                }
                //表体数据
                msg2 = msg2.Replace("\\", "");
                msg2 = msg2.Replace("\n", "");  //\n
                List<Models.ClsSc_ProcessReportSub> ls = new List<Models.ClsSc_ProcessReportSub>();
                ls = oListModels.getObjectByJson_ProcessReportSub(msg2);
                int i = 0;
                foreach (Models.ClsSc_ProcessReportSub oItemSub in ls)
                {

                    i++;
                    oItemSub.HEntryID = i;
                    //oItemSub.HCloseMan = "";       //行关闭
                    oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
                    oItemSub.HCloseType = false;   //关闭类型
                    //oItemSub.HRemark = "";         //备注
                    oItemSub.HRelationQty = 0;     //关联数量
                    //oItemSub.HRelationMoney = 0;   //关联金额
                    //oItemSub.HRepairID = 0;       //维修项目
                    //oItemSub.HRepairExplanation ="";   //维修要求
                    //oItemSub.HManagerID = 0;   //负责人ID
                    //oItemSub.HMoney = 0;        //维修费用
                    oBill.DetailColl.Add(oItemSub);

                }

                //保存
@@ -753,7 +783,7 @@
                        string sReturn = "";
                        if (oSystemParameter.ShowBill(ref sReturn) == true)
                        {
                            if (oSystemParameter.omodel.Sc_ICMOBillWorkQtyStatus_AutoCheck == "Y") //系统参数  è‡ªåŠ¨å®¡æ ¸ 
                            if (oSystemParameter.omodel.Sc_MESProceReportWorkBill_AutoCheck == "Y") //系统参数  è‡ªåŠ¨å®¡æ ¸ 
                            {
                                objJsonResult.Verify = "Y";
                            }
@@ -797,7 +827,7 @@
        }
        #endregion

        #region æŠ¥å·¥å¹³å°äº§é‡æ±‡æŠ¥å®¡æ ¸ã€åå®¡æ ¸
        #region æŠ¥å·¥å¹³å°å·¥åºæ±‡æŠ¥å®¡æ ¸ã€åå®¡æ ¸
        /// <summary>
        /// 
        /// </summary>
@@ -809,7 +839,7 @@
        [HttpGet]
        public object MESProductAuditProcessReportList(int HSourceID, int HSourceInterID, int HSourceEntryID, string HSourceBillNo, int HICMOInterID, int HICMOEntryID, int HInterID, int IsAudit, string CurUserName)
        {
            string ModRightNameCheck = "MES_ProcExchReport_Check";
            string ModRightNameCheck = "MES_ProductReport_Check";
            DBUtility.ClsPub.CurUserName = CurUserName;
            try
            {
@@ -833,7 +863,7 @@
                }
                Int64 lngBillKey = 0;
                lngBillKey = DBUtility.ClsPub.isLong(HInterID);
                DLL.ClsSc_ICMOBillWorkQtyStatus_Tmp oBill = new DLL.ClsSc_ICMOBillWorkQtyStatus_Tmp();
                DLL.ClsSc_ProcessReport oBill = new DLL.ClsSc_ProcessReport();
                //查看是否已审核,关闭,作废
                if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo))
                {
@@ -887,7 +917,7 @@
                if (IsAudit == 0) //审核提交
                {
                    //审核提交
                    if (oBill.CheckBill(HSourceID, HSourceInterID, HSourceEntryID, HSourceBillNo, HICMOInterID, HICMOEntryID, lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
                    if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
                    {
                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
@@ -907,7 +937,7 @@
                if (IsAudit == 1) //反审核提交
                {
                    //反审核提交AbandonCheck
                    if (oBill.AbandonCheck(HSourceID, HSourceInterID, HSourceEntryID, HSourceBillNo, HICMOInterID, HICMOEntryID, lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
                    if (oBill.AbandonCheck(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
                    {
                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
@@ -945,17 +975,11 @@
            try
            {
                oCN.BeginTran();
                //查询产量汇报临时表数量
                ds = oCN.RunProcReturn("select isnull(HQty,0) HQty,isnull(HWasterQty,0) HWasterQty,isnull(HBadQty,0) HBadQty  from Sc_ICMOBillWorkQtyStatus_Tmp where HInterID='" + HInterID + "' and HICMOInterID='" + HICMOInterID + "' and HICMOEntryID='" + HICMOEntryID + "'", "Sc_ICMOBillWorkQtyStatus_Tmp");
                double HQty = double.Parse(ds.Tables[0].Rows[0]["HQty"].ToString());
                double HWasterQty = double.Parse(ds.Tables[0].Rows[0]["HWasterQty"].ToString());
                double HBadQty = double.Parse(ds.Tables[0].Rows[0]["HBadQty"].ToString());
                double sumqty = HQty + HBadQty + HWasterQty;  //汇报数量+不良+报废
                //更新产量装量临时表已汇报数量
                string sql1 = string.Format(@"update Sc_ICMOBillStatus_Tmp  set  HICMOStatus='1',HFinishFlag='0', HRelationInterID=0,HSplitRelationQty=HSplitRelationQty-" + sumqty + ",HDateFinishQty=HDateFinishQty-" + sumqty + "   where  HICMOInterID='" + HICMOInterID + "' and HICMOEntryID='" + HICMOEntryID + "'");
                //删除工序汇报子表
                string sql1 = string.Format(@"delete Sc_ProcessReportSub  where HInterID='"+HInterID+"' and   HICMOInterID='" + HICMOInterID + "' and HICMOEntryID='" + HICMOEntryID + "'");
                oCN.RunProc(sql1);
                //更新切换状态值
                string sql = string.Format(@"delete Sc_ICMOBillWorkQtyStatus_Tmp  where HInterID='" + HInterID + "'");
                //删除工序汇报主表
                string sql = string.Format(@"delete Sc_ProcessReportMain  where HInterID='" + HInterID + "'");
                oCN.RunProc(sql);

                oCN.Commit();

 WebAPI/Controllers/Éú²ú¹ÜÀí/±¨¹¤Ì¨¹¤Ðò/Sc_MESProductReportStepBillController.cs

@@ -26,13 +26,13 @@
            {
                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp " + sWhere+ "order by å•æ®å· desc", "h_v_IF_ICMOBillWorkQtyStatus_Tmp");
                    ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillProcessWorkQty_Tmp " + sWhere+ "order by å•æ®å· desc", "h_v_IF_ICMOBillProcessWorkQty_Tmp");
                }
                else
                {
                    string sql1 = "select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp where 1 = 1 ";
                    string sql1 = "select * from h_v_IF_ICMOBillProcessWorkQty_Tmp where 1 = 1 ";
                    string sql = sql1 + sWhere+ " order by å•æ®å· desc";
                    ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillWorkQtyStatus_Tmp");
                    ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillProcessWorkQty_Tmp");
                }
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;
@@ -59,7 +59,7 @@
            try
            {
                //根据选择资源ID获取当前生产工单、责任人
                ds=oCN.RunProcReturn("select * from h_v_IF_ICMOBillWorkQtyStatus_Tmp  where HInterID='" + linterid + "' and HICMOInterID='" + HICMOInID + "' and HICMOEntryID='" + HICMOEnID + "'", "h_v_IF_ICMOBillWorkQtyStatus_Tmp");
                ds=oCN.RunProcReturn("select * from h_v_IF_ICMOBillProcessWorkQty_Tmp  where HInterID='" + linterid + "' and HICMOInterID='" + HICMOInID + "' and HICMOEntryID='" + HICMOEnID + "'", "h_v_IF_ICMOBillProcessWorkQty_Tmp");
                if (ds.Tables[0].Rows.Count > 0)
                {


 WebAPI/DLL/ClsSc_ProcessReport.cs

@@ -7,8 +7,8 @@
{
    public  class ClsSc_ProcessReport:DBUtility.ClsXt_BaseBill
    {
        public Model.ClsSc_ProcessReportMain omodel = new Model.ClsSc_ProcessReportMain();
        public List<Model.ClsSc_ProcessReportSub> DetailColl = new List<Model.ClsSc_ProcessReportSub>();
        public Models.ClsSc_ProcessReportMain omodel = new Models.ClsSc_ProcessReportMain();
        public List<Models.ClsSc_ProcessReportSub> DetailColl = new List<Models.ClsSc_ProcessReportSub>();

        public ClsSc_ProcessReport()
        {
@@ -71,7 +71,7 @@
                DeleteBillSub(lngBillKey);
                //插入子表
                omodel.HInterID = lngBillKey;
                foreach (Model.ClsSc_ProcessReportSub oSub in DetailColl)
                foreach (Models.ClsSc_ProcessReportSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Sc_ProcessReportSub " +
                  " (HInterID,HEntryID,HProcID,HProcNumber,HEmpID" +
@@ -143,7 +143,7 @@
                ",'" + omodel.HInnerBillNo  + "','" + omodel.HMaker.ToString() + "',getdate()," + omodel.HSupID.ToString() + ",'" + omodel.HMarker + "'" +
                ") ");
                //插入子表
                foreach (Model.ClsSc_ProcessReportSub oSub in DetailColl)
                foreach (Models.ClsSc_ProcessReportSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Sc_ProcessReportSub " +
                  " (HInterID,HEntryID,HProcID,HProcNumber,HEmpID" +
@@ -257,7 +257,7 @@
                DetailColl.Clear();//清空
                for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
                {
                    Model.ClsSc_ProcessReportSub oSub = new Model.ClsSc_ProcessReportSub();
                    Models.ClsSc_ProcessReportSub oSub = new Models.ClsSc_ProcessReportSub();
                    oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]);
                    oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]);
                    //
@@ -374,6 +374,41 @@
            }

        }
        //反审核
        public bool AbandonCheck(Int64 lngBillKey, ref string sReturn)
        {
            DataSet oDs = new DataSet();
            string sBillName = "";
            sReturn = "";
            try
            {
                string HChecker = DBUtility.ClsPub.CurUserName;
                string HCheckDate = DBUtility.ClsPub.GetServerDate(-1);
                //
                oDs = oCn.RunProcReturn("select * from Sc_ProcessReportSub where HInterID=" + lngBillKey.ToString(), "Sc_ProcessReportSub");
                if (oDs == null || oDs.Tables[0].Rows.Count == 0)
                {
                    return false;
                }
                for (int i = 0; i <= oDs.Tables[0].Rows.Count - 1; i++)
                {
                    long ProdMoveInterID = DBUtility.ClsPub.CreateBillID("3771", ref DBUtility.ClsPub.sExeReturnInfo);
                    string ProdMoveBillNo = DBUtility.ClsPub.CreateBillCode("3771", ref DBUtility.ClsPub.sExeReturnInfo, true);
                    //oCn.RunProc("exec h_p_Sc_ProcProdMoveBill_Add " + lngBillKey.ToString() + "," + DBUtility.ClsPub.isLong(oDs.Tables[0].Rows[i]["HEntryID"]).ToString() + "," + ProdMoveInterID.ToString() + ",'" + ProdMoveBillNo + "','" + HChecker + "'");
                    sBillName = sBillName + ProdMoveBillNo + ",";
                }
                oCn.RunProc(" Update " + MvarItemKey + " set HBillStatus='1',HChecker='',HCheckDate='' Where HInterID=" + lngBillKey.ToString());

                sReturn = sBillName;
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }  
        }


        //删除关联
        public override void DeleteRelation(ref string sReturn, Int64 lngBillKey)

 WebAPI/ListModels.cs

@@ -1903,7 +1903,6 @@
            return list;
        }
        #endregion

        #region ç­ç»„职员清单
        public List<Models.ClsGy_GroupEmpListMain> getObjectByJson_Gy_GroupEmpListMain(string jsonString)
        {
@@ -1918,5 +1917,31 @@
            return list;
        }
        #endregion

        /// <summary>
        /// æŠ¥å·¥å°å·¥åºæ±‡æŠ¥å•ä¸»è¡¨json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Models.ClsSc_ProcessReportMain> getObjectByJson_ProcessReportMain(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Models.ClsSc_ProcessReportMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSc_ProcessReportMain>>(jsonString);
            return list;
        }


        /// <summary>
        /// æŠ¥å·¥å°å·¥åºæ±‡æŠ¥å•å­è¡¨json
        /// </summary>
        /// <param name="jsonString"></param>
        /// <returns></returns>
        public List<Models.ClsSc_ProcessReportSub> getObjectByJson_ProcessReportSub(string jsonString)
        {
            jsonString = "[" + jsonString.ToString() + "]";
            List<Models.ClsSc_ProcessReportSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSc_ProcessReportSub>>(jsonString);
            return list;
        }
        
    }
} 

 WebAPI/Models/ClsSc_ProcessReportMain.cs

New file
@@ -0,0 +1,33 @@
using System;
using System.Collections.Generic;
using System.Text;

namespace WebAPI.Models
{
    public class ClsSc_ProcessReportMain:DBUtility.ClsXt_BaseBillMain
    {
        public string HBillSubType;//    varchar(50)        -- å­ç±»åž‹
        public Int64 HCheckItemNowID;// int     --当前审核项目（默认值 0）        ï¼ˆç•Œé¢ä¸æ˜¾ç¤ºï¼‰
        public Int64 HCheckItemNextID;// int --待审核项目（默认值 0）
        public Int64 HICMOInterID;//    int         --任务单ID            ï¼ˆç•Œé¢ä¸æ˜¾ç¤ºï¼‰
        public string HICMOBillNo;//     varchar(50)         --任务单号
        public Int64 HDeptID;//         int  --部门ID
        public string HDeptNumber;//    varchar(50)    --部门代码
        public Int64 HGroupID;//    int     --班组ID
        public string HGroupNumber;//    varchar(50)    --班组代码
        public Int64 HMaterID;//        int      --产品ID 
        public string HMaterNumber;//    varchar(100)    --产品代码
        public Int64 HUnitID;//        int        --单位ID
        public string HUnitNumber;//    varchar(100)    --单位代码
        public double HPlanQty;//        dec(18,8)         --计划数量
        public double HInStockQty;//      dec(18,8)           --入库数量
        public Single HSumTimes;//       money         --总工作时间
        public string HExplanation;//    varchar(500)   --ÕªÒª
        public string HInnerBillNo;//    varchar(50)   --内部单据号
        public bool HCloseType;//      bit          --关闭类型
        public Int64 HSupID;        //供应商
        public string HMarker;  //检验人

        public Int64 HICMOStatusInterID;//生产状态表内码
    }
}

 WebAPI/Models/ClsSc_ProcessReportSub.cs

New file
@@ -0,0 +1,69 @@
using System;
using System.Collections.Generic;
using System.Text;

namespace WebAPI.Models
{
    public class ClsSc_ProcessReportSub:DBUtility.ClsXt_BaseBillSub
    {
        public Int64 HMaterID;//        int        --物料
        public string HMaterNumber;//    varchar(50)    --物料代码
        public Int64 HProcID;//        int        --工序
        public string HProcNumber;//    varchar(50)    --工序代码
        public Int64 HEmpID;//        int        --操作工
        public string HEmpNumber;//    varchar(50)    --操作工代码
        public Int64 HSourceID;//    int        --生产资源ID
        public DateTime HRelBeginDate;//    datetime    --实际开工日期
        public DateTime HRelEndDate;//    datetime    --实际完工日期
        public Single HTimes;//          money         --实作时间
        public double HQty;//             dec(18,8)         --实作数量
        public double HCheckQty;//    dec(18,8)    --合格数量
        public Single HBadCount;//        money           --不良品数
        public Single HWasterQty;//        money          --因工报废数量 
        public Single HWasterQty2;//        money          --因料报废数量 
        public double HPrice;//          dec(18,8)    --工序工价
        public Single HMoney;//         money      -- è®¡ä»¶é‡‘额

        public Single HBadPrirce;//         money      -- ä¸è‰¯å•ä»·
        public Single HBadMoney;//         money      -- ä¸è‰¯é‡‘额
        public Single HWasterPrice;//         money      -- æŠ¥åºŸå•ä»·
        public Single HWasterMoney;//         money      -- æŠ¥åºŸé‡‘额
        public Single HQualityRate;//         money      -- è´¨é‡ç³»æ•°
        public Single HOutPrice;    //加工单价
        public Single HOutMoney;    //加工费金额
        public Single HWeight;      //加工重量

        public double HSecUnitQty1;//         dec(18,8)      -- è¾…助单位数量1
        public Single HSecUnitRate1;//         money      -- æ¢ç®—率1
        public double HSecUnitQty2;//         dec(18,8)      -- è¾…助单位数量2
        public Single HSecUnitRate2;//         money      -- æ¢ç®—率2
        public Single HUsingQty;//         money      -- è®©æ­¥æ•°é‡
        public Single HSelfBadCount;//         money      -- æœ¬é“返工
        public Single HPreBadCount;//         money      -- å‰é“不良数

        public Single HPayMentQty;//         money      -- ç»“算数量
        public Single HOtherDeduct;//         money      -- å…¶ä»–扣款（油石费
        public Single HRelPay;//         money      -- å®žå¾—工资

        public string HOtherItem1;//     varchar(50)        --其他属性1（游隙）
        public string HOtherItem2;//     varchar(50)        --其他属性2（盖子）
        public string HOtherItem3;//     varchar(50)        --其他属性3（油脂）
        public string HOtherItem4;//     varchar(50)        --其他属性4（级别）
        public string HOtherItem5;//     varchar(50)        --其他属性5	
        public string HPackType;//     varchar(50)        --包装类型

        public Int64 HCheckEmpID;//        int        --检验员
        public string HCheckEmpNumber;//    varchar(50)    --检验员代码

        public Int64 HProcPlanInterID;// int        --工序计划单ID
        public Int64 HProcPlanEntryID;//    int     --工序计划单子ID
        public string HProcPlanBillNo;//    varchar(50)      --工序计划单号
        public Int64 HICMOInterID;//    int         --任务单ID
        public string HICMOBillNo;//     varchar(50)         --任务单号
        public Int64 HSeOrderInterID;//  int                 --销售订单主ID
        public Int64 HSeOrderEntryID;// int                  --销售子ID
        public string HSeOrderBillNo;//     varchar(50)        --销售订单号
        public string HRemark;//                 --备注 
        public string HBatchNo;
    }
}

 WebAPI/WebAPI.csproj

@@ -460,6 +460,8 @@
    <Compile Include="Models\ClsGy_StockCheckItemBill.cs" />
    <Compile Include="Models\ClsSc_PackUnionBillMain.cs" />
    <Compile Include="Models\ClsSc_PackUnionBillSub.cs" />
    <Compile Include="Models\ClsSc_ProcessReportMain.cs" />
    <Compile Include="Models\ClsSc_ProcessReportSub.cs" />
    <Compile Include="Models\GetWeekList.cs" />
    <Compile Include="Models\jsonScanline.cs" />
    <Compile Include="Models\ScanLineCode.cs" />