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); }