Esempi in C# (CSharp) per OcrCnt.T_OCR_CNTRow

Esempio n. 1

/*
 *      /// <summary>
 *      /// 确认卸船
 *      /// </summary>
 *      /// <param name="VELALIASE"></param>
 *      /// <param name="DEVICEOPTIMELINESID"></param>
 *      /// <param name="TICKET_ID"></param>
 *      /// <param name="WORKITEMNO"></param>
 *      /// <param name="TYPE"></param>
 *      /// <param name="STATUS"></param>
 *      /// <param name="USER_ID"></param>
 *      /// <param name="QCDRIVER"></param>
 *      /// <param name="QCNO"></param>
 *      /// <param name="CONTAINERNO"></param>
 *      /// <param name="CONTAINERID"></param>
 *      /// <param name="MAINCONTAINERNO"></param>
 *      /// <param name="BINDSEQUENCE"></param>
 *      /// <param name="ISSHORE"></param>
 *      /// <param name="ISOVERDIS"></param>
 *      /// <param name="ISFORCE"></param>
 *      /// <param name="CONTRACTORCODE"></param>
 *      /// <param name="BERTHNO"></param>
 *      /// <param name="EMPTYFULL"></param>
 *      /// <param name="ISOCODE"></param>
 *      /// <param name="TRUCKNO"></param>
 *      /// <param name="POSONTRUCK"></param>
 *      /// <param name="TARGET"></param>
 *      /// <param name="ISDEALFAILTODECK"></param>
 *      /// <param name="SEALL"></param>
 *      /// <param name="SEALC"></param>
 *      /// <param name="DAM"></param>
 *      /// <param name="QS"></param>
 *      /// <param name="IMDG1"></param>
 *      /// <param name="IMDGSUM1"></param>
 *      /// <param name="IMDG2"></param>
 *      /// <param name="IMDGSUM2"></param>
 *      /// <param name="IMDG3"></param>
 *      /// <param name="IMDGSUM3"></param>
 *      /// <param name="ISBAND"></param>
 *      /// <param name="SETTEMP"></param>
 *      /// <param name="OH"></param>
 *      /// <param name="OA"></param>
 *      /// <param name="OF"></param>
 *      /// <param name="OL"></param>
 *      /// <param name="OR"></param>
 *      /// <param name="DOOR"></param>
 *      /// <returns></returns>
 *      public static CtosResult OP007037(string VELALIASE, string DEVICEOPTIMELINESID, string TICKET_ID, string WORKITEMNO, string TYPE, string STATUS,
 *          string USER_ID, string QCDRIVER, string QCNO, string CONTAINERNO, string CONTAINERID, string MAINCONTAINERNO,
 *          string BINDSEQUENCE, string ISSHORE, string ISOVERDIS, string ISFORCE,
 *          string CONTRACTORCODE, string BERTHNO, string EMPTYFULL, string ISOCODE, string TRUCKNO, string POSONTRUCK,
 *          string TARGET, string ISDEALFAILTODECK, string SEALL, string SEALC, string DAM, string QS,
 *          string IMDG1, string IMDGSUM1, string IMDG2, string IMDGSUM2, string IMDG3, string IMDGSUM3,
 *          string ISBAND, string SETTEMP, string OH, string OA, string OF, string OL, string OR, string DOOR)
 *      {
 *          CtosWebRef82.WSVCDataAccess api = new OCR.BLL.CtosWebRef82.WSVCDataAccess();
 *          StringBuilder tableparms = new StringBuilder();
 *
 *          tableparms.Append(@"WI_WORKITEM

BERTHNO:STRING
BINDSEQUENCE:STRING
CONTAINERID:STRING
CONTAINERNO:STRING
CONTRACTORCODE:STRING
DAM:STRING
DOOR:STRING
EMPTYFULL:STRING
IMDG1:STRING
IMDG2:STRING
IMDG3:STRING
IMDGSUM1:STRING
IMDGSUM2:STRING
IMDGSUM3:STRING
ISBAND:STRING
ISDEALFAILTODECK:STRING
ISFORCE:STRING
ISOCODE:STRING
ISOVERDIS:STRING
ISSHORE:STRING
MAINCONTAINERNO:STRING
OA:STRING
OF:STRING
OH:STRING
OL:STRING
OR:STRING
OVER_FIELD:STRING
OVER_VALUE:STRING
POSONTRUCK:STRING
QCDRIVER:STRING
QCNO:STRING
QS:STRING
SEALC:STRING
SEALL:STRING
SETTEMP:STRING
STATUS:STRING
TARGET:STRING
TRUCKNO:STRING
TYPE:STRING
USER_ID:STRING
WORKITEMNO:STRING");
 *
 *          tableparms.AppendFormat(@"{0}
{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}",
 *              BERTHNO,BINDSEQUENCE,CONTAINERID,CONTAINERNO,CONTRACTORCODE,DAM,DOOR,EMPTYFULL,IMDG1,IMDG2,IMDG3,IMDGSUM1,IMDGSUM2,IMDGSUM3,
 *              ISBAND,ISDEALFAILTODECK,ISFORCE,ISOCODE,ISOVERDIS,ISSHORE,MAINCONTAINERNO,OA,OF,OH,OL,OR,string.Empty,string.Empty,POSONTRUCK,
 *              QCDRIVER,QCNO,QS,SEALC,SEALL,SETTEMP,STATUS,TARGET,TRUCKNO,TYPE,USER_ID,WORKITEMNO);
 *          tableparms.Append(@"");
 *
 *          string parmsBase64 = EncodeBase64(Encoding.UTF8, tableparms.ToString());
 *
 *          string SESSIONGUID = DateTime.Now.ToString("yyyyMMddHHmmssfff");
 *          string parms = string.Format(@"DEVICEOPTIMELINESID:'{0}',SESSIONGUID:'{1}',TABLEPARAMS:'{2}',VELALIASE:'{3}',",
 *              DEVICEOPTIMELINESID, SESSIONGUID, parmsBase64, VELALIASE);
 *          string parms2Base64 = EncodeBase64(Encoding.UTF8, parms);
 *
 *          byte[] bytes = api.ExecBiz("OP007037", parms2Base64, TICKET_ID);
 *          string rs = Encoding.UTF8.GetString(bytes);
 *
 *          return ParseCtos(rs);
 *
 *      }
 *
 *      /// <summary>
 *      /// 确认卸船
 *      /// </summary>
 *      /// <param name="VELALIASE"></param>
 *      /// <param name="DEVICEOPTIMELINESID"></param>
 *      /// <param name="TICKET_ID"></param>
 *      /// <param name="WORKITEMNO"></param>
 *      /// <param name="TYPE"></param>
 *      /// <param name="STATUS"></param>
 *      /// <param name="USER_ID"></param>
 *      /// <param name="QCDRIVER"></param>
 *      /// <param name="QCNO"></param>
 *      /// <param name="CONTAINERNO"></param>
 *      /// <param name="CONTAINERID"></param>
 *      /// <param name="MAINCONTAINERNO"></param>
 *      /// <param name="BINDSEQUENCE"></param>
 *      /// <param name="ISSHORE"></param>
 *      /// <param name="ISOVERDIS"></param>
 *      /// <param name="ISFORCE"></param>
 *      /// <param name="CONTRACTORCODE"></param>
 *      /// <param name="BERTHNO"></param>
 *      /// <param name="EMPTYFULL"></param>
 *      /// <param name="ISOCODE"></param>
 *      /// <param name="TRUCKNO"></param>
 *      /// <param name="POSONTRUCK"></param>
 *      /// <param name="TARGET"></param>
 *      /// <param name="ISDEALFAILTODECK"></param>
 *      /// <param name="SEALL"></param>
 *      /// <param name="SEALC"></param>
 *      /// <param name="DAM"></param>
 *      /// <param name="QS"></param>
 *      /// <param name="IMDG1"></param>
 *      /// <param name="IMDGSUM1"></param>
 *      /// <param name="IMDG2"></param>
 *      /// <param name="IMDGSUM2"></param>
 *      /// <param name="IMDG3"></param>
 *      /// <param name="IMDGSUM3"></param>
 *      /// <param name="ISBAND"></param>
 *      /// <param name="SETTEMP"></param>
 *      /// <param name="OH"></param>
 *      /// <param name="OA"></param>
 *      /// <param name="OF"></param>
 *      /// <param name="OL"></param>
 *      /// <param name="OR"></param>
 *      /// <param name="DOOR"></param>
 *      /// <returns></returns>
 *      public static CtosResult OP007037B(string VELALIASE, string DEVICEOPTIMELINESID, string TICKET_ID, string WORKITEMNO, string TYPE, string STATUS,
 *          string USER_ID, string QCDRIVER, string QCNO, string CONTAINERNO, string CONTAINERID, string MAINCONTAINERNO,
 *          string BINDSEQUENCE, string ISSHORE, string ISOVERDIS, string ISFORCE,
 *          string CONTRACTORCODE, string BERTHNO, string EMPTYFULL, string ISOCODE, string TRUCKNO, string POSONTRUCK,
 *          string TARGET, string ISDEALFAILTODECK, string SEALL, string SEALC, string DAM, string QS,
 *          string IMDG1, string IMDGSUM1, string IMDG2, string IMDGSUM2, string IMDG3, string IMDGSUM3,
 *          string ISBAND, string SETTEMP, string OH, string OA, string OF, string OL, string OR, string DOOR)
 *      {
 *          CtosWebReference.Service api = new OCR.BLL.CtosWebReference.Service();
 *          StringBuilder tableparms = new StringBuilder();
 *
 *          tableparms.Append(@"WI_WORKITEM

BERTHNO:STRING
BINDSEQUENCE:STRING
CONTAINERID:STRING
CONTAINERNO:STRING
CONTRACTORCODE:STRING
DAM:STRING
DOOR:STRING
EMPTYFULL:STRING
IMDG1:STRING
IMDG2:STRING
IMDG3:STRING
IMDGSUM1:STRING
IMDGSUM2:STRING
IMDGSUM3:STRING
ISBAND:STRING
ISDEALFAILTODECK:STRING
ISFORCE:STRING
ISOCODE:STRING
ISOVERDIS:STRING
ISSHORE:STRING
MAINCONTAINERNO:STRING
OA:STRING
OF:STRING
OH:STRING
OL:STRING
OR:STRING
POSONTRUCK:STRING
QCDRIVER:STRING
QCNO:STRING
QS:STRING
SEALC:STRING
SEALL:STRING
SETTEMP:STRING
STATUS:STRING
TARGET:STRING
TRUCKNO:STRING
TYPE:STRING
USER_ID:STRING
WORKITEMNO:STRING");
 *
 *          tableparms.AppendFormat(@"{0}
{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}",
 *              BERTHNO, BINDSEQUENCE, CONTAINERID, CONTAINERNO, CONTRACTORCODE, DAM, DOOR, EMPTYFULL, IMDG1, IMDG2, IMDG3, IMDGSUM1, IMDGSUM2, IMDGSUM3,
 *              ISBAND, ISDEALFAILTODECK, ISFORCE, ISOCODE, ISOVERDIS, ISSHORE, MAINCONTAINERNO, OA, OF, OH, OL, OR, POSONTRUCK,
 *              QCDRIVER, QCNO, QS, SEALC, SEALL, SETTEMP, STATUS, TARGET, TRUCKNO, TYPE, USER_ID, WORKITEMNO);
 *
 *  //        tableparms.AppendFormat(@"{0}
{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}",
 *  //BERTHNO, BINDSEQUENCE, "5823865229661", "ABCU1111132", CONTRACTORCODE, DAM, DOOR, EMPTYFULL, IMDG1, IMDG2, IMDG3, IMDGSUM1, IMDGSUM2, IMDGSUM3,
 *  //ISBAND, ISDEALFAILTODECK, ISFORCE, ISOCODE, ISOVERDIS, ISSHORE, MAINCONTAINERNO, OA, OF, OH, OL, OR, "1A",
 *  //QCDRIVER, QCNO, QS, SEALC, SEALL, SETTEMP, STATUS, TARGET, TRUCKNO, TYPE, USER_ID, "5823865229726");
 *
 *          tableparms.Append(@"");
 *
 *          string parmsBase64 = EncodeBase64(Encoding.UTF8, tableparms.ToString());
 *
 *          string parms = string.Format(@"VELALIASE:'{0}',DEVICEOPTIMELINESID:'{1}',TABLEPARAMS:'{2}',TICKET_ID:'{3}'",
 *              VELALIASE, DEVICEOPTIMELINESID, parmsBase64, TICKET_ID);
 *
 *          string rs = api.OP007037(parms);
 *
 *          return XMLParse(rs, new string[] { "OP007037" }, false);
 *      }
 *
 */
        public static CtosResult OP007037C(string VELALIASE, string DEVICEOPTIMELINESID, string TICKET_ID, string USER_ID, string QCDRIVER, string QCNO,
                                           string CONTRACTORCODE, string BERTHNO, string MAINCONTAINERNO, OcrCnt.T_OCR_CNTRow row1, OcrCnt.T_OCR_CNTRow row2)
        {
            CtosWebReference.Service api        = new OCR.BLL.CtosWebReference.Service();
            StringBuilder            tableparms = new StringBuilder();

            tableparms.Append(@"WI_WORKITEM

BERTHNO:STRING
BINDSEQUENCE:STRING
CONTAINERID:STRING
CONTAINERNO:STRING
CONTRACTORCODE:STRING
DAM:STRING
DOOR:STRING
EMPTYFULL:STRING
IMDG1:STRING
IMDG2:STRING
IMDG3:STRING
IMDGSUM1:STRING
IMDGSUM2:STRING
IMDGSUM3:STRING
ISBAND:STRING
ISDEALFAILTODECK:STRING
ISFORCE:STRING
ISOCODE:STRING
ISOVERDIS:STRING
ISSHORE:STRING
MAINCONTAINERNO:STRING
OA:STRING
OF:STRING
OH:STRING
OL:STRING
OR:STRING
POSONTRUCK:STRING
QCDRIVER:STRING
QCNO:STRING
QS:STRING
SEALC:STRING
SEALL:STRING
SETTEMP:STRING
STATUS:STRING
TARGET:STRING
TRUCKNO:STRING
TYPE:STRING
USER_ID:STRING
WORKITEMNO:STRING");

            tableparms.AppendFormat(@"{0}
{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}",
                                    BERTHNO, row1.BNDL, row1.CONTAINERID, row1.cntNo, CONTRACTORCODE, row1.Dmg, row1.door, row1.emptyFull, row1.Imdg1, row1.Imdg2, row1.Imdg3, row1.ImdgNum1, row1.ImdgNum2, row1.ImdgNum3,
                                    row1.ISBIND, "Y", "N", row1.iso, row1.overDis, row1.isShore, MAINCONTAINERNO, row1.OA, row1.OF, row1.OH, row1.OL, row1.OR, row1.positionTruck,
                                    QCDRIVER, QCNO, row1.QS, row1.CIQSEALNO, row1.VESSELCOMPANYSEALNO, row1.SETUPTEMP, row1.WORKITEMSTATUS, row1.TARGET, row1.truckno, "C", USER_ID, row1.WORKITEMNO);

            if (row2 != null)
            {
                tableparms.AppendFormat(@"{0}
{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}",
                                        BERTHNO, row2.BNDL, row2.CONTAINERID, row2.cntNo, CONTRACTORCODE, row2.Dmg, row2.door, row2.emptyFull, row2.Imdg1, row2.Imdg2, row2.Imdg3, row2.ImdgNum1, row2.ImdgNum2, row2.ImdgNum3,
                                        row2.ISBIND, "Y", "N", row2.iso, row2.overDis, row2.isShore, MAINCONTAINERNO, row2.OA, row2.OF, row2.OH, row2.OL, row2.OR, row2.positionTruck,
                                        QCDRIVER, QCNO, row2.QS, row2.CIQSEALNO, row2.VESSELCOMPANYSEALNO, row2.SETUPTEMP, row2.WORKITEMSTATUS, row2.TARGET, row2.truckno, "C", USER_ID, row2.WORKITEMNO);
            }


            //        tableparms.AppendFormat(@"{0}
{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}",
            //BERTHNO, BINDSEQUENCE, "5823865229661", "ABCU1111132", CONTRACTORCODE, DAM, DOOR, EMPTYFULL, IMDG1, IMDG2, IMDG3, IMDGSUM1, IMDGSUM2, IMDGSUM3,
            //ISBAND, ISDEALFAILTODECK, ISFORCE, ISOCODE, ISOVERDIS, ISSHORE, MAINCONTAINERNO, OA, OF, OH, OL, OR, "1A",
            //QCDRIVER, QCNO, QS, SEALC, SEALL, SETTEMP, STATUS, TARGET, TRUCKNO, TYPE, USER_ID, "5823865229726");

            tableparms.Append(@"");

            string parmsBase64 = EncodeBase64(Encoding.UTF8, tableparms.ToString());

            string parms = string.Format(@"VELALIASE:'{0}',TWINLIFT:'{1}',DEVICEOPTIMELINESID:'{2}',TABLEPARAMS:'{3}',TICKET_ID:'{4}'",
                                         VELALIASE, row1.CTYPE == 1 ? "Y" : "N", DEVICEOPTIMELINESID, parmsBase64, TICKET_ID);

            string rs = api.OP007037(parms);

            return(XMLParse(rs, new string[] { "OP007037" }, false));
        }

Esempio n. 2

 /// <summary>
 /// 更新识别记录处理结果
 /// </summary>
 /// <param name="row"></param>
 public void UpdateCntStatus(OcrCnt.T_OCR_CNTRow row)
 {
     DAL.cctdbDAL.UpdateCntStatus(row);
 }

Esempio n. 3

 /// <summary>
 /// 更新识别记录move id
 /// </summary>
 /// <param name="row"></param>
 public void UpdateMoveId(OcrCnt.T_OCR_CNTRow row)
 {
     DAL.cctdbDAL.UpdateMoveId(row);
 }

Esempio n. 4

File: cctdbDAL.cs Progetto: ZPMAI/OCR_WebAPI

 /// <summary>
 /// 更新识别记录move id
 /// </summary>
 /// <param name="row"></param>
 public static void UpdateMoveId(OcrCnt.T_OCR_CNTRow row)
 {
     SqlHelper.Oracle.ExecuteObjectTypedParams(Config.ConnectionString, "OCR.pkg_ocr.p_update_moveid", CommandType.StoredProcedure, row);
 }