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;
}
}
public void LoadData()
{
DataTable dt = Sql.GetTable(SelectProcedure, new object[] { "@RcvOrdId", DocId });
if (dt != null && dt.Rows.Count > 0)
{
tDocNo.Text = NullCheck.IsNullString(dt.Rows[0]["DocumentNo"]);
tCreateDate.Text = NullCheck.IsNullDate(dt.Rows[0]["Created"]).ToShortDateString();
tUpdated.Text = NullCheck.IsNullDate(dt.Rows[0]["Updated"]).ToShortDateString();
LoadDView();
}
}
public void LoadData()
{
DataTable dt = Sql.GetTable(SelectProcedure, new object[] { "@WarehouseId", WarehouseId });
if (dt.Rows.Count > 0)
{
tCode.Text = NullCheck.IsNullString(dt.Rows[0]["WarehouseCode"]);
tName.Text = NullCheck.IsNullString(dt.Rows[0]["WarehouseName"]);
cWarehouseLocId.SelectedValue = NullCheck.IsNullString(dt.Rows[0]["LocationId"]);
tCreateDate.Text = NullCheck.IsNullDate(dt.Rows[0]["CreateDate"]).ToShortDateString();
tUpdated.Text = NullCheck.IsNullDate(dt.Rows[0]["UpdateDate"]).ToShortDateString();
}
}
public void LoadData()
{
DataTable dt = Sql.GetTable(SelectProcedure, new object[] { "@PalletId", WarehouseId });
if (dt.Rows.Count > 0)
{
tNumber.Text = NullCheck.IsNullString(dt.Rows[0]["WarehouseId"]);
tHeight.Text = NullCheck.IsNullString(dt.Rows[0]["PalletHeight"]);
tWidth.Text = NullCheck.IsNullDate(dt.Rows[0]["PalletWidth"]).ToShortDateString();
tLength.Text = NullCheck.IsNullDate(dt.Rows[0]["PalletLength"]).ToShortDateString();
tVolume.Text = NullCheck.IsNullDate(dt.Rows[0]["PalletVolume"]).ToShortDateString();
}
}
public void LoadData()
{
DataTable dt = Sql.GetTable(SelectProcedure, new object[] { "@PartnerId", PartnerId });
if (dt.Rows.Count > 0)
{
tPartnerCode.Text = NullCheck.IsNullString(dt.Rows[0]["PartnerCode"]);
tPartnerName.Text = NullCheck.IsNullString(dt.Rows[0]["Partnername"]);
cbCustomer.Checked = NullCheck.IsNullBoolean(dt.Rows[0]["IsCustomer"]);
cbSupply.Checked = NullCheck.IsNullBoolean(dt.Rows[0]["IsSupplier"]);
tCreated.Text = NullCheck.IsNullDate(dt.Rows[0]["Created"]).ToShortDateString();
tUpdated.Text = NullCheck.IsNullDate(dt.Rows[0]["Updated"]).ToShortDateString();
}
}
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();
}
}
public void LoadData()
{
DataTable dt = Sql.GetTable(SelectProcedure, new object[] { "@LocationID", LocationId });
if (dt.Rows.Count > 0)
{
tLocationCode.Text = NullCheck.IsNullString(dt.Rows[0]["LocationCode"]);
tCountry.Text = NullCheck.IsNullString(dt.Rows[0]["Country"]);
tCity.Text = NullCheck.IsNullString(dt.Rows[0]["City"]);
tStreetName.Text = NullCheck.IsNullString(dt.Rows[0]["StreetName"]);
tBuildingNo.Text = NullCheck.IsNullString(dt.Rows[0]["BuildingNumber"]);
tFlatNo.Text = NullCheck.IsNullString(dt.Rows[0]["FlatNumber"]);
tCreated.Text = NullCheck.IsNullDate(dt.Rows[0]["CreateDate"]).ToShortDateString();
tUpdated.Text = NullCheck.IsNullDate(dt.Rows[0]["UpdateDate"]).ToShortDateString();
}
}
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"]);
}
}
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"]);
}
}
public void LoadData()
{
DataTable dt = Sql.GetTable(SelectProcedure, new object[] { "@ItemId", ItemId });
if (dt.Rows.Count > 0)
{
tItemCode.Text = NullCheck.IsNullString(dt.Rows[0]["Code"]);
tItemName.Text = NullCheck.IsNullString(dt.Rows[0]["Name"]);
tItemDescription.Text = NullCheck.IsNullString(dt.Rows[0]["Description"]);
cItemType.SelectedValue = NullCheck.IsNullString(dt.Rows[0]["TypeId"]);
tNetWeight.Text = NullCheck.IsNullString(dt.Rows[0]["NetWeight"]);
tBrutoWeight.Text = NullCheck.IsNullString(dt.Rows[0]["BrutoWeight"]);
tVolume.Text = NullCheck.IsNullString(dt.Rows[0]["Volume"]);
cMU.SelectedValue = NullCheck.IsNullString(dt.Rows[0]["MeasureUnitId"]);
tCreateDate.Text = NullCheck.IsNullDate(dt.Rows[0]["CreateDate"]).ToShortDateString();
tUpdated.Text = NullCheck.IsNullDate(dt.Rows[0]["UpdateDate"]).ToShortDateString();
tWarehouseId.Text = NullCheck.IsNullString(dt.Rows[0]["WarehouseCode"]);
tBarcode.Text = NullCheck.IsNullString(dt.Rows[0]["Barcode"]);
tWidth.Text = NullCheck.IsNullString(dt.Rows[0]["Width"]);
tHeight.Text = NullCheck.IsNullString(dt.Rows[0]["Height"]);
}
}