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