染厂产量报表：增加客户字段、根据用户关联客户进行过滤

duhe

2024-05-28 037a4dd8af9fa2ff1955e56e811ae66348076fec

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
using System;
using System.Collections.Generic;
using System.Text;
 
namespace Model
{
    public class ClsSc_ICMOBillQualityStatus_Tmp
    {
        //Éú²úÖÊÁ¿×´Ì¬ÁÙʱ±í
 
        public Int64 HInterID;//     int        //Ö÷±í 
        public Int64 HReportEntryID;//    int    //»ã±¨µ¥×Ó±íID
        public Int64 HEntryID;//  int    //×ÔÔöÁÐ
        public string HBillType;//    varchar(10)    // µ¥¾ÝÀàÐÍ
        public string HSplitNO;       //Åɹ¤µ¥ºÅ
 
        public Int64 HSourceID;//    int    //Éú²ú×ÊÔ´ID    New
        public Int64 HReportType    ;//int    //»ã±¨ÀàÐÍ£¨1ÌõÂëɨÃ裬2»úÆ÷»ã±¨£¬3ÊÖ¹¤Â¼È룩
        public Int64 HBadReasonID;//    int    //²»Á¼Ô­Òò
        public Int64 HWasterReasonID    ;//int     //±¨·ÏÔ­Òò
        public string HBarCode;// varchar(50)    //ÌõÐÎÂë
        public string HAddr;//        varchar(20)    //»úÆ÷µØÖ·
        public string HMaker;//    varchar(50)    //¼Ç¼ÈË
        public DateTime HMakeDate;//    datetime    //¼Ç¼ÈÕÆÚ£¨yyyy-MM-dd hh:mm:ss£©
 
        public Int64 HSourceInterID;//     int    //(Éú²ú״̬±íID)
        public Int64 HSourceEntryID;//    int    //£¨Éú²ú״̬ÌõÂë±íID£©
        public string HSourceBillNo;//    varchar(50)    //¡®¡¯
        public string HSourceBillType;// varchar(10)    // 
        public Int64 HRelationInterID;//    int    //¹ØÁªµ¥ID
        public Int64 HRelationEntryID;//    int    //¹ØÁªµ¥×ÓID
        public string HRelationBillNo;//    varchar(50)    //¹ØÁªµ¥ºÅ
 
        public string HBillNo;              //µ¥¾ÝºÅ
        public Int64 HCheckManID;           //ÖʼìÈË
        public string HResult;              //ÅжϽá¹û
        public string HRemark;              //±¸×¢
        public string HSaveType;            //±£´æÀàÐÍ ²»Á¼Æ·±£´æ£¬±¨·ÏÆ·±£´æ
 
        public Int64 HICMOInterID;          //Éú²ú¶©µ¥Ö÷ÄÚÂë
        public Int64 HICMOEntryID;          //Éú²ú¶©µ¥×ÓÄÚÂë
        public string HICMOBillNo;          //Éú²ú¶©µ¥ºÅ
        public Int64 HMaterID;              //²úÆ·ÄÚÂë
        public Int64 HProcID;               //¹¤ÐòÄÚÂë
        public string HDate;                //ÖƵ¥ÈÕÆÚ
        public Int64 HGroupID;              //°à×éÄÚÂë
        public Int64 HDeptID;               //²¿ÃÅÄÚÂë
        public Int64 HStationID;            //¹¤Î»ÄÚÂë
        public Int64 HPRDORGID;             //Éú²ú×éÖ¯ÄÚÂë
        public Int64 HAuxPropID;            //¸¨ÖúÊôÐÔÄÚÂë
 
        public Int64 HBadResultID;          //²»Á¼½á¹û
        public Int64 HBadTypeID;            //²»Á¼ÀàÐÍ
        public Int64 HMTONo;                //¼Æ»®¸ú×ÙºÅ
        public Int64 HOTHERORGID;           //ÆäËü×éÖ¯(Ô¤Áô)
        public Int64 HOWNERID;              //»õÖ÷
        public Int64 HOWNERTYPEID;          //»õÖ÷ÀàÐÍ
 
        public Int64 HProcExchInterID;      //¹¤ÐòÁ÷ת¿¨ÄÚÂë
        public Int64 HProcExchEntryID;      //¹¤ÐòÁ÷ת¿¨×ÓÄÚÂë
        public string HProcExchBillNo;      //¹¤ÐòÁ÷ת¿¨ºÅ
 
        public Int64 HQualityReportEntryID; //ÖÊÁ¿»ã±¨µ¥×Ó±íID
 
        public string HChecker;      //ÉóºËÈË
        public string HCheckDate;   //ÉóºËÈÕÆÚ
        public string HUpDater;//ÐÞ¸ÄÈË
        public string HUpDateDate; //ÐÞ¸ÄÈÕÆÚ
        public string HCloseMan; //¹Ø±ÕÈË
        public string HCloseDate;//¹Ø±ÕÈÕÆÚ
        public bool HCloseType;   //¹Ø±ÕÀàÐÍ
        public string HDeleteMan;// ×÷·ÏÈË
        public string HDeleteDate; //×÷·ÏÈÕÆÚ
        //
    }
}