public int getCount_Item(DateTime date_count_stock, int id_brach, int count, string type_item)
{
int countitem = 0;
DataTable _dt = new DataTable();
TreePetch treePetch = new TreePetch();
String count_stock = date_count_stock.ToString("yyyy-MM-dd");
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("@Round", DbType.Int32, count, ParameterDirection.Input);
plist.Add("@Type_Item", DbType.String, type_item, ParameterDirection.Input);
CSQLDataAdepterList adlist = new CSQLDataAdepterList();
CSQLStatementValue csv = new CSQLStatementValue(this._statememet_Count, plist, NoomLibrary.StatementType.Select);
adlist.Add(csv);
cstate.Open();
cstate.Execute(adlist);
_dt = (DataTable)cstate.Execute(adlist);
foreach (DataRow item in _dt.Rows)
{
treePetch.T_Count_Item = Convert.ToInt32(item["Count_Item"]);
countitem = Convert.ToInt32(item["Count_Item"]);
}
cstate.Commit();
}
catch (Exception ex)
{
string error = ex.Message;
cstate.Rollback();
}
finally
{
cstate.Close();
}
return(countitem);
}
public bool Remove(TreePetch item)
{
return(this.Remove(item));
}
public void Insert(int index, TreePetch item)
{
this.Insert(index, item);
}
public int IndexOf(TreePetch item)
{
return(this.IndexOf(item));
}
public bool Contains(TreePetch item)
{
return(this.Contains(item));
}
public void Add(TreePetch item)
{
this.Add(item);
}
