| | |
| | | } |
| | | |
| | | // 3. æ¹éæ¥è¯¢chengbenxiangmuä¿¡æ¯ |
| | | string CostQuery = $"SELECT HItemID, HNumber, HName FROM Gy_ItemMoney_1 WHERE HNumber IN ({string.Join(",", CostNumbers.Select(m => $"'{m.Replace("'", "''")}'"))}) AND HName IN ({string.Join(",", CostNames.Select(m => $"'{m.Replace("'", "''")}'"))}) and HUSEORGID ={organ}"; |
| | | DataSet CostData = oCN.RunProcReturn(CostQuery, "Gy_ItemMoney_1"); |
| | | string CostQuery = $"SELECT HItemID, HNumber, HName FROM Gy_CostItem WHERE HNumber IN ({string.Join(",", CostNumbers.Select(m => $"'{m.Replace("'", "''")}'"))}) AND HName IN ({string.Join(",", CostNames.Select(m => $"'{m.Replace("'", "''")}'"))}) and HUSEORGID ={organ}"; |
| | | DataSet CostData = oCN.RunProcReturn(CostQuery, "Gy_CostItem"); |
| | | Dictionary<string, int> CostDict = new Dictionary<string, int>(); |
| | | foreach (DataRow row in CostData.Tables[0].Rows) |
| | | { |
| | |
| | | missingMaterialMessages.Add($"第{lineNumber}è¡çç产订åã{ICMOcheck}ã"); |
| | | } |
| | | // æ£æ¥é¡¹ç®ææ¬ |
| | | if (CostDict.Count == 0) |
| | | if (CostDict.Count == 0|| !CostDict.ContainsKey(Costcheck)) |
| | | { |
| | | missingCostMessages.Add($"第{lineNumber}è¡çé¡¹ç®ææ¬ã{Costcheck}ã"); |
| | | } |