/// <summary> /// 查詢符合盤點單號的商品資料 /// </summary> /// <param name="TakeStockID"></param> /// <returns></returns> public SIS.Configuration.TakeStockItem[] QueryData(string TakeStockID) { InitDB(); string selectCmd; selectCmd = "Select * From " + TableName + " Where TakeStockID='" + TakeStockID + "' Order by ItemsID "; try { da = new SqlDataAdapter(selectCmd, conn); DataSet ds = new DataSet(); da.Fill(ds, TableName); if (ds.Tables[TableName].Rows.Count >= 1) { SIS.Configuration.TakeStockItem[] items = null; items = new Configuration.TakeStockItem[ds.Tables[TableName].Rows.Count]; int i = 0; foreach (DataRow row in ds.Tables[TableName].Rows) { if (row["ItemsID"] != null) { SIS.Configuration.TakeStockItem oneItem = new Configuration.TakeStockItem(); oneItem.ItemsID = row["ItemsID"].ToString(); oneItem.NAME = row["NAME"].ToString(); oneItem.Inventory = int.Parse(row["Inventory"].ToString()); oneItem.TakeStockInventory = int.Parse(row["TakeStockInventory"].ToString()); oneItem.GainLossInventory = int.Parse(row["GainLossInventory"].ToString()); oneItem.IsTakeStock = bool.Parse(row["IsTakeStock"].ToString()); oneItem.ItemsUnit = row["ItemsUnit"].ToString(); oneItem.Price = int.Parse(row["Price"].ToString()); oneItem.Totals = int.Parse(row["Totals"].ToString()); oneItem.Notes = row["Notes"].ToString(); items[i] = oneItem; i = i + 1; } } conn.Close(); return(items); } else { return(null); } } catch (Exception ex) { errorMsg = ex.Message; conn.Close(); return(null); } }
/// <summary> /// 查詢所有商品項目 /// </summary> /// <param name="CTSC">傳入SIS.Configuration.ClsTakeStockConfig CTSC</param> /// <returns></returns> public bool QueryAllItems(SIS.Configuration.ClsTakeStockConfig CTSC) { int MAX = QueryItemsCount(); //先算出商品總數 InitDB(); string selectCmd; selectCmd = "Select * From " + TableName + " Order by ItemsID"; try { cmd = new SqlCommand(selectCmd, conn); dr = cmd.ExecuteReader(); int i = 0; SIS.Configuration.TakeStockItem[] takeStockItems = new Configuration.TakeStockItem[MAX]; SIS.Configuration.TakeStockItem takeStockItem; while (dr.Read()) { takeStockItem = new Configuration.TakeStockItem(); takeStockItem.ItemsID = dr["ItemsID"].ToString(); takeStockItem.NAME = dr["NAME"].ToString(); takeStockItem.Inventory = int.Parse(dr["Inventory"].ToString()); takeStockItem.TakeStockInventory = takeStockItem.Inventory; //預設盤點數量 = 庫存數量 takeStockItem.GainLossInventory = takeStockItem.Inventory - takeStockItem.TakeStockInventory; takeStockItem.IsTakeStock = false; takeStockItem.ItemsUnit = dr["ItemsUnit"].ToString(); takeStockItem.Price = int.Parse(dr["CostPrice"].ToString()); takeStockItem.Totals = takeStockItem.TakeStockInventory * takeStockItem.Price; takeStockItem.Notes = ""; takeStockItems[i] = takeStockItem; i = i + 1; } CTSC.TakeStockItems = takeStockItems; conn.Close(); return(true); } catch (Exception ex) { errorMsg = ex.Message; conn.Close(); return(false); } }