示例#1
0
        public static string ManageLabelPrinting(LabelPrinting o)
        {
            o = o ?? new LabelPrinting();
            string Res = "Error";

            try
            {
                Dictionary <string, string> input = new Dictionary <string, string>()
                {
                    { "InScanID", o.InScanID ?? "" },
                    { "AWBNo", o.AWBNo ?? "" },
                    { "InScanDate", o.InScanDate ?? "" },
                    { "DepartmentID", o.DepartmentID ?? "" },
                    { "ConsigneeID", o.ConsigneeID ?? "" },
                    { "ConsignorID", o.ConsignorID ?? "" },
                    { "OriginID", o.OriginID ?? "" },
                    { "DestinationID", o.DestinationID ?? "" },
                    { "CustomerRateTypeID", o.CustomerRateTypeID ?? "" },
                    { "Pieces", o.Pieces ?? "" },
                    { "StatedWeight", o.StatedWeight ?? "" },
                    { "CourierServiceID", o.CourierServiceID ?? "" },
                    { "CollectedBy", o.CollectedBy ?? "" },
                    { "ReceivedBy", o.ReceivedBy ?? "" },
                    { "Remarks", o.Remarks ?? "" },
                    { "CourierStatusID", o.CourierStatusID ?? "" },
                    { "StatusPaymentMode", o.StatusPaymentMode ?? "" },
                    { "StatusClose", o.StatusClose ?? "" },
                    { "StatusInScan", o.StatusInScan ?? "" },
                    { "StatusReconciled", o.StatusReconciled ?? "" },
                    { "InscanSheetNo", o.InscanSheetNo ?? "" },
                    { "Volume", o.Volume ?? "" },
                    { "VolumeWeight", o.VolumeWeight ?? "" },
                    { "StatusOutbound", o.StatusOutbound ?? "" },
                    { "ItemID", o.ItemID ?? "" },
                    { "StatusTransit", o.StatusTransit ?? "" },
                    { "StatusCustomsDocument", o.StatusCustomsDocument ?? "" },
                    { "DespatchDate", o.DespatchDate ?? "" },
                    { "TDID", o.TDID ?? "" },
                    { "Description", o.Description ?? "" },
                    { "OriginBranchID", o.OriginBranchID ?? "" },
                    { "DestinationBranchID", o.DestinationBranchID ?? "" },
                    { "TransitMasterID", o.TransitMasterID ?? "" },
                    { "UserID", o.UserID ?? "" },
                    { "shipperContactPerson", o.shipperContactPerson ?? "" },
                    { "ConsigneeContactPerson", o.ConsigneeContactPerson ?? "" },
                    { "AcJournalID", o.AcJournalID ?? "" },
                    { "FyearID", o.FyearID ?? "" },
                    { "OtherChargeDescription", o.OtherChargeDescription ?? "" },
                    { "DeliveryDate", o.DeliveryDate ?? "" },
                    { "DeliveredBy", o.DeliveredBy ?? "" },
                    { "PODRemarks", o.PODRemarks ?? "" },
                    { "DeliveredByID", o.DeliveredByID ?? "" },
                    { "AcJournalID2", o.AcJournalID2 ?? "" },
                    { "StatusTS", o.StatusTS ?? "" },
                    { "EnquiryID", o.EnquiryID ?? "" },
                    { "OutScanDate", o.OutScanDate ?? "" },
                    { "TakenByID", o.TakenByID ?? "" },
                    { "TransitID", o.TransitID ?? "" },
                    { "RouteID", o.RouteID ?? "" },
                    { "DocumentID", o.DocumentID ?? "" },
                    { "ConsigneeDepotID", o.ConsigneeDepotID ?? "" },
                    { "CustInvValue", o.CustInvValue ?? "" },
                    { "Freight", o.Freight ?? "" },
                    { "IsNCND", o.IsNCND ?? "" },
                    { "MaterialCost", o.MaterialCost ?? "" },
                    { "MaterialCostInvoiceNo", o.MaterialCostInvoiceNo ?? "" },
                    { "NCNDRemark", o.NCNDRemark ?? "" },
                    { "PackageID", o.PackageID ?? "" },
                    { "TransitDepotID", o.TransitDepotID ?? "" },
                    { "BranchId", o.BranchId ?? "" },
                    { "CustomerID", o.CustomerID ?? "" },
                    { "PaymentType", o.PaymentType ?? "" },
                    { "IsLocalTD", o.IsLocalTD ?? "" },
                    { "SalesManID", o.SalesManID ?? "" },
                    { "ModifyBy", o.ModifyBy ?? "" },
                    { "DRSID", o.DRSID ?? "" },
                    { "DRSNo", o.DRSNo ?? "" },
                    { "DRSDate", o.DRSDate ?? "" },
                    { "VehicleID", o.VehicleID ?? "" },
                    { "Details", o.Details ?? "" },
                    { "DriverID", o.DriverID ?? "" },
                    { "EmployeeID", o.EmployeeID ?? "" },
                    { "DriverFlag", o.DriverFlag ?? "" },
                    { "VehicleType", o.VehicleType ?? "" },
                    { "RegNo", o.RegNo ?? "" },
                    { "TransferDate", o.TransferDate ?? "" },
                    { "DriverName", o.DriverName ?? "" },
                    { "Mode", o.Mode ?? "" },
                };
                Dictionary <string, string> output = new Dictionary <string, string>()
                {
                    { "Result", "" }
                };
                Dictionary <string, string> res = pgFun.ExecuteSQL("[dbo].[usp_LabelPrinting_Manage]", input, output, true);
                int  LastID = 0;
                bool isdone = int.TryParse(res["Result"], out LastID);
                if (isdone)
                {
                    Res = res["Result"];
                }
                else
                {
                    Res = res["Result"];
                }
                return(Res);
            }
            catch (Exception p)
            {
                return(p.Message);
            }
        }
示例#2
0
        public static List <LabelPrinting> GetLabelPrinting(LabelPrinting o)
        {
            o = o ?? new LabelPrinting();
            Dictionary <string, string> input = new Dictionary <string, string>()
            {
                { "InScanID", o.InScanID ?? "" },
                { "AWBNo", o.AWBNo ?? "" },
                { "InScanDate", o.InScanDate ?? "" },
                { "DepartmentID", o.DepartmentID ?? "" },
                { "ConsigneeID", o.ConsigneeID ?? "" },
                { "ConsignorID", o.ConsignorID ?? "" },
                { "OriginID", o.OriginID ?? "" },
                { "DestinationID", o.DestinationID ?? "" },
                { "CustomerRateTypeID", o.CustomerRateTypeID ?? "" },
                { "Pieces", o.Pieces ?? "" },
                { "StatedWeight", o.StatedWeight ?? "" },
                { "CourierServiceID", o.CourierServiceID ?? "" },
                { "CollectedBy", o.CollectedBy ?? "" },
                { "ReceivedBy", o.ReceivedBy ?? "" },
                { "Remarks", o.Remarks ?? "" },
                { "CourierStatusID", o.CourierStatusID ?? "" },
                { "StatusPaymentMode", o.StatusPaymentMode ?? "" },
                { "StatusClose", o.StatusClose ?? "" },
                { "StatusInScan", o.StatusInScan ?? "" },
                { "StatusReconciled", o.StatusReconciled ?? "" },
                { "InscanSheetNo", o.InscanSheetNo ?? "" },
                { "Volume", o.Volume ?? "" },
                { "VolumeWeight", o.VolumeWeight ?? "" },
                { "StatusOutbound", o.StatusOutbound ?? "" },
                { "ItemID", o.ItemID ?? "" },
                { "StatusTransit", o.StatusTransit ?? "" },
                { "StatusCustomsDocument", o.StatusCustomsDocument ?? "" },
                { "DespatchDate", o.DespatchDate ?? "" },
                { "TDID", o.TDID ?? "" },
                { "Description", o.Description ?? "" },
                { "OriginBranchID", o.OriginBranchID ?? "" },
                { "DestinationBranchID", o.DestinationBranchID ?? "" },
                { "TransitMasterID", o.TransitMasterID ?? "" },
                { "UserID", o.UserID ?? "" },
                { "shipperContactPerson", o.shipperContactPerson ?? "" },
                { "ConsigneeContactPerson", o.ConsigneeContactPerson ?? "" },
                { "AcJournalID", o.AcJournalID ?? "" },
                { "FyearID", o.FyearID ?? "" },
                { "OtherChargeDescription", o.OtherChargeDescription ?? "" },
                { "DeliveryDate", o.DeliveryDate ?? "" },
                { "DeliveredBy", o.DeliveredBy ?? "" },
                { "PODRemarks", o.PODRemarks ?? "" },
                { "DeliveredByID", o.DeliveredByID ?? "" },
                { "AcJournalID2", o.AcJournalID2 ?? "" },
                { "StatusTS", o.StatusTS ?? "" },
                { "EnquiryID", o.EnquiryID ?? "" },
                { "OutScanDate", o.OutScanDate ?? "" },
                { "TakenByID", o.TakenByID ?? "" },
                { "TransitID", o.TransitID ?? "" },
                { "RouteID", o.RouteID ?? "" },
                { "DocumentID", o.DocumentID ?? "" },
                { "ConsigneeDepotID", o.ConsigneeDepotID ?? "" },
                { "CustInvValue", o.CustInvValue ?? "" },
                { "Freight", o.Freight ?? "" },
                { "IsNCND", o.IsNCND ?? "" },
                { "MaterialCost", o.MaterialCost ?? "" },
                { "MaterialCostInvoiceNo", o.MaterialCostInvoiceNo ?? "" },
                { "NCNDRemark", o.NCNDRemark ?? "" },
                { "PackageID", o.PackageID ?? "" },
                { "TransitDepotID", o.TransitDepotID ?? "" },
                { "BranchId", o.BranchId ?? "" },
                { "CustomerID", o.CustomerID ?? "" },
                { "PaymentType", o.PaymentType ?? "" },
                { "IsLocalTD", o.IsLocalTD ?? "" },
                { "SalesManID", o.SalesManID ?? "" },
                { "DRSID", o.DRSID ?? "" },
                { "DRSNo", o.DRSNo ?? "" },
                { "Mode", o.Mode ?? "" },
                { "LastTop", o.LastTop ?? "" },
            };

            return(pgFun.GetData <LabelPrinting>("[dbo].[usp_LabelPrinting_Get]", input));
        }