public DataTable getData(DateTime date_count_stock, int id_brach, int count)
{
String count_stock = date_count_stock.ToString("yyyy-MM-dd");
DataTable _dt = new DataTable();
CStatementList cstate = new CStatementList(Connection.CSQLConnection);
try
{
CSQLParameterList plist = new CSQLParameterList();
plist.Add("@Date_Count_Stock", DbType.String, count_stock, ParameterDirection.Input);
plist.Add("@ID_Brach", DbType.Int32, id_brach, ParameterDirection.Input);
plist.Add("@Rount", DbType.Int32, count, ParameterDirection.Input);
CSQLDataAdepterList adlist = new CSQLDataAdepterList();
CSQLStatementValue csv = new CSQLStatementValue(this._statememet, plist, NoomLibrary.StatementType.Select);
adlist.Add(csv);
cstate.Open();
cstate.Execute(adlist);
_dt = (DataTable)cstate.Execute(adlist);
foreach (DataRow item in _dt.Rows)
{
SpaceParts spaceParts = new SpaceParts();
spaceParts.ID_Item = item["ID_Item"].ToString();
spaceParts.Name_Item = item["Name_Item"].ToString();
spaceParts.Group_Item = item["Group_Item"].ToString();
spaceParts.Sell_Price_Unit = Convert.ToDouble(item["Sell_Price_Unit"]);
spaceParts.Sell_Price_All = Convert.ToDouble(item["Sell_Price_All"]);
spaceParts.Cost_Price_Unit = Convert.ToDouble(item["Cost_Price_Unit"]);
spaceParts.Cost_Price_All = Convert.ToDouble(item["Cost_Price_All"]);
spaceParts.Date_Count_Stock = Convert.ToDateTime(item["Date_Count_Stock"]);
spaceParts.Shelf_Main = item["Self_Main"].ToString() == null ? "" : item["Self_Main"].ToString();
//spaceParts.Round = Convert.ToInt32(item["Count_Round"]);
spaceParts.Total_Stock = Convert.ToInt32(item["Total_Stock"]);
spaceParts.Amound_Sold = Convert.ToInt32(item["Amound_Sold"]);
spaceParts.Number_Parts_Booking = Convert.ToInt32(item["Number_Parts_Booking"]);
spaceParts.Inventory_Last_Month = Convert.ToInt32(item["Inventory_Last_Month"]);
spaceParts.Count_Value = item["Get_Count"].ToString() == "" ? 0 : Convert.ToDouble(item["Get_Count"]);
spaceParts.Different = item["Count_Value"].ToString() == "" ? 0 : Convert.ToDouble(item["Count_Value"]);
spaceParts.Different_Cost = item["Cost_Count_Value"].ToString() == "" ? 0 : Convert.ToDouble(item["Cost_Count_Value"]);
}
cstate.Commit();
}
catch (Exception ex)
{
string error = ex.Message;
cstate.Rollback();
}
finally
{
cstate.Close();
}
return(_dt);
}
public bool Remove(SpaceParts item)
{
return(this.Remove(item));
}
public void Insert(int index, SpaceParts item)
{
this.Insert(index, item);
}
public int IndexOf(SpaceParts item)
{
return(this.IndexOf(item));
}
public bool Contains(SpaceParts item)
{
return(this.Contains(item));
}
public void Add(SpaceParts item)
{
this.Add(item);
}
