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