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