public V_WMS_GetWareLocationByLocID GetWarehouseLocByID(long LocationID, long WarehouseID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
V_WMS_GetWareLocationByLocID Location = new V_WMS_GetWareLocationByLocID();
Location = (from p in ce.V_WMS_GetWareLocationByLocID
where p.ID == LocationID && p.WarehouseID == WarehouseID
select p).FirstOrDefault();
return(Location);
}
public void GetLocationDetailByID(long LocationID, long WarehouseID)
{
CustomProfile profile = CustomProfile.GetProfile();
iWarehouseClient Warehouseclient = new iWarehouseClient();
V_WMS_GetWareLocationByLocID Location = new V_WMS_GetWareLocationByLocID();
Location = Warehouseclient.GetWarehouseLocByID(LocationID, WarehouseID, profile.DBConnection._constr);
if (Location.Code != null)
{
txtlocationCode.Text = Location.Code.ToString();
}
if (Location.AliasCode != null)
{
txtaliascode.Text = Location.AliasCode.ToString();
}
if (Location.SortCode != null)
{
txtsortCode.Text = Location.SortCode.ToString();
}
if (Location.Capacity != null)
{
txtcapacity.Text = Location.Capacity.ToString();
}
if (Location.LocationType != null)
{
ddllocationtype.SelectedIndex = ddllocationtype.Items.IndexOf(ddllocationtype.Items.FindByValue(Location.LocationType.ToString()));
}
if (Location.CapacityIn != null)
{
ddlcapacityin.SelectedIndex = ddlcapacityin.Items.IndexOf(ddlcapacityin.Items.FindByValue(Location.CapacityIn.ToString()));
}
if (Location.VelocityType != null)
{
ddlvelocityType.SelectedIndex = ddlvelocityType.Items.IndexOf(ddlvelocityType.Items.FindByValue(Location.VelocityType.ToString()));
}
if (Location.shelfID != null)
{
hdnShelfID.Value = Location.shelfID.ToString();
}
if (Location.Building != null)
{
txtbuilding.Text = Location.Building.ToString();
}
if (Location.Floar != null)
{
txtfloar.Text = Location.Floar.ToString();
}
if (Location.Passage != null)
{
txtpathway.Text = Location.Passage.ToString();
}
if (Location.Section != null)
{
txtsection.Text = Location.Section.ToString();
}
if (Location.Shelf != null)
{
txtshelf.Text = Location.Shelf.ToString();
}
if (Location.Active.Trim() == "Yes")
{
radiochannelY.Checked = true;
}
else
{
radiochannelN.Checked = true;
}
}
