public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { GA1ModelVo inVo = (GA1ModelVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("update t_checkpusha90 set a90_oqc_status=:a90_oqc_status, a90_oqc_data =:a90_oqc_data "); //sql.Append("where 1 = 1 and "); sql.Append(" where a90_barcode=:a90_barcode"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("a90_oqc_data", inVo.A90OQCData); sqlParameter.AddParameter("a90_barcode", inVo.A90Barcode); sqlParameter.AddParameter("a90_oqc_status", inVo.A90OQCStatus); //execute SQL GA1ModelVo outVo = new GA1ModelVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionTestInstructionVo inVo = (InspectionTestInstructionVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete from m_inspection_test_instruction"); sqlQuery.Append(" where inspection_test_instruction_id = :inspectiontestinstructionid "); sqlQuery.Append(" and factory_cd = :faccd ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("inspectiontestinstructionid", inVo.InspectionTestInstructionId); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); InspectionTestInstructionVo outVo = new InspectionTestInstructionVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { JigCauseVo inVo = (JigCauseVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("update public.m_ncvp_jig_cause set jig_cause_cd=:jig_cause_cd,jig_cause_name=:jig_cause_name"); sql.Append(" where jig_cause_id =:jig_cause_id"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("jig_cause_cd", inVo.JigCauseCode); sqlParameter.AddParameterString("jig_cause_name", inVo.JigCauseName); sqlParameter.AddParameterInteger("jig_cause_id", inVo.JigCauseId); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL JigCauseVo outVo = new JigCauseVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldItemVo inVo = (MoldItemVo)arg; // Building SQL StringBuilder sql = new StringBuilder(); sql.Append("DELETE FROM m_gtrs_global_item_sap_item "); sql.Append(" WHERE global_item_sap_item_id=:globalitemsapitemid"); sql.Append(" AND factory_cd=:factorycd"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("globalitemsapitemid", inVo.GlobalLocalItemId); sqlParameter.AddParameterString("factorycd", trxContext.UserData.FactoryCode); //execute SQL MoldItemVo outVo = new MoldItemVo(); outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("Update m_prodution_work_content_type_master set prodution_work_content_type_cd=:prodution_work_content_type_cd,prodution_work_content_type_name=:prodution_work_content_type_name"); sql.Append(" where prodution_work_content_type_id=:prodution_work_content_type_id"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode); sqlParameter.AddParameterString("prodution_work_content_type_name", inVo.ProdutionWorkContentTypeName); sqlParameter.AddParameterInteger("prodution_work_content_type_id", inVo.ProdutionWorkContentTypeId); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RangeVo inVo = (RangeVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("delete from m_ovenmachine_range Where 1=1 "); if (inVo.RangeId > 0) { sql.Append(" and ovenmachine_range_id = :ovenmachine_range_id "); sqlParameter.AddParameterInteger("ovenmachine_range_id", inVo.RangeId); } //create command sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL RangeVo outVo = new RangeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RankVo inVo = (RankVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("update m_rank set rank_cd=:rank_cd,rank_name=:rank_name"); sql.Append(" where rank_id =:rank_id"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("rank_cd", inVo.RankCode); sqlParameter.AddParameterString("rank_name", inVo.RankName); sqlParameter.AddParameterInteger("rank_id", inVo.RankId); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL RankVo outVo = new RankVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CavityVo inVo = (CavityVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_cavity"); sqlQuery.Append(" Set "); sqlQuery.Append(" cavity_name = :cavityname, "); sqlQuery.Append(" mold_id = :moldid "); sqlQuery.Append(" Where "); sqlQuery.Append(" cavity_id = :cavityid ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("cavityid", inVo.CavityId); sqlParameter.AddParameterString("cavityname", inVo.CavityName); sqlParameter.AddParameterInteger("moldid", inVo.MoldId); CavityVo outVo = new CavityVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { GA1ModelVo inVo = (GA1ModelVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("insert into t_box_id(boxid, printdate, user_cd) "); sql.Append("values(:boxid, now(), :user_cd)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("boxid", inVo.BoxID); sqlParameter.AddParameter("printdate", inVo.PrintDate); sqlParameter.AddParameter("user_cd", inVo.User); //execute SQL GA1ModelVo outVo = new GA1ModelVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { IPQCVo inVo = (IPQCVo)vo; StringBuilder sql = new StringBuilder(); IPQCVo voList = new IPQCVo(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("delete from tbl_measure_item where no = '" + inVo.No + "' and model = '" + inVo.Model + "' and inspect = '" + inVo.Inspect + "' and process = '" + inVo.Process + "'"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); IPQCVo outVo = new IPQCVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionItemSelectionDatatypeValueVo inVo = (InspectionItemSelectionDatatypeValueVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_inspection_item_selection_datatype_value"); sqlQuery.Append(" Set inspection_item_id = :itemid "); sqlQuery.Append(" where factory_cd = :faccd "); sqlQuery.Append(" and UPPER(inspection_item_selection_datatype_value_cd) like UPPER(:inspectionitemselectiondatatypevaluecd) "); sqlQuery.Append(" and inspection_item_id = 0 ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameterString("inspectionitemselectiondatatypevaluecd", inVo.InspectionItemCode + "%"); sqlParameter.AddParameterInteger("itemid", inVo.InspectionItemId); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { IPQCVo inVo = (IPQCVo)vo; //Insert StringBuilder sql = new StringBuilder(); sql.Append("INSERT INTO tbl_measure_item(no, model, process, inspect, description, upper, lower, instrument, clm_set, row_set) VALUES (:no, :model, :process, :inspect, :description, :upper, :lower, :instrument, :clm_set, :row_set)"); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("no", inVo.No); sqlParameter.AddParameter("model", inVo.Model); sqlParameter.AddParameter("process", inVo.Process); sqlParameter.AddParameter("inspect", inVo.Inspect); sqlParameter.AddParameter("description", inVo.Description); sqlParameter.AddParameter("upper", inVo.Upper); sqlParameter.AddParameter("lower", inVo.Lower); sqlParameter.AddParameter("instrument", inVo.Instrument); sqlParameter.AddParameter("clm_set", inVo.ClmSet); sqlParameter.AddParameter("row_set", inVo.RowSet); IPQCVo outVo = new IPQCVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { EquipmentVo inVo = (EquipmentVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_equipment"); sqlQuery.Append(" Set "); sqlQuery.Append(" equipment_name = :equipmentname , "); sqlQuery.Append(" instration_dt = :instrationdt , "); sqlQuery.Append(" asset_no = :assetno , "); sqlQuery.Append(" manufacturer = :manufacturer , "); sqlQuery.Append(" model_name = :modelname , "); sqlQuery.Append(" model_cd = :modelcd "); sqlQuery.Append(" Where "); sqlQuery.Append(" equipment_id = :equipmentid "); sqlQuery.Append(" and factory_cd = :faccd ;"); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("equipmentid", inVo.EquipmentId); sqlParameter.AddParameterString("equipmentname", inVo.EquipmentName); sqlParameter.AddParameterDateTime("instrationdt", inVo.InstrationDate); sqlParameter.AddParameterString("assetno", inVo.AssetNo); sqlParameter.AddParameterString("manufacturer", inVo.Manufacturer); sqlParameter.AddParameterString("modelname", inVo.ModelName); sqlParameter.AddParameterString("modelcd", inVo.ModelCode); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); EquipmentVo outVo = new EquipmentVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { MoldDetailVo inVo = (MoldDetailVo)vo; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append(" Update m_local_item "); sqlQuery.Append(" SET "); sqlQuery.Append(" item_cd = :item_code ,"); sqlQuery.Append(" item_name = :item_name ,"); sqlQuery.Append(" registration_user_cd = :registration_user_code ,"); sqlQuery.Append(" registration_date_time = now() "); sqlQuery.Append(" Where "); sqlQuery.Append(" item_id = :id; "); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("id", inVo.MoldItemId); sqlParameter.AddParameterString("item_code", inVo.MoldItemCode); sqlParameter.AddParameterString("item_name", inVo.MoldItemCode); sqlParameter.AddParameterString("registration_user_code", UserData.GetUserData().UserCode); MoldDetailVo outVo = new MoldDetailVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { WareHouseMainVo inVo = (WareHouseMainVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(@"update t_warehouse_main set current_depreciation =:current_depreciation, monthly_depreciation=:monthly_depreciation, accum_depreciation_now =:accum_depreciation_now, net_value =:net_value "); sql.Append(" where warehouse_main_id =:warehouse_main_id"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("warehouse_main_id", inVo.WareHouseMainId); sqlParameter.AddParameter("current_depreciation", inVo.CurrentDepreciation); sqlParameter.AddParameter("monthly_depreciation", inVo.MonthlyDepreciation); sqlParameter.AddParameter("accum_depreciation_now", inVo.AccumDepreciation); sqlParameter.AddParameter("net_value", inVo.NetValue); //execute SQL WareHouseMainVo outVo = new WareHouseMainVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ShelfVo inVo = (ShelfVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_shelf"); sqlQuery.Append(" Set "); sqlQuery.Append(" shelf_name = :shelfname, "); sqlQuery.Append(" area_id = :areaid "); sqlQuery.Append(" Where "); sqlQuery.Append(" shelf_id = :shelfid ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("shelfid", inVo.ShelfId); sqlParameter.AddParameterString("shelfname", inVo.ShelfName); sqlParameter.AddParameterInteger("areaid", inVo.AreaId); ShelfVo outVo = new ShelfVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { GroupMachineVo inVo = (GroupMachineVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("delete from m_group_machine Where 1=1 "); if (!String.IsNullOrEmpty(inVo.FactoryCode)) { sql.Append(" and factory_cd = :factory_cd "); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); } if (!string.IsNullOrEmpty(inVo.GroupMachineName)) { sql.Append(" and group_machine_name = :group_machine_name "); sqlParameter.AddParameterString("group_machine_name", inVo.GroupMachineName); } //create command sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL GroupMachineVo outVo = new GroupMachineVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MachineVo inVo = (MachineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete From m_machine"); sqlQuery.Append(" Where "); sqlQuery.Append(" machine_id = :machineid"); sqlQuery.Append(" and factory_cd = :faccd ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("machineid", inVo.MachineId); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); MachineVo outVo = new MachineVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CountryLanguageVo inVo = (CountryLanguageVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete from m_country_language"); sqlQuery.Append(" Where "); sqlQuery.Append(" country = :country "); sqlQuery.Append(" and "); sqlQuery.Append(" language = :language ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("country", inVo.Country); sqlParameter.AddParameterString("language ", inVo.Language); CountryLanguageVo outVo = new CountryLanguageVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { AccountLocationVo inVo = (AccountLocationVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("insert into m_account_location(account_location_cd, account_location_name, account_location_type, registration_user_cd, registration_date_time, factory_cd) "); sql.Append("values(:account_location_cd,:account_location_name,:account_location_type, :registration_user_cd,now(),:factory_cd)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("account_location_cd", inVo.AccountLocationCode); sqlParameter.AddParameterString("account_location_name", inVo.AccountLocationName); sqlParameter.AddParameterString("account_location_type", inVo.AccountLocationType); // sqlParameter.AddParameterDateTime("registration_user_cd", inVo.RegistrationDateTime); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL AccountLocationVo outVo = new AccountLocationVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { UserLocationVo inVo = (UserLocationVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("update m_user_location set user_location_cd=:user_location_cd,user_location_name=:user_location_name, dept_cd=:dept_cd"); sql.Append(" where user_location_id =:user_location_id"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("user_location_cd", inVo.UserLocationCode); sqlParameter.AddParameterString("user_location_name", inVo.UserLocationName); sqlParameter.AddParameterInteger("user_location_id", inVo.UserLocationId); sqlParameter.AddParameterString("dept_cd", inVo.DeptCode); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL Vo.UserLocationVo outVo = new Vo.UserLocationVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { StockLocationVo inVo = (StockLocationVo)arg; StockLocationVo outVo = new StockLocationVo(); StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_stock_location"); sqlQuery.Append(" Set "); sqlQuery.Append(" stock_location_name = :stock_locationname, "); sqlQuery.Append(" location_type = :locationtype, "); sqlQuery.Append(" display_order = :displayorder "); sqlQuery.Append(" Where "); sqlQuery.Append(" stock_location_id = :stock_locationid "); sqlQuery.Append(" and factory_cd = :faccd ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("stock_locationid", inVo.StockLocationId); sqlParameter.AddParameterString("stock_locationname", inVo.StockLocationName); sqlParameter.AddParameterInteger("locationtype", inVo.LocationType); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); //execute SQL outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessStockLocationVo inVo = (ProcessStockLocationVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Delete from m_process_stocklocation"); sqlQuery.Append(" where factory_cd = :faccd "); sqlQuery.Append(" AND process_id = :processid"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameterInteger("processid", inVo.ProcessId); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RateNGVo inVo = (RateNGVo)vo; StringBuilder sql = new StringBuilder(); RateNGVo voList = new RateNGVo(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("insert into m_rate_ng (rate_ng_cd, rate_ng_model, rate_ng_line , rate_ng_ratio) "); sql.Append("values (:rate_ng_cd, :rate_ng_model, :rate_ng_line , :rate_ng_ratio) "); sqlParameter.AddParameter("rate_ng_cd", inVo.RateCode); sqlParameter.AddParameter("rate_ng_model", inVo.RateModel); sqlParameter.AddParameter("rate_ng_line", inVo.RateLine); sqlParameter.AddParameter("rate_ng_ratio", inVo.RateRatio); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL voList = new RateNGVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter), }; return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { WarehouseVTListVo inVo = (WarehouseVTListVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(@"insert into t_vt_datalost(rfid, machine_serial, check_time, command) "); sql.Append(@"values(:rfid, :machine_serial, :check_time, :command)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("rfid", inVo.RFId); sqlParameter.AddParameter("machine_serial", inVo.MachineSerial); sqlParameter.AddParameter("check_time", inVo.CheckTime); sqlParameter.AddParameter("command", inVo.Comment); WarehouseVTListVo outVo = new WarehouseVTListVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ItemProcessWorkVo inVo = (ItemProcessWorkVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_item_process_work"); sqlQuery.Append(" Set "); sqlQuery.Append(" item_id = :itemid, "); sqlQuery.Append(" is_optional_process = :optionalflg, "); sqlQuery.Append(" skip_prevention_flg = :skippreventionflg, "); sqlQuery.Append(" work_order = :workorder, "); sqlQuery.Append(" process_flow_rule_id = :processflowruleid "); sqlQuery.Append(" Where "); sqlQuery.Append(" item_process_work_id = :itemprocessworkid"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("itemid", inVo.ItemId); sqlParameter.AddParameterString("optionalflg", inVo.OptionalProcessFlag); sqlParameter.AddParameterInteger("skippreventionflg", inVo.SkipPreventionFlag); sqlParameter.AddParameterInteger("workorder", inVo.WorkOrder); sqlParameter.AddParameterInteger("processflowruleid", inVo.ProcessFlowRuleId); sqlParameter.AddParameterInteger("itemprocessworkid", inVo.ItemProcessWorkId); ItemProcessWorkVo outVo = new ItemProcessWorkVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ModelVo inVo = (ModelVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("insert into public.m_model(model_cd, model_name, registration_user_cd, registration_date_time, factory_cd) "); sql.Append("values(:model_cd,:model_name, :registration_user_cd,now(),:factory_cd)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("model_cd", inVo.ModelCode); sqlParameter.AddParameterString("model_name", inVo.ModelName); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); //execute SQL ModelVo outVo = new ModelVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionItemSelectionDatatypeValueVo inVo = (InspectionItemSelectionDatatypeValueVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_inspection_item_selection_datatype_value"); sqlQuery.Append(" Set "); sqlQuery.Append(" inspection_item_selection_datatype_value_text = :datatypevaluetext, "); sqlQuery.Append(" display_order = :displayorder "); sqlQuery.Append(" where factory_cd = :faccd "); sqlQuery.Append(" and inspection_item_selection_datatype_value_id = :datatypeid ;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameterInteger("datatypeid", inVo.InspectionItemSelectionDatatypeValueId); sqlParameter.AddParameterString("datatypevaluetext", inVo.InspectionItemSelectionDatatypeValueText); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { FactoryVo inVo = (FactoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_factory"); sqlQuery.Append(" set "); sqlQuery.Append(" factory_name ="); sqlQuery.Append(" :factnm "); sqlQuery.Append(" Where "); sqlQuery.Append(" factory_cd ="); sqlQuery.Append(" :factcd"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factcd", inVo.FactoryCode); sqlParameter.AddParameterString("factnm", inVo.FactoryName); FactoryVo outVo = new FactoryVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { WarehouseVTVo inVo = (WarehouseVTVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(@"update m_ncvp set ncvp_cd =:ncvp_cd"); // // , // // //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameter("ncvp_cd", inVo.MacLocal); //execute SQL WarehouseVTVo outVo = new WarehouseVTVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }