Exemple #1
0
        public static void UpdateVesselPlan(int vpID, string vesselName, string vesselEnglishName, int vesselType, string voyageNumber, string importOrExportFlag, DateTime arrivePlanTime, DateTime?arriveActualTime, DateTime departurePlanTime, DateTime?departureActualTime, string berthPlan, string berthActual, bool isCustomsClosing, int status, string csi, DateTime containerBeginTime, DateTime containerDeadline, string agency, int portOfCallID, bool isActive, string remark)
        {
            string sql = @"UPDATE [VesselPlan] SET VesselName = @vesselName, VesselEnglishName = @vesselEnglishName, VesselType=@vesselType, VoyageNumber=@voyageNumber, ImportOrExportFlag = @importOrExportFlag, ArrivePlanTime = @arrivePlanTime, ArriveActualTime = @arriveActualTime, DeparturePlanTime = @departurePlanTime,DepartureActualTime = @departureActualTime
                                BerthPlan = @berthPlan, BerthActual=@berthActual, IsCustomsClosing=@isCustomsClosing, CSI=@csi, ContainerBeginTime=containerBeginTime, ContainerDeadline=@containerDeadline  Status=@status, Agency=@agency, PortOfCallID=@portOfCallID, IsActive=@isActive, Remark=@remark WHERE ID = @vpID";

            SqlParameter[] para = { new SqlParameter("@vpID",                vpID),
                                    new SqlParameter("@vesselName",          vesselName),
                                    new SqlParameter("@vesselEnglishName",   vesselEnglishName),
                                    new SqlParameter("@vesselType",          vesselType),
                                    new SqlParameter("@voyageNumber",        voyageNumber),
                                    new SqlParameter("@importOrExportFlag",  importOrExportFlag),
                                    new SqlParameter("@arrivePlanTime",      arrivePlanTime),
                                    new SqlParameter("@arriveActualTime",    arriveActualTime.HasValue ? (object)arriveActualTime.Value : (object)DBNull.Value),
                                    new SqlParameter("@departurePlanTime",   departurePlanTime),
                                    new SqlParameter("@departureActualTime", departureActualTime.HasValue ? (object)departureActualTime.Value : (object)DBNull.Value),
                                    new SqlParameter("@berthPlan",           berthPlan),
                                    new SqlParameter("@berthActual",         berthActual),
                                    new SqlParameter("@isCustomsClosing",    isCustomsClosing),
                                    new SqlParameter("@status",              status),
                                    new SqlParameter("@csi",                 csi),
                                    new SqlParameter("@containerBeginTime",  containerBeginTime),
                                    new SqlParameter("@containerDeadline",   containerDeadline),
                                    new SqlParameter("@agency",              agency),
                                    new SqlParameter("@PortOfCallID",        portOfCallID),
                                    new SqlParameter("@isActive",            isActive),
                                    new SqlParameter("@remark",              remark) };

            SqlHelper.ExecuteNonQuery(ConnectStringMsSql.GetConnection(), CommandType.Text, sql, para);
        }
Exemple #2
0
        public static void UpdateContainer(int cID, string containerNo, DateTime arriveTime, DateTime departureTime, string arriveType, string departureType, string customsClearance, int vesselID, DateTime arrivalContainerTime, DateTime customsClearanceTime, DateTime stowageTime, DateTime vesselTime, DateTime planTime, DateTime planAcceptedTime, string vesselName, string voyageNumber, string billOfLadingNum, DateTime arrivalPortTime, DateTime sendPackingListTime, DateTime planAarrangeTime, string acceptanceNo, bool isActive, string remark)
        {
            string sql = @"UPDATE [Container] SET containerNo = @containerNo, ArriveTime = @arriveTime, DepartureTime=@departureTime, ArriveType = @arriveType, DepartureType = @departureType, CustomsClearance=@customsClearance  VesselID=@vesselID,  ArrivalContainerTime = @arrivalContainerTime, CustomsClearanceTime = @customsClearanceTime, StowageTime = @stowageTime, VesselTime = @vesselTime, PlanTime = @planTime, PlanAcceptedTime=@planAcceptedTime, VesselName=@vesselName, VoyageNumber = @voyageNumber, BillOfLadingNum = @billOfLadingNum, ArrivalPortTime = @arrivalPortTime, SendPackingListTime = @sendPackingListTime, PlanAarrangeTime = @planAarrangeTime AcceptanceNo=@acceptanceNo  WHERE ID = @cID";

            SqlParameter[] para = { new SqlParameter("@cID",                  cID),
                                    new SqlParameter("@containerNo",          containerNo),
                                    new SqlParameter("@arriveTime",           arriveTime),
                                    new SqlParameter("@departureTime",        departureTime),
                                    new SqlParameter("@arriveType",           arriveType),
                                    new SqlParameter("@departureType",        departureType),
                                    new SqlParameter("@customsClearance",     customsClearance),
                                    new SqlParameter("@vesselID",             vesselID),
                                    new SqlParameter("@arrivalContainerTime", arrivalContainerTime),
                                    new SqlParameter("@customsClearanceTime", customsClearanceTime),
                                    new SqlParameter("@stowageTime",          stowageTime),
                                    new SqlParameter("@vesselTime",           vesselTime),
                                    new SqlParameter("@planTime",             planTime),
                                    new SqlParameter("@planAcceptedTime",     planAcceptedTime),
                                    new SqlParameter("@vesselName",           vesselName),
                                    new SqlParameter("@voyageNumber",         voyageNumber),
                                    new SqlParameter("@billOfLadingNum",      billOfLadingNum),
                                    new SqlParameter("@arrivalPortTime",      arrivalPortTime),
                                    new SqlParameter("@sendPackingListTime",  sendPackingListTime),
                                    new SqlParameter("@planAarrangeTime",     planAarrangeTime),
                                    new SqlParameter("@acceptanceNo",         acceptanceNo),
                                    new SqlParameter("@isActive",             isActive),
                                    new SqlParameter("@remark",               remark), };

            SqlHelper.ExecuteNonQuery(ConnectStringMsSql.GetConnection(), CommandType.Text, sql, para);
        }
Exemple #3
0
        public static void InsertVesselPlan(int vpID, string vesselName, string vesselEnglishName, int vesselType, string voyageNumber, string importOrExportFlag, DateTime arrivePlanTime, DateTime?arriveActualTime, DateTime departurePlanTime, DateTime?departureActualTime, string berthPlan, string berthActual, bool isCustomsClosing, int status, string csi, DateTime containerBeginTime, DateTime containerDeadline, string agency, int portOfCallID, bool isActive, string remark)
        {
            string sql = @"INSERT INTO [VesselPlan] 
                            (VesselName, VesselEnglishName, VesselType, VoyageNumber, ImportOrExportFlag, ArrivePlanTime, ArriveActualTime, DeparturePlanTime, DepartureActualTime, BerthPlan, BerthActual, IsCustomsClosing, Status, CSI, ContainerBeginTime, ContainerDeadline, Agency, PortOfCallID, IsActive, Remark) VALUES 
                            (@vesselName, @vesselEnglishName, @vesselType, @voyageNumber, @importOrExportFlag, @arrivePlanTime, @arriveActualTime, @departurePlanTime, @departureActualTime, @berthPlan, @berthActual, @isCustomsClosing, @status, @csi, @containerBeginTime, @containerDeadline, @agency, @portOfCallID, @isActive, @remark)";

            SqlParameter[] para = { new SqlParameter(),
                                    new SqlParameter("@vesselName",         vesselName),
                                    new SqlParameter("@vesselEnglishName",  vesselEnglishName),
                                    new SqlParameter("@vesselType",         vesselType),
                                    new SqlParameter("@voyageNumber",       voyageNumber),
                                    new SqlParameter("@importOrExportFlag", importOrExportFlag),
                                    new SqlParameter("@arrivePlanTime",     arrivePlanTime),
                                    new SqlParameter("@arriveActualTime",   arriveActualTime.HasValue ? (object)arriveActualTime.Value : (object)DBNull.Value),
                                    new SqlParameter("@departurePlanTime",  departurePlanTime),
                                    new SqlParameter("@departureActualTime",departureActualTime.HasValue ? (object)departureActualTime.Value : (object)DBNull.Value),
                                    new SqlParameter("@berthPlan",          berthPlan),
                                    new SqlParameter("@berthActual",        berthActual),
                                    new SqlParameter("@isCustomsClosing",   isCustomsClosing),
                                    new SqlParameter("@status",             status),
                                    new SqlParameter("@csi",                csi),
                                    new SqlParameter("@containerBeginTime", containerBeginTime),
                                    new SqlParameter("@containerDeadline",  containerDeadline),
                                    new SqlParameter("@agency",             agency),
                                    new SqlParameter("@portOfCallID",       portOfCallID),
                                    new SqlParameter("@isActive",           isActive),
                                    new SqlParameter("@remark",             remark) };

            SqlHelper.ExecuteNonQuery(ConnectStringMsSql.GetConnection(), CommandType.Text, sql, para);
        }
Exemple #4
0
        public static void DeleteVesselPlan(int vpID)
        {
            string sql = "DELETE FROM [VesselPlan] WHERE ID = @vpID";

            SqlParameter[] para = { new SqlParameter("@vpID", vpID) };

            SqlHelper.ExecuteNonQuery(ConnectStringMsSql.GetConnection(), CommandType.Text, sql, para);
        }
Exemple #5
0
Fichier : Truck.cs Projet : 4bb/Bao
        public static void DeleteTruck(int tID)
        {
            string sql = "DELETE FROM [Truck] WHERE ID = @tID";

            SqlParameter[] para = { new SqlParameter("@ctID", tID) };

            SqlHelper.ExecuteNonQuery(ConnectStringMsSql.GetConnection(), CommandType.Text, sql, para);
        }
Exemple #6
0
Fichier : Truck.cs Projet : 4bb/Bao
        public static void UpdateTruck(int tID, string truckNo, DateTime arriveYardTime, DateTime departureYardTime, bool isActive, string remark)
        {
            string sql = @"UPDATE [Truck] SET TruckNo = @truckNo, ArriveYardTime = @arriveYardTime, DepartureYardTime=@departureYardTime, IsActive=@isActive, Remark=@remark WHERE ID = @tID";

            SqlParameter[] para = { new SqlParameter("@tID",               tID),
                                    new SqlParameter("@truckNo",           truckNo),
                                    new SqlParameter("@arriveYardTime",    arriveYardTime),
                                    new SqlParameter("@departureYardTime", departureYardTime),
                                    new SqlParameter("@isActive",          isActive),
                                    new SqlParameter("@remark",            remark) };

            SqlHelper.ExecuteNonQuery(ConnectStringMsSql.GetConnection(), CommandType.Text, sql, para);
        }
Exemple #7
0
Fichier : Truck.cs Projet : 4bb/Bao
        public static void InsertTruck(int tID, string truckNo, DateTime arriveYardTime, DateTime departureYardTime, bool isActive, string remark)
        {
            string sql = @"INSERT INTO [Truck] 
                            (TruckNo, ArriveYardTime, DepartureYardTime,  IsActive, Remark) VALUES 
                            (@truckNo, @arriveYardTime, @departureYardTime, isActive, remark";

            SqlParameter[] para = { new SqlParameter(),
                                    new SqlParameter("@truckNo",          truckNo),
                                    new SqlParameter("@arriveYardTime",   arriveYardTime),
                                    new SqlParameter("@departureYardTime",departureYardTime),
                                    new SqlParameter("@isActive",         isActive),
                                    new SqlParameter("@remark",           remark) };

            SqlHelper.ExecuteNonQuery(ConnectStringMsSql.GetConnection(), CommandType.Text, sql, para);
        }
Exemple #8
0
Fichier : Truck.cs Projet : 4bb/Bao
        public static DataTable GetTrucks()
        {
            string sql = @"SELECT ID, truckNo, ArriveYardTime, DepartureYardTime, IsActive, Remark
                           FROM [Truck] ORDER BY ID DESC";

            DataSet ds = SqlHelper.ExecuteDataset(ConnectStringMsSql.GetConnection(), CommandType.Text, sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
Exemple #9
0
        public static DataTable GetVesselPlans()
        {
            string sql = @"SELECT ID, VesselName, VesselEnglishName, VesselType, VoyageNumber, ImportOrExportFlag, ArrivePlanTime, ArriveActualTime, DeparturePlanTime, 
                         DepartureActualTime, BerthPlan, BerthActual, IsCustomsClosing, Status, CSI, ContainerBeginTime, ContainerDeadline, Agency, PortOfCallID, IsActive, Remark 
                         FROM [VesselPlan] ORDER BY ID DESC";

            DataSet ds = SqlHelper.ExecuteDataset(ConnectStringMsSql.GetConnection(), CommandType.Text, sql);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0]);
            }
        }
Exemple #10
0
        public static DataRow GetVesselPlanByID(int vpID)
        {
            string sql = @"SELECT ID, VesselName, VesselEnglishName, VesselType, VoyageNumber, ImportOrExportFlag, ArrivePlanTime, ArriveActualTime, DeparturePlanTime, 
                         DepartureActualTime, BerthPlan, BerthActual, IsCustomsClosing, Status, CSI, ContainerBeginTime, ContainerDeadline, Agency, PortOfCallID, IsActive, Remark
                         FROM VesselPlan
                         WHERE (ID = @vpID)";

            DataSet ds = SqlHelper.ExecuteDataset(ConnectStringMsSql.GetConnection(), CommandType.Text, sql, new SqlParameter("@vpID", vpID));

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(null);
            }
            else
            {
                return(ds.Tables[0].Rows[0]);
            }
        }
Exemple #11
0
        public static DataTable GetContainers()
        {
            string sql = @"SELECT ID, ContainerNo, ArriveTime, DepartureTime, ArriveType, DepartureType, CustomsClearance, VesselID, ArrivalContainerTime, CustomsClearanceTime, 
                         StowageTime, VesselTime, PlanTime, PlanAcceptedTime, VesselName, VoyageNumber, BillOfLadingNum, ArrivalPortTime, SendPackingListTime, PlanAarrangeTime, AcceptanceNo,
                         IsActive, Remark 
                         FROM [Container] ORDER BY ID DESC";

            DataSet ds = SqlHelper.ExecuteDataset(ConnectStringMsSql.GetConnection(), CommandType.Text, sql);

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