public DataTable GetWrkproductDetais()
{
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [spr_idx],[wid] ,[sprTime],[cal_imp],[count_hr],[pcs],[sty_id],[sty_nme],[so_id] ,[so_no],[fab_color] ,[impress],[ups],[sprdate],[worker],[wrk_date],[work_hr_strt],[work_hr_end] FROM [dbo].[VIEW_Spr_work_product_dt] where [wrk_date]=CONVERT(DATE,GETDATE())"));
}
public DataTable GetWrkhour()
{
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [id],[trns_id],[worker] ,[img] ,[wrk_date] ,[work_hr_strt],[work_hr_end] FROM [dbo].[VIEW_Screen_Print_wrk_hr_details] where [wrk_date]=CONVERT(DATE,GETDATE())"));
}
public DataTable GetItmsCater()
{
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [id],[mst_nme] FROM [dbo].[_Merchandiser_MAST_itms_catergory]"));
}
public DataTable GetItms()
{
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [itm_id],[sup_item_code] ,[sup_item_nme],[sb_itm_id],[sb_itm_nme],[cat_id],[cat_name] ,[stock_qty] ,[unit_id],[unit_name],[unit_name] as unit,0 as cs ,0 as consm ,CONCAT([sup_item_nme],' - ',[sb_itm_nme],' - ',[cat_name]) as itms , CONCAT([sup_item_code],' - ', [sup_item_nme],' - ',[sb_itm_nme]) AS fabitm ,0 as consum FROM [erpWarehouse].[dbo].[VIEW_Item_details]"));
}
public DataTable Loadpatterns()
{
{
return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [pattern_id] ,[pattern_name] ,[pattern_description]FROM [dbo].[develp_master_pattern]"));
}
}
public DataTable LoadUsers()
{
return((new DbAccess(CommonData.ConStr())).FillDataTable(" SELECT [Idx],[Id] ,[fname], [lname],[Username],[SectionId],[Plant_Id] ,[IsActive] FROM [dbo].[Auth_Users]"));
}
