//Store lay du lieu
public DataTable tbDistributionDetails_GetList()
{
string procname = "tbDistributionDetails_GetList()";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
//Store lấy dữ liệu table
public DataTable tbPlan_GetList()
{
string procname = "tbPlan_GetList";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
return db.ExecuteDataTable(procname);
}
public DataTable tbLogin_Get()
{
string procname = "tbLogin_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Username", Username);
db.AddParameter("@Password", Password);
return db.ExecuteDataTable(procname);
}
public DataTable tbMaterialDetails_GetByYear()
{
string procname = "tbMaterialDetails_GetByYear";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Years", Years);
return db.ExecuteDataTable(procname);
}
//edit du lieu tu ma kho
public DataTable tbMaterial_GetbyCode()
{
string procname = "tbMaterial_GetbyCode";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@MaterialCode", MaterialCode);
return db.ExecuteDataTable(procname);
}
public DataTable tbOrder_GetAutocode()
{
string procname = "tbOrder_GetAutocode";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Year", Year);
return db.ExecuteDataTable(procname);
}
public DataTable tbOrder_Get()
{
string procname = "tbOrder_Get";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@OrderCode", OrderCode);
return db.ExecuteDataTable(procname);
}
public DataTable tbOrderDetails_FindOrder()
{
string procname = "tbOrderDetails_FindOrder";
DbAccess db = new DbAccess();
db.CreateNewSqlCommand();
db.AddParameter("@Describe", Describe);
return db.ExecuteDataTable(procname);
}