public static string CheckSKUInPlan(string SKUCode, string CycleHeadID, string WarehouseID, string Object, string locationID)
{
string result = "";
string SKU = "";
long Count;
long SKUId = 0;
iCycleCountClient cycle = new iCycleCountClient();
CustomProfile profile = CustomProfile.GetProfile();
try
{
SKUId = cycle.GetSKUIDBySKUCode(SKUCode.Trim(), long.Parse(WarehouseID), profile.DBConnection._constr);
SKU = SKUId.ToString();
if (SKUId != 0)
{
Count = cycle.CheckLocInPlann(Object, long.Parse(CycleHeadID), SKUId, profile.DBConnection._constr);
if (Count <= 0)
{
result = "Not In Plan";
}
}
else
{
result = "SKU Not Found";
}
result = result + "-" + SKU;
}
catch { }
finally
{
cycle.Close();
}
return(result);
}
public static string CheckLocInPlan(string LocationCode, string CycleHeadID, string WarehouseID, string Object)
{
string result = "";
string Location = "";
long Count;
long LocationID = 0;
iCycleCountClient cycle = new iCycleCountClient();
CustomProfile profile = CustomProfile.GetProfile();
try
{
LocationID = cycle.GetLocationID(LocationCode.Trim(), long.Parse(WarehouseID), profile.DBConnection._constr);
Location = LocationID.ToString();
if (LocationID != 0)
{
Count = cycle.CheckLocInPlann(Object, long.Parse(CycleHeadID), LocationID, profile.DBConnection._constr);
if (Count <= 0)
{
result = "Not In Plan";
}
}
else
{
result = "Location Not Found";
}
result = result + "-" + Location;
}
catch { }
finally
{
cycle.Close();
}
return(result);
}