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