예제 #1
0
파일: SendMessage.cs 프로젝트: 4bb/Bao
        public static void UpdateSendMessages(string sID)
        {
            string sql = @"DECLARE RS VARCHAR2(20);BEGIN RS:=SSICT_MSGFLAGUPDATE_F(:sID); END;";

            OracleParameter[] para = new OracleParameter[1];
            para[0] = new OracleParameter("sID", Int64.Parse(sID));

            OracleDataTool.ExecuteNonQuery(ConnectStringOracle.GetInternalTableConnection(), sql, para);
        }
예제 #2
0
        public static DataTable GetOnBerths()
        {
            string sql = @"SELECT   VESSELNAME,VESSELTYPE,VOCOPTM ,AMOUNTOFVESSEL ,TARGETVOCTM 
                            FROM  SSICT_APP_ONBERTH_EFF";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #3
0
파일: SendMessage.cs 프로젝트: 4bb/Bao
        public static DataTable GetSendMessages()
        {
            string sql = @"SELECT  ID, JobNo, SENDMESSAGE, SENDTIME, ERRORTIME, ISSEND, MECHANICALNO, FAULTSTATUS,BEGINTIME,FINISHTIME 
                            FROM SSICT_SENDMSG_VW  Order By ISSEND desc ,BEGINTIME desc";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #4
0
파일: VesselEfficiency.cs 프로젝트: 4bb/Bao
        public static DataTable GetVesselEfficiencys()
        {
            string sql = @"SELECT  REPORT_DATE, VSL_CNNAME,QCOPTM ,QCNETTM ,AVGEFF ,ABTHNO                 
                            FROM  SSICT_APP_VESSEL_EFF ";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #5
0
        public static DataTable GetTwinLifts()
        {
            string sql = @"SELECT SCD_ID ,VESSELNAME ,IEFG ,TOTALCNT ,CANSTGOPTCNT  ,CANSTGOPTRATE ,STORAGECNT ,STORAGERATE ,OPERATECNT ,OPERATERATE, EFFICIENCY  ,REPORTDATE   
                            FROM  SSICT_DAILYREPORT_TWINLIFT ";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #6
0
파일: ThreeShift.cs 프로젝트: 4bb/Bao
        public static DataTable GetThreeShifts()
        {
            string sql = @"SELECT  SHIFTDATE, SHIFT, SHIFTPLAN, SHIFTACTUAL, round(SHIFTCOMPLETERATE,5) 
                            FROM  SSICT_APP_THREESHIFT_VW";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #7
0
파일: OperatePlan.cs 프로젝트: 4bb/Bao
        public static DataTable GetOperatePlans()
        {
            string sql = @"SELECT    SHIFT_DATE ,SHIFT ,TEAMNAME ,OP_ROUTE ,QB ,HG ,FZ , OTHER ,SHIFT_NUM ,ATD_DIFF   
                            FROM SSICT_APP_OPERATEPLAN";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #8
0
        public static DataTable GetInternalUsers()
        {
            string sql = @"SELECT SUR_USERACCOUNT ,SUR_PASSWORD ,SUR_DISPLAYNAME ,SUR_DESCRIPTION ,SUR_CREATETIME , SUR_UPDATETIME ,SUR_GROUP ,SUR_STATUS ,SUR_ERRORCOUNT ,SUR_ISLOOKED
                            FROM SYS_USER";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #9
0
파일: VesselDepart.cs 프로젝트: 4bb/Bao
        public static DataTable GetVesselDeparts()
        {
            string sql = @"SELECT REPORT_DATE ,VSL_CNNAME  ,VBT_PDPTDT ,VBT_ADPTDT ,VBT_STATUS ,ISLATER ,VOT_AWKENTM ,WKLATER   
                            FROM  SSICT_DAILYREPORT_DEPART_VW";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #10
0
파일: TruckStatus.cs 프로젝트: 4bb/Bao
        public static DataTable GetTruckStatus()
        {
            string sql = @"SELECT    TRUCKNO ,COMPLETETRUCKNUM ,AVEPERIOD ,CURRENTINSTRUCTION ,TOLOC1,TOLOC2,STATUS,STOPFG
                            FROM  SSICT_APP_TRUCKSTATUS";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return null;
            }
            else
            {
                return ds.Tables[0];
            }
        }
예제 #11
0
파일: VesselBerth.cs 프로젝트: 4bb/Bao
        public static DataTable GetVesselBerths()
        {
            string sql = @"SELECT  REPORT_DATE,VSL_CNNAME,VBT_PBTHDT,VBT_ABTHDT, VBT_STATUS, VOT_AWKSTTM,  ISLATER
                            FROM  SSICT_DAILYREPORT_BERTH_VW ";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #12
0
        public static DataTable GetYardDensitys()
        {
            string sql = @"SELECT YD_ID ,YD_CNTR_STATUS ,YD_SAC_SUM ,YD_YARD_SLOT_SUM ,YD_YARD_SLOT_TOTAL ,round(YD_PCT,5) ,round(YD_DES,5)   
                            FROM  SSICT_YARD_DENSITY ";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #13
0
파일: SendMessage.cs 프로젝트: 4bb/Bao
        public static DataTable GetFaultMessages()
        {
            string sql = @"SELECT MECHANICALNO ,SENDMESSAGE ,FaultStatus ,EngERRORTIME ,OptERRORTIME ,REPORTTIME ,RECEIVETIME ,
                           REPAIRTIME ,CONFIRMREPAIRTIME 
                           FROM SSICT_FAULTLIST_VW ";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #14
0
        public static DataTable GetDailyReports()
        {
            string sql = @"SELECT  REPORT_DATE,LASTALLDAY_PLAN,LASTALLDAY_ACTUAL,LASTALLDAY_BARGE,LASTALLDAY_SHUTTLE,round(LASTALLDAY_COMPLETERATE,5)
                           ,MONTHLY_PLAN,MONTHLY_TARGET,MONTHLY_ACTUAL,MONTHLY_BARGE,MONTHLY_SHUTTLE,round(MONTHLY_COMPLETERATE,5),round(MONTHLY_PLANCONTAINER,5)
                           ,ANNUAL_PLAN,ANNUAL_ACTUAL,ANNUAL_BARGE,ANNUAL_SHUTTLE,round(ANNUAL_COMPLETERATE,5),round(ANNUAL_PLANCONTAINER,5)
                            FROM  SSICT_DAILY_REPORT_VW ";

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #15
0
파일: ThreeShift.cs 프로젝트: 4bb/Bao
        public static DataRow GetThreeShiftByID(string sID)
        {
            string sql = @"SELECT  SHIFTDATE, SHIFT, SHIFTPLAN, SHIFTACTUAL, SHIFTCOMPLETERATE 
                            FROM SSICT_APP_THREESHIFT_VW WHERE (ID = :tID)";

            OracleParameter[] para = new OracleParameter[1];
            para[0] = new OracleParameter("SID", sID);

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql, para);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0].Rows[0]);
            }
        }
예제 #16
0
        public static DataTable GetUserResourceByUserName(string userName)
        {
            string sql = @"SELECT SUR_USERACCOUNT ,SUR_RESOURCECODE 
                            FROM SYS_USER_RESOURCE  Where  SUR_USERACCOUNT = :userName";

            OracleParameter[] para = new OracleParameter[1];
            para[0] = new OracleParameter("userName", userName);

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql, para);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #17
0
        public static DataTable GetInternalUserByUserName(string userAccount)
        {
            string sql = @"SELECT SUR_USERACCOUNT ,SUR_PASSWORD ,SUR_DISPLAYNAME ,SUR_DESCRIPTION ,SUR_CREATETIME , SUR_UPDATETIME ,SUR_GROUP ,SUR_STATUS ,SUR_ERRORCOUNT ,SUR_ISLOOKED
                            FROM SYS_USER Where  SUR_USERACCOUNT = :userAccount";

            OracleParameter[] para = new OracleParameter[1];
            para[0] = new OracleParameter("userAccount", userAccount);

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql, para);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #18
0
파일: VesselBerth.cs 프로젝트: 4bb/Bao
        public static DataTable GetVesselBerthByDate(DateTime reportDate)
        {
            string sql = @"SELECT  REPORT_DATE,VSL_CNNAME,VBT_PBTHDT,VBT_ABTHDT, VBT_STATUS, VOT_AWKSTTM,  ISLATER
                            FROM  SSICT_DAILYREPORT_BERTH_VW  WHERE REPORT_DATE=to_date(:reportDate,'yyyy-mm-dd')";

            OracleParameter[] para = new OracleParameter[1];
            para[0] = new OracleParameter("reportDate", reportDate);

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql, para);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #19
0
파일: ThreeShift.cs 프로젝트: 4bb/Bao
        public static DataTable GetThreeShiftByDate(DateTime shiftDate)
        {
            string sql = @"SELECT  SHIFTDATE, SHIFT, SHIFTPLAN, SHIFTACTUAL, SHIFTCOMPLETERATE 
                            FROM  SSICT_APP_THREESHIFT_VW  WHERE SHIFTDATE=to_date(:shiftDate,'yyyy-mm-dd')";

            OracleParameter[] para = new OracleParameter[1];
            para[0] = new OracleParameter("shiftDate", shiftDate);

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql, para);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #20
0
파일: SendMessage.cs 프로젝트: 4bb/Bao
        public static DataRow GetSendMessageByID(string sID)
        {
            string sql = @"SELECT  ID, JobNo, SENDMESSAGE, SENDTIME, ERRORTIME, ISSEND, MECHANICALNO, FAULTSTATUS,BEGINTIME,FINISHTIME
                            FROM SSICT_SENDMSG_VW WHERE (ID = :tID)";

            OracleParameter[] para = new OracleParameter[1];
            para[0] = new OracleParameter("SID", sID);

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql, para);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0].Rows[0]);
            }
        }
예제 #21
0
        public static DataTable GetTwinLiftByDate(DateTime reportDate)
        {
            string sql = @"SELECT SCD_ID ,VESSELNAME ,IEFG ,TOTALCNT ,CANSTGOPTCNT  ,CANSTGOPTRATE ,STORAGECNT ,STORAGERATE ,OPERATECNT ,OPERATERATE ,EFFICIENCY ,REPORTDATE   
                            FROM  SSICT_DAILYREPORT_TWINLIFT  WHERE REPORTDATE=to_date(:reportDate,'yyyy-mm-dd')";

            OracleParameter[] para = new OracleParameter[1];
            para[0] = new OracleParameter("reportDate", reportDate);

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql, para);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #22
0
파일: VesselEfficiency.cs 프로젝트: 4bb/Bao
        public static DataTable GetVesselEfficiencyByDate(DateTime reportDate)
        {
            string sql = @"SELECT  REPORT_DATE, VSL_CNNAME,QCOPTM ,QCNETTM ,AVGEFF ,ABTHNO                 
                            FROM  SSICT_APP_VESSEL_EFF 
                            WHERE REPORT_DATE=to_date(:reportDate,'yyyy-mm-dd')";

            OracleParameter[] para = new OracleParameter[1];
            para[0] = new OracleParameter("reportDate", reportDate);

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql, para);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
예제 #23
0
        public static DataTable GetDailyReportByDate(DateTime reportDate)
        {
            string sql = @"SELECT REPORT_DATE,LASTALLDAY_PLAN,LASTALLDAY_ACTUAL,LASTALLDAY_BARGE,LASTALLDAY_SHUTTLE, round(LASTALLDAY_COMPLETERATE,5)
                           ,MONTHLY_PLAN,MONTHLY_TARGET,MONTHLY_ACTUAL,MONTHLY_BARGE,MONTHLY_SHUTTLE,MONTHLY_COMPLETERATE,round(MONTHLY_PLANCONTAINER,5)
                           ,ANNUAL_PLAN,ANNUAL_ACTUAL,ANNUAL_BARGE,ANNUAL_SHUTTLE, round(ANNUAL_COMPLETERATE,5),round(ANNUAL_PLANCONTAINER,5)
                            FROM  SSICT_DAILY_REPORT_VW  WHERE REPORT_DATE=to_date(:reportDate,'yyyy-mm-dd')";

            OracleParameter[] para = new OracleParameter[1];
            para[0] = new OracleParameter("reportDate", reportDate);

            DataSet ds = OracleDataTool.ExecuteDataset(ConnectStringOracle.GetInternalTableConnection(), sql, para);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }