public DataTable LoadDesigners() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [Idx],CONCAT([fname] ,' - ',[EpfNo]) as usrInfo FROM [dbo].[Auth_Users] where SectionId=350")); } }
public DataSet LoadData() { { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("LoadShipment", objDIc)); } }
public DataTable LoadPlanData() { { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDatatableBySP("LoadPlanOrder", objDIc)); } }
public DataTable LoadFabForPO() { { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDatatableBySP("LoadForFabCon", objDIc)); } }
public DataSet SelectMastItmsCat() { { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("_Merchandiser_Select_Itms_Cat", objDIc)); } }
public DataTable LoadSubItems(int itm_id) { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT sb_itm_id, word FROM [erpWarehouse].[dbo].[load_view_itmsub] WHERE (itm_id= '" + itm_id.ToString() + "')")); } }
public DataSet Load_Mast_data() { { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("Merchandiser_Loadt_Mast", objDIc)); } }
public DataTable LoadingInvTyp() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [id] ,[inv_typ] ,[IsActive] FROM [dbo].[_Mechandiser_MAST_Inv_typ]")); } }
public DataTable LoadingPaymntTrms() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [id],[Pay_terms] ,[IsActive] FROM [dbo].[_Merchandiser_MAST_Pymnt_terms]")); } }
public DataTable LoadBuyerCatergory() { { //var objDIc = new Dictionary<string, object>(); SELECT [Idx],[id] ,[buyer] ,[buyer_category],[buyer_code] ,[buyer_po_code]FROM [dbo].[VIEW_Merchandiser_Buyer_details] return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [Idx],[id] ,[buyer] ,[buyer_category],[buyer_code] ,[buyer_po_code] ,[address1],[address2],[address3],[city] ,[state] ,[postal_code] ,[country],[invoice_name],[invoice_address1] ,[invoice_address2] ,[invoice_address3] ,[contract_title],[contract_name],[email_address],[m_num] ,[p_num],[extention] ,[port] ,[c_account_no],[vat],[svat] ,[fax_no],[paymnt_terms] ,[Pay_terms],[currency] ,[credit_limit],[payment_name],[paymnt_email],[paymnt_mobile_no],[email_paymnt_inv] ,[email_shipment] ,[shipment_terms] ,[shipmet_terms],[inv_typ],[invtyp],[img1],[img2],[img3],[img4] FROM [dbo].[VIEW_Merchandiser_Buyer_details]")); } }
public DataTable LoadBuyer() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [Idx],[id] ,[buyer] ,[buyer_category],[buyer_code] ,[buyer_po_code]FROM [dbo].[VIEW_Merchandiser_Buyer_details]")); } }
public DataSet Load_MAST_Type() { { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("_Get_Merch_MAST_SMVData", objDIc)); } }
public DataSet LoadCostingDt() { { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("_Merchandiser_costing_details", objDIc)); } }
public DataTable LoadPrintmachinRep() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [Idx] ,[id],[machine_mode],[serial_no],CONVERT(DATE,[purchase_date]) as purchase_date,[purch_value],[supplier] ,[owner],[ip_address],[img] ,0 as cs ,[machine_no] FROM [dbo].[_PrintSec_machine] order by id")); } }
public DataTable LoadAssignSparemachn() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT sp.[idx] ,sp.[id] ,sp.[machineIdx],prntmchn.[machine_mode],prntmchn.[serial_no],sp.[assigndate] ,sp.[spartsId] ,sp.[spartsname] ,sp.[spartSerialNo],sp.[pcount],sp.[isActive] FROM [dbo].[_PrintSec_machine_spareparts] sp INNER JOIN [dbo].[_PrintSec_machine] prntmchn on sp.[machineIdx]=prntmchn.Idx")); } }
public DataSet Load_req_fab_info() {//_Load_warehouse_req_fab_info { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("_Load_warehouse_req_fab_info", objDIc)); } }
public DataTable LoadItems() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT itm_id,CONCAT(sup_item_code,' - ' ,sup_item_nme) as itmnms , sup_item_code,sup_item_nme FROM [erpWarehouse].[dbo].[itm_lgr_transa_stock] WHERE (isdeleted = 0) AND (actve = 1) and ([cat_id]=1094 or [cat_id]=8 ) order by itm_id")); } }
public DataTable LoadSizes() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [sizes_category_id],[size_names],[sort_ordr] FROM [dbo].[mercha_size_master_breakdown]")); } }
public DataTable Get_Items_Cat() { { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDatatableBySP("_Itms_cate_sub_master", objDIc)); } }
public DataTable SavePrintDt() { string pc_name = Environment.MachineName; UserName = Environment.UserName; string Usr = UserName.ToString() + "/" + pc_name.ToString(); { var objDIc = new Dictionary <string, object> { { "Trns_Date", Trns_Date }, { "PlantId", PlantId }, { "PrintSecId", PrintSecId }, { "roomId", roomId }, { "OrdId", OrdId }, { "size", sizeRn }, { "Prod_Qnty", Prod_Qnty }, { "Prod_Shift", Prod_Shift }, { "printComment", printComment }, { "ProdOption", ProdOption }, //{"Psection",Psection}, { "CreatedBy", CreatedBy } }; return((new DbAccess(CommonData.ConStr())).LoadDatatableBySP("SavePrintOrder", objDIc)); } }
public DataSet Load_PatternDt_data() { { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("Get_Pattern_dt", objDIc)); } }
public DataTable LoadSparepart() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [sb_itm_id] ,[sb_itm_nme] ,[itm_id],[stock_qty],([stock_qty]-[sqnty]) as sqnty , 0 as expanded,[img],[blncqnty] FROM [erpWarehouse].[dbo].[itm_lgr_transa_stock$sub] where (itm_id=6043 or itm_id=6010) and [stock_qty] >0 order by itm_id")); } }
public DataTable LoadingPatten() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("Select DISTINCT pattern_id,CONCAT( pattern_name ,' - ', pattern_description )as pttn from dbo.system_view_mercha_podata where despathed_date between (SELECT CONVERT ( date, DATEADD(M, DATEDIFF(M, 0, GETDATE()) -2, 20))) and (SELECT CONVERT ( date, DATEADD(M, DATEDIFF(M, 0, GETDATE()) +3, 0)))")); } }
public DataTable LoadSpartSerial() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [idx],[spart_serial_Idx],[itm_id],[sb_itm_id] ,[stock_qty],[s_qty] ,[serial_no] ,[sb_itm_nme],[isActive] FROM [dbo].[VIEW_Print_Sec_sparepart_Serial]")); } }
public DataSet LoadFabByPttn() { { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("FabConsumBypttn", objDIc)); } }
public DataTable LoadColor() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [idx],[id] ,[colors],[isActive] FROM [dbo].[_PrintSec_machine_colors] order by id")); } }
public DataSet GetAllInvoice() { { var objDIc = new Dictionary <string, object>(); return((new DbAccess(CommonData.ConStr())).LoadDataSetBySP("AllInvBill", objDIc)); } }
public DataTable LoadUnit() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [id],[unit] FROM [dbo].[_PrintSec_Units]")); } }
public DataTable LoadSublimct() { { //var objDIc = new Dictionary<string, object>(); return((new DbAccess(CommonData.ConStr())).FillDataTable("SELECT [subli_cat_id],[sublimation_category]FROM [dbo].[mercha_prodct_master_sublimacat]")); } }
public DataTable Date_SecPlanSave() { { var objDIc = new Dictionary <string, object> { // {"designPln_date",designPln_date}, // {"printingPln_date",printingPln_date}, // {"hPrintingPln_date",hPrintingPln_date}, // {"devPln_date",devPln_date}, // // {"scPritingPln_date",scPritingPln_date}, // {"reCutPln_date",reCutPln_date}, //// {"cutPln_date",cutPln_date}, // // {"diCutPln_date",diCutPln_date}, // {"packingPln_date",packingPln_date}, // // {"embPln_date",embPln_date}, // {"sewPln_date",sewPln_date}, // {"tp_date",tp_date}, // {"tc_date",tc_date}, // {"num_date",num_date}, // {"inp_date",inp_date}, { "pln_sec", new pln_sec("").InvItemListToDataTable(pln_sec) }, { "planItem", new planItem("").InvItemListToDataTable(planItem) }, { "Usr", Usr } }; return((new DbAccess(CommonData.ConStr())).LoadDatatableBySP("Plan_section_wise", objDIc)); } }