示例#1
0
        private void toolStripButton3_Click(object sender, EventArgs e)
        {
            if (!CustomDelete)
            {
                if (string.IsNullOrEmpty(DeleteSql))
                {
                    MessageBox.Show("Nenurodyta duomenų trynimo procedūra", "Įspėjimas", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

                if (dataGridView1.SelectedCells.Count <= 0)
                {
                    MessageBox.Show("Nepasirinkta duomenų eilutė", "Įspėjimas", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

                if (string.IsNullOrEmpty(FormMainId))
                {
                    MessageBox.Show("Nenurodytas formos ID", "Įspėjimas", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

                int id = NullCheck.IsNullInt(NullCheck.IsNullString(dataGridView1.SelectedRows[0].Cells[FormMainId].Value));

                if (id > 0)
                {
                    Sql.ExecuteCmd(DeleteSql, new object[]
                    {
                        $"@{FormMainId}", id
                    });
                }
                RefreshGrid();
            }
        }
示例#2
0
        private void DView_DoubleClick(object sender, EventArgs e)
        {
            try
            {
                if (dView.DataSource != null && ((DataTable)dView.DataSource).Rows.Count > 0 && ShipmentId > 0)
                {
                    DataGridViewRow row = dView.SelectedRows[0];
                    if (row != null)
                    {
                        bool Deselect = NullCheck.IsNullInt(row.Cells["ShipmentId"].Value) > 0 ? true : false;
                        Sql.ExecuteCmd("ChangeShipmentAssign", new object[]
                        {
                            "@RcvOrdId", NullCheck.IsNullInt(row.Cells["RcvOrderId"].Value),
                            "@ShipmentId", Deselect ? 0 : ShipmentId
                        });

                        row.Cells["ShipmentId"].Value = Deselect ? 0 : ShipmentId;

                        if (!Deselect)
                        {
                            row.DefaultCellStyle.BackColor = Color.Cyan;
                        }
                        else
                        {
                            row.DefaultCellStyle.BackColor = Color.LightGreen;
                        }

                        dView.SelectedRows[0].Selected = false;
                    }
                }
            }
            catch
            {
            }
        }
示例#3
0
 private void Save()
 {
     if (ShipmentId == -1)
     {
         Sql.ExecuteCmd(SaveProcedure, new object[] {
             "@ShipmentId", tShipmentId.Text,
             "@ShipmentNo", tShipmentNo.Text,
             "@PartnerId", SelectedPartnerId,
             "@WarehouseId", GlobalUser.CurrentWarehouseId,
             "@CreateDate", DateTime.Now.ToShortDateString(),
             "@UpdateDate", DateTime.Now.ToShortDateString()
         });
         ShipmentId       = NullCheck.IsNullInt(Sql.GetString($"SELECT dbo.ValidateSaveShipment('{tShipmentNo.Text}')"));
         tShipmentId.Text = NullCheck.IsNullString(ShipmentId);
         if (ShipmentId > 0)
         {
             LoadData();
         }
     }
     else
     {
         Sql.ExecuteCmd(UpdateProcedure, new object[] {
             "@ShipmentId", ShipmentId,
             "@ShipmentNo", tShipmentNo.Text,
             "@PartnerId", SelectedPartnerId,
             "@WarehouseId", GlobalUser.CurrentWarehouseId,
             "@UpdateDate", DateTime.Now.ToShortDateString()
         });
     }
     LogAction(ShipmentId == -1 ? SaveProcedure : UpdateProcedure);
 }
示例#4
0
 private void Save()
 {
     if (DocId == -1)
     {
         Sql.ExecuteCmd(SaveProcedure, new object[] {
             "@DocNo", tDocNo.Text,
             "@WarehouseId", GlobalUser.CurrentWarehouseId,
             "@CreateDate", DateTime.Now.ToShortDateString(),
             "@UpdateDate", DateTime.Now.ToShortDateString()
         });
         DocId = NullCheck.IsNullInt(Sql.GetString($"SELECT dbo.ValidateSaveRcvOrd('{tDocNo.Text}')"));
         if (DocId > 0)
         {
             LoadData();
         }
     }
     else
     {
         Sql.ExecuteCmd(UpdateProcedure, new object[] {
             "@DocNo", tDocNo.Text,
             "@WarehouseId", GlobalUser.CurrentWarehouseId,
             "@UpdateDate", DateTime.Now.ToShortDateString(),
             "@RcvDocId", DocId
         });
     }
     LogAction(DocId == -1 ? SaveProcedure : UpdateProcedure);
 }
示例#5
0
        public void LoadData()
        {
            DataTable dt = Sql.GetTable(SelectProcedure, new object[] { "@WarehouseZoneId", WarehouseZoneId });

            if (dt.Rows.Count > 0)
            {
                tFZoneCode.Text  = NullCheck.IsNullString(dt.Rows[0]["ZoneCode"]);
                tFZoneName.Text  = NullCheck.IsNullString(dt.Rows[0]["ZoneName"]);
                tWarehouse.Text  = NullCheck.IsNullString(dt.Rows[0]["WarehouseName"]);
                tCreated.Text    = NullCheck.IsNullDate(dt.Rows[0]["CreateDate"]).ToShortDateString();
                tUpdated.Text    = NullCheck.IsNullDate(dt.Rows[0]["UpdateDate"]).ToShortDateString();
                FZoneParentId    = NullCheck.IsNullInt(dt.Rows[0]["ParentID"]);
                tSpotHeight.Text = NullCheck.IsNullString(dt.Rows[0]["SpotHeight"]);
                tSpotLength.Text = NullCheck.IsNullString(dt.Rows[0]["SpotLength"]);
                tSpotWidth.Text  = NullCheck.IsNullString(dt.Rows[0]["SpotWidth"]);
                tSpotVolume.Text = NullCheck.IsNullString(dt.Rows[0]["SpotVolume"]);
            }


            RemainingVolume = NullCheck.IsNullDecimal(Sql.GetString($"SELECT dbo.RemainingZoneVolume('{WarehouseZoneId}')"));
            if (NullCheck.IsNullDecimal(dt.Rows[0]["SpotVolume"]) != RemainingVolume)
            {
                tSpotHeight.Enabled = false;
                tSpotLength.Enabled = false;
                tSpotVolume.Enabled = false;
                tSpotWidth.Enabled  = false;
            }
        }
示例#6
0
 private void DataGridView1_DoubleClick(object sender, EventArgs e)
 {
     if (dataGridView1.SelectedRows.Count > 0)
     {
         ItemMapper.selectedId = NullCheck.IsNullInt(dataGridView1.SelectedRows[0].Cells["ItemId"].Value);
         this.Close();
     }
 }
示例#7
0
        private int GetSelectedItemId(DataGridView dView)
        {
            if (dView.SelectedRows.Count <= 0)
            {
                MessageBox.Show("Pasirinkite eilutę, kurią norite redaguoti!", "Informacija", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }

            return(NullCheck.IsNullInt(dView.SelectedRows[0].Cells[FormMainId].Value));
        }
示例#8
0
 private void button1_Click(object sender, EventArgs e)
 {
     if (ValueChanged)
     {
         GlobalUser.CurrentWarehouseId = NullCheck.IsNullInt(cWarehouses.SelectedValue);
     }
     DialogResult = DialogResult.OK;
     this.Close();
 }
示例#9
0
        private bool ValidInput()
        {
            string errorMsg = string.Empty;

            if (string.IsNullOrEmpty(tFZoneCode.Text))
            {
                errorMsg += "Negalimas zonos kodas\n";
            }

            if (string.IsNullOrEmpty(tFZoneName.Text))
            {
                errorMsg += "Negalimas zonos pavadinimas\n";
            }

            if (string.IsNullOrEmpty(tSpotWidth.Text))
            {
                errorMsg += "Negalimas zonos plotis\n";
            }

            if (string.IsNullOrEmpty(tSpotVolume.Text))
            {
                errorMsg += "Negalimas zonos tūris\n";
            }

            if (string.IsNullOrEmpty(tSpotHeight.Text))
            {
                errorMsg += "Negalimas zonos aukštis\n";
            }

            if (string.IsNullOrEmpty(tSpotLength.Text))
            {
                errorMsg += "Negalimas zonos ilgis\n";
            }

            int Exists = NullCheck.IsNullInt(Sql.GetString($"SELECT dbo.ValidateFZone('{tFZoneName.Text}', '{tFZoneCode.Text}')"));

            if (Exists > 0 && WarehouseZoneId < 0)
            {
                errorMsg += "Zonos kodo ir pavadinimo kombinacija nėra unikali\n";
            }

            if (Exists > 0 && WarehouseZoneId > 0)
            {
                if (NullCheck.IsNullInt(Sql.GetString($"SELECT dbo.CheckIfFZoneIsUnique('{WarehouseZoneId}','{tFZoneName.Text}','{tFZoneCode.Text}')")) == 0)
                {
                    errorMsg += "Zonos kodo ir pavadinimo kombinacija nėra unikali\n";
                }
            }

            if (!string.IsNullOrEmpty(errorMsg))
            {
                MessageBox.Show("Negalima išsaugoti zonos:\n" + errorMsg, "Klaida", MessageBoxButtons.OK);
                return(false);
            }
            return(true);
        }
示例#10
0
 public static void ParseDataTable(DataTable data)
 {
     Username  = NullCheck.IsNullString(data.Rows[0][nameof(Username)]);
     Name      = NullCheck.IsNullString(data.Rows[0][nameof(Name)]);
     Surname   = NullCheck.IsNullString(data.Rows[0][nameof(Surname)]);
     UserLevel = NullCheck.IsNullInt(data.Rows[0][nameof(UserLevel)]);
     UserId    = NullCheck.IsNullInt(data.Rows[0][nameof(UserId)]);
     SuperUser = NullCheck.IsNullBoolean(data.Rows[0][nameof(SuperUser)]);
     LogLogin();
 }
示例#11
0
 private void CWarehouses_SelectedValueChanged(object sender, EventArgs e)
 {
     if (GlobalUser.CurrentWarehouseId != NullCheck.IsNullInt(cWarehouses.SelectedValue))
     {
         ValueChanged = true;
     }
     else
     {
         ValueChanged = false;
     }
 }
示例#12
0
        private int GetSelectedItemId()
        {
            string NodeKey = treeView1.SelectedNode.Name;

            if (NodeKey == null)
            {
                MessageBox.Show("Pasirinkite eilutę, kurią norite redaguoti!", "Informacija", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }

            return(NullCheck.IsNullInt(NodeKey));
        }
示例#13
0
 private void DView_SelectionChanged(object sender, EventArgs e)
 {
     ChangeButtonBehaviour(AccessGrid());
     if (AccessGrid().SelectedRows.Count > 0 && NullCheck.IsNullInt(AccessGrid().SelectedRows[0].Cells["ShipmentId"].Value) > 0)
     {
         dataGridView2.Visible = true;
         MapOrderedItemData(NullCheck.IsNullInt(AccessGrid().SelectedRows[0].Cells["ShipmentId"].Value));
     }
     else
     {
         dataGridView2.Visible = false;
     }
 }
示例#14
0
 private void AssignWarehouse()
 {
     try
     {
         GlobalUser.SetWarehouseId(NullCheck.IsNullInt(dViewDataShow.SelectedRows[0].Cells["WarehouseId"].Value));
     }
     catch
     {
         SelectWarehouse();
     }
     activeMenu = ActiveMenuTypes.MainMenu;
     HideDataShow();
     ShowMenu(new string[] { "Priėmimas", "Padėjimas", "Surinkimas", "Išvežimas" });
 }
示例#15
0
        private void ProcessPickQuantity()
        {
            decimal ScannedAmount = NullCheck.IsNullDecimal(tBoxInput2.Text);

            if (ScannedAmount == Decimal.Zero)
            {
                EnableRows(9);
                SetRow9("Netinkama įvestis", ContentAlignment.MiddleCenter, Color.Red);
                return;
            }
            DataRow row             = ItemList.AsEnumerable().Where(x => x.Field <string>("Barcode") == tBoxInput1.Text).FirstOrDefault();
            decimal RequestedAmount = NullCheck.IsNullDecimal(row["Quantity"]);

            if (ScannedAmount > RequestedAmount)
            {
                EnableRows(9);
                SetRow9("Surinktas didesnis kiekis nei reikia surinkti", ContentAlignment.MiddleCenter, Color.Red);
                return;
            }
            PickingActions.SetWOInProcess(NullCheck.IsNullInt(row["WOrderId"]));
            DisableRows(9);
            decimal LeftQty = RequestedAmount - ScannedAmount;

            if (LeftQty == decimal.Zero)
            {
                PickingActions.CloseWO(NullCheck.IsNullInt(row["WOrderId"]));
                ItemList.Rows.Remove(row);
            }
            else
            {
                row["Quantity"] = LeftQty;
            }
            ClearInput(input1: false);
            if (ItemList.Rows.Count > 0)
            {
                if (LeftQty == Decimal.Zero)
                {
                    SetScanWO();
                }
                processMethod = new Action(ProcessWOScan);
            }
            else
            {
                ClearInput();
                EnableInput();
                ProcessWO();
            }
        }
示例#16
0
        public void LoadData()
        {
            DataTable dt = Sql.GetTable(SelectProcedure, new object[] { "@OutOrderId", DocId });

            if (dt.Rows.Count > 0)
            {
                tDocNo.Text             = NullCheck.IsNullString(dt.Rows[0]["DocumentNo"]);
                tCustomer.Text          = NullCheck.IsNullString(dt.Rows[0]["PartnerName"]);
                dtPlannedShipment.Value = NullCheck.IsNullDate(dt.Rows[0]["ShippingPlanned"]);
                tState.Text             = NullCheck.IsNullString(dt.Rows[0]["OOStateName"]);
                tCreateDate.Text        = NullCheck.IsNullDate(dt.Rows[0]["Created"]).ToShortDateString();
                tUpdated.Text           = NullCheck.IsNullDate(dt.Rows[0]["Updated"]).ToShortDateString();
                SelectedPartnerId       = NullCheck.IsNullInt(dt.Rows[0]["PartnerId"]);
                StateId = NullCheck.IsNullInt(dt.Rows[0]["OOStateId"]);
            }
        }
示例#17
0
        public void LoadData()
        {
            DataTable dt = Sql.GetTable(SelectProcedure, new object[] { "@ShipmentId", ShipmentId });

            if (dt != null && dt.Rows.Count > 0)
            {
                tShipmentId.Text  = NullCheck.IsNullString(ShipmentId);
                SelectedPartnerId = NullCheck.IsNullInt(dt.Rows[0]["PartnerId"]);
                tPartner.Text     = NullCheck.IsNullString(dt.Rows[0]["PartnerName"]);
                tWarehouse.Text   = NullCheck.IsNullString(dt.Rows[0]["WarehouseName"]);
                tShipmentNo.Text  = NullCheck.IsNullString(dt.Rows[0]["ShipmentNo"]);
                tCreateDate.Text  = NullCheck.IsNullDate(dt.Rows[0]["CreateDate"]).ToShortDateString();
                tUpdated.Text     = NullCheck.IsNullDate(dt.Rows[0]["UpdateDate"]).ToShortDateString();
                LoadDView();
            }
        }
示例#18
0
        private void Shipment_Click(object sender, EventArgs e)
        {
            int SelectedParcelId = GetSelectedItemId(AccessGrid());

            if (SelectedParcelId > 0)
            {
                DataTable dt = Sql.GetTable("GetRelatedOutOrders", new object[] { "@ParcelId", SelectedParcelId });
                if (dt != null && dt.Rows.Count > 0)
                {
                    foreach (DataRow row in dt.Rows)
                    {
                        DataTable relatedItemId = Sql.GetTable("StartOutOrderDocsAndGetOrderedItems", new object[] { "@OutOrderId", row["OutOrderID"] });
                        GenerateWO(relatedItemId, NullCheck.IsNullInt(row["OutOrderID"]));
                    }
                }
            }
        }
示例#19
0
        private void LoadUnloadBarcode()
        {
            string  ScannedBarcode = NullCheck.IsNullString(tBoxInput1.Text);
            DataRow row            = ItemList.AsEnumerable().Where(x => x.Field <string>("Barcode") == ScannedBarcode).FirstOrDefault();

            ShippingActions.LoadCU(NullCheck.IsNullInt(row["StoredPalletId"]));
            ItemList.Rows.Remove(row);
            ClearInput();
            if (ItemList.Rows.Count > 0)
            {
                ProcessCULoading();
            }
            else
            {
                ProcessLoading();
            }
        }
示例#20
0
        private bool ValidInput()
        {
            string errorMsg = string.Empty;

            if (string.IsNullOrEmpty(tPartnerCode.Text))
            {
                tPartnerName.Invalidate();
                errorMsg += "Negalimas partnerio kodas\n";
            }

            if (string.IsNullOrEmpty(tPartnerName.Text))
            {
                tPartnerName.Invalidate();
                errorMsg += "Negalimas partnerio pavadinimas\n";
            }

            if (!cbCustomer.Checked && !cbSupply.Checked)
            {
                errorMsg += "Pasirinkite partnerio tipą\n";
            }

            int Exists = NullCheck.IsNullInt(Sql.GetString($"SELECT dbo.ValidatePartner('{tPartnerName.Text}', '{tPartnerCode.Text}')"));

            if (Exists > 0 && PartnerId < 0)
            {
                errorMsg += "Partnerio kodo ir pavadinimo kombinacija nėra unikali\n";
            }

            if (Exists > 0 && PartnerId > 0)
            {
                if (NullCheck.IsNullInt(Sql.GetString($"SELECT dbo.CheckIfPartnerIsUnique('{PartnerId}','{tPartnerName.Text}','{tPartnerCode.Text}')")) == 0)
                {
                    errorMsg += "Partnerio kodo ir pavadinimo kombinacija nėra unikali\n";
                }
            }

            if (!string.IsNullOrEmpty(errorMsg))
            {
                MessageBox.Show("Negalima išsaugoti partnerio:\n" + errorMsg, "Klaida", MessageBoxButtons.OK);
                return(false);
            }
            return(true);
        }
示例#21
0
        public void LoadData()
        {
            DataTable dt = Sql.GetTable(SelectProcedure, new object[] { "@RcvDocId", DocId });

            if (dt.Rows.Count > 0)
            {
                tDocNo.Text            = NullCheck.IsNullString(dt.Rows[0]["DocCode"]);
                tSupplier.Text         = NullCheck.IsNullString(dt.Rows[0]["PartnerName"]);
                dtArrivalPlanned.Value = NullCheck.IsNullDate(dt.Rows[0]["ArrivalPlaned"]);
                tTruckNo.Text          = NullCheck.IsNullString(dt.Rows[0]["TruckNo"]);
                tTrailerNo.Text        = NullCheck.IsNullString(dt.Rows[0]["TrailerNo"]);
                tDriver.Text           = NullCheck.IsNullString(dt.Rows[0]["Driver"]);
                tState.Text            = NullCheck.IsNullString(dt.Rows[0]["IOStateName"]);
                tCreateDate.Text       = NullCheck.IsNullDate(dt.Rows[0]["CreateDate"]).ToShortDateString();
                tUpdated.Text          = NullCheck.IsNullDate(dt.Rows[0]["UpdateDate"]).ToShortDateString();
                SelectedPartnerId      = NullCheck.IsNullInt(dt.Rows[0]["SupplierId"]);
                StateId = NullCheck.IsNullInt(dt.Rows[0]["StateId"]);
            }
        }
示例#22
0
        private void LoadDView()
        {
            DataTable dt = Sql.GetTable("GetRcvDocsForOrderEditor", new object[]
            {
                "@RcvOrdId", DocId
            });

            dView.DataSource = dt;
            EditColumns();
            foreach (DataGridViewRow row in dView.Rows)
            {
                if (NullCheck.IsNullInt(row.Cells["RcvOrderId"].Value) == DocId)
                {
                    row.DefaultCellStyle.BackColor = Color.Cyan;
                }
                else
                {
                    row.DefaultCellStyle.BackColor = Color.LightGreen;
                }
            }
        }
示例#23
0
 public void SaveRow(DataGridViewRow row)
 {
     if (NullCheck.IsNullInt(row.Cells["ItemId"].Value) > 0 && NullCheck.IsNullDecimal(row.Cells["Quantity"].Value) > 0)
     {
         Sql.ExecuteCmd(NullCheck.IsNullInt(row.Cells["OrderedItemId"].Value) <= 0 ? SaveRcvDocDet : UpdateRcvDocDet, new object[]
         {
             "@OrderedItemId", NullCheck.IsNullInt(row.Cells["OrderedItemId"].Value),
             "@Quantity", NullCheck.IsNullDecimal(row.Cells["Quantity"].Value),
             "@Created", DateTime.Now,
             "@Updated", DateTime.Now,
             "@ItemId", NullCheck.IsNullInt(row.Cells["ItemId"].Value),
             "@RcvDocId", CurrentRcvDocId
         });
         _handle = false;
         if (NullCheck.IsNullInt(row.Cells["OrderedItemId"].Value) <= 0)
         {
             ((DataTable)dataGridView2.DataSource).Rows.Add();
         }
         row.Cells["OrderedItemId"].Value = NullCheck.IsNullInt(Sql.GetString($"SELECT dbo.ValidateDetSave('{NullCheck.IsNullInt(row.Cells["ItemId"].Value)}','{CurrentRcvDocId}')"));
         _handle = true;
     }
 }
示例#24
0
        private bool ValidInput()
        {
            string errorMsg = string.Empty;

            if (string.IsNullOrEmpty(tCode.Text))
            {
                tCode.Invalidate();
                errorMsg += "Negalimas sandėlio kodas\n";
            }
            if (string.IsNullOrEmpty(tName.Text))
            {
                tName.Invalidate();
                errorMsg += "Negalimas sandėlio pavadinimas\n";
            }

            int Exists = NullCheck.IsNullInt(Sql.GetString($"SELECT dbo.ValidateWarehouse('{tCode.Text}', '{tName.Text}')"));

            if (Exists > 0 && WarehouseId < 0)
            {
                errorMsg += "Sandėlio kodo ir pavadinimo kombinacija nėra unikali\n";
            }

            if (Exists > 0 && WarehouseId > 0)
            {
                if (NullCheck.IsNullInt(Sql.GetString($"SELECT dbo.CheckIfWarehouseIsUnique('{WarehouseId}','{tName.Text}','{tCode.Text}')")) == 0)
                {
                    errorMsg += "Sandėlio kodo ir pavadinimo kombinacija nėra unikali\n";
                }
            }

            if (!string.IsNullOrEmpty(errorMsg))
            {
                MessageBox.Show("Negalima išsaugoti sandėlio:\n" + errorMsg, "Klaida", MessageBoxButtons.OK);
                return(false);
            }
            return(true);
        }
示例#25
0
        private void LoadDView()
        {
            DataTable dt = Sql.GetTable("GetRcvOrdersForShipmentEditor", new object[]
            {
                "@ShipmentId", ShipmentId
            });

            dView.DataSource = dt;
            if (dt != null)
            {
                EditColumns();
                foreach (DataGridViewRow row in dView.Rows)
                {
                    if (NullCheck.IsNullInt(row.Cells["ShipmentId"].Value) == ShipmentId)
                    {
                        row.DefaultCellStyle.BackColor = Color.Cyan;
                    }
                    else
                    {
                        row.DefaultCellStyle.BackColor = Color.LightGreen;
                    }
                }
            }
        }
示例#26
0
        private void SetupForm()
        {
            DataTable dt = Sql.GetTable(WarehouseComboSql);

            if (dt != null && dt.Rows.Count > 0)
            {
                if (dt.AsEnumerable().Where(x => x.Field <string>("WarehouseCode") == "TEST").FirstOrDefault() != null)
                {
                    GlobalUser.SetWarehouseId(NullCheck.IsNullInt(dt.AsEnumerable().Where(x => x.Field <string>("WarehouseCode") == "TEST").FirstOrDefault()["WarehouseId"]));
                }
                else
                {
                    GlobalUser.SetWarehouseId(NullCheck.IsNullInt(dt.Rows[0]["WarehouseId"]));
                }
            }
            else
            {
                MessageBox.Show("Nerastas registruotas sandėlys sistemoje.", "Ispėjimas", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            this.MinimizeBox     = false;
            this.WindowState     = FormWindowState.Maximized;
            this.FormBorderStyle = FormBorderStyle.FixedSingle;
            SetupUserInfo();
        }
示例#27
0
        private static DataTable ProcessDataTableQuantityById(DataTable dt)
        {
            DataTable clone = dt.Clone();

            foreach (DataRow row in dt.Rows)
            {
                DataRow _row = clone.AsEnumerable().Where(x => x.Field <int>("ItemId") == NullCheck.IsNullInt(row["ItemId"])).FirstOrDefault();

                if (_row == null)
                {
                    clone.Rows.Add(row.ItemArray);
                }
                else
                {
                    _row["Quantity"] = NullCheck.IsNullDecimal(_row["Quantity"]) + NullCheck.IsNullDecimal(row["Quantity"]);
                }
            }

            return(clone);
        }
示例#28
0
 public static int ZoneExists(string ZoneCode)
 {
     return(NullCheck.IsNullInt(Sql.GetString($"SELECT dbo.ValidateReceivingLocation('{GlobalUser.CurrentWarehouseId}','{ZoneCode}')")));
 }
示例#29
0
 public static int ValidatePallet(string Barcode)
 {
     return(NullCheck.IsNullInt(Sql.GetString($"SELECT dbo.ValidateBarcode('{Barcode}')")));
 }
示例#30
0
 private int GetParentNodeKey()
 {
     return(NullCheck.IsNullInt(treeView1.SelectedNode.Parent != null ? treeView1.SelectedNode.Parent.Name : treeView1.SelectedNode.Name));
 }