public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { JigCauseVo inVo = (JigCauseVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("Select Count(*) as JigCauseCount "); sql.Append(" from public.m_jig_cause"); sql.Append(" 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.JigCauseCode)) { sql.Append(" and UPPER(jig_cause_cd) = UPPER(:jig_cause_cd) "); sqlParameter.AddParameterString("jig_cause_cd", inVo.JigCauseCode); } if (inVo.JigCauseId > 0) { sql.Append(" and jig_cause_id != :jig_cause_id "); ///????? sqlParameter.AddParameterInteger("jig_cause_id", inVo.JigCauseId); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); JigCauseVo outVo = new JigCauseVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["JigCauseCount"].ToString()); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { FactoryProductionDaysVo inVo = (FactoryProductionDaysVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append(" SELECT "); sqlQuery.Append(" Count(*) AS FactoryProductionDaysCount "); sqlQuery.Append(" FROM "); sqlQuery.Append(" m_factory_production_days "); sqlQuery.Append(" WHERE 1 = 1 "); sqlQuery.Append(" AND UPPER(factory_cd) = UPPER(:factorycode) "); sqlQuery.Append(" AND building_id = :buildingid "); sqlQuery.Append(" AND year = :iyear "); sqlQuery.Append(" AND month = :imonth "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factorycode", inVo.FactoryCode); sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId); sqlParameter.AddParameterInteger("iyear", inVo.iYear); sqlParameter.AddParameterInteger("imonth", inVo.iMonth); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); FactoryProductionDaysVo outVo = new FactoryProductionDaysVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["FactoryProductionDaysCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ItemVo inVo = (ItemVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as ItemCount from m_local_item "); sqlQuery.Append(" where factory_cd = :faccd "); if (inVo.ItemCode != null) { sqlQuery.Append(" and UPPER(item_cd) = UPPER(:itemcd)"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.ItemCode != null) { sqlParameter.AddParameterString("itemcd", inVo.ItemCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ItemVo outVo = new ItemVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["ItemCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkMachineVo inVo = (ProcessWorkMachineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as WorkCount from m_processwork_machine"); sqlQuery.Append(" where factory_cd = :faccd "); if (inVo.MachineId >= 0) { sqlQuery.Append(" and machine_id = :machineid"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.MachineId >= 0) { sqlParameter.AddParameterInteger("machineid", inVo.MachineId); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ProcessWorkMachineVo outVo = new ProcessWorkMachineVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["WorkCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { SapItemSearchVo inVo = (SapItemSearchVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("SELECT "); sqlQuery.Append(" si.sap_matnr_item_cd, "); sqlQuery.Append(" CONCAT(si.sap_matnr_item_cd, ' - ', si.sap_maktx_item_name) as sap_maktx_item_name"); sqlQuery.Append(" FROM sap_item si"); sqlQuery.Append(" WHERE si.factory_cd = :factorycode ORDER BY si.sap_matnr_item_cd "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); //execute SQL ValueObjectList <SapItemSearchVo> outVo = null; IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { SapItemSearchVo currVo = new SapItemSearchVo(); currVo.SapItemCode = ConvertDBNull <string>(dataReader, "sap_matnr_item_cd"); currVo.SapItemName = ConvertDBNull <string>(dataReader, "sap_maktx_item_name"); if (outVo == null) { outVo = new ValueObjectList <SapItemSearchVo>(); } outVo.add(currVo); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CustomerVo inVo = (CustomerVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as CuCount from m_customer "); sqlQuery.Append(" where 1 = 1 "); if (inVo.CustomerCode != null) { sqlQuery.Append(" and UPPER(customer_cd) = UPPER(:cucode) "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.CustomerCode != null) { sqlParameter.AddParameterString("cucode", inVo.CustomerCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); CustomerVo outVo = new CustomerVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["CuCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("Select Count(*) as CountNum "); sql.Append(" from m_work_content_type"); sql.Append(" 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.ProdutionWorkContentTypeCode)) { sql.Append(" and UPPER(work_content_type_cd) = UPPER(:prodution_work_content_type_cd) "); sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode); } if (inVo.ProdutionWorkContentTypeId > 0) { sql.Append(" and work_content_type_id != :prodution_work_content_type_id "); sqlParameter.AddParameterInteger("prodution_work_content_type_id", inVo.ProdutionWorkContentTypeId); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["CountNum"].ToString()); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { AccountInfoVo inVo = (AccountInfoVo)vo; StringBuilder sql = new StringBuilder(); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("Select * from t_account_main where 1=1 "); sql.Append("and account_main_id ='").Append(inVo.account_main_id).Append("' "); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); sql.Clear(); //EXECUTE READER FROM COMMAND IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (datareader.Read()) { inVo.asset_id = (int)datareader["asset_id"]; inVo.qty = (int)datareader["qty"]; inVo.unit_id = (int)datareader["unit_id"]; inVo.account_code_id = (int)datareader["account_code_id"]; inVo.account_location_id = (int)datareader["account_location_id"]; inVo.rank_id = (int)datareader["rank_id"]; inVo.comment_data = datareader["comment_data"].ToString(); inVo.depreciation_start = (DateTime)datareader["depreciation_start"]; inVo.depreciation_end = (DateTime)datareader["depreciation_end"]; inVo.current_depreciation = (double)datareader["current_depreciation"]; inVo.monthly_depreciation = (double)datareader["monthly_depreciation"]; inVo.accum_depreciation = (double)datareader["accum_depreciation_now"]; inVo.net_value = (double)datareader["net_value"]; inVo.location_id = (int)datareader["location_id"]; inVo.user_location_id = (int)datareader["user_location_id"]; inVo.registration_user_cd = datareader["registration_user_cd"].ToString(); inVo.registration_date_time = (DateTime)datareader["registration_date_time"]; inVo.factory_cd = datareader["factory_cd"].ToString(); inVo.invertory_time_id = (int)datareader["invertory_time_id"]; } datareader.Close(); return(inVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldCategoryVo inVo = (MoldCategoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("select count(mc.mold_category_cd) as CategoryCount from m_mold_detail md"); sqlQuery.Append(" inner join m_mold_category mc on mc.mold_category_id = md.mold_category_id"); sqlQuery.Append(" where mc.factory_cd = :factorycode "); if (inVo.MoldCategoryCode != null) { sqlQuery.Append(" and UPPER(mold_category_cd) = UPPER(:moldcategorycd) "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); if (inVo.MoldCategoryCode != null) { sqlParameter.AddParameterString("moldcategorycd", inVo.MoldCategoryCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); MoldCategoryVo outVo = new MoldCategoryVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32("0" + dataReader["CategoryCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldTypeVo inVo = (MoldTypeVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("select Count(mo.mold_cd) as MoldCount from m_mold_type mt"); sqlQuery.Append(" inner join m_mold mo on mt.mold_type_id = mo.mold_type_id"); sqlQuery.Append(" where 1 = 1 "); if (inVo.MoldTypeCode != null) { sqlQuery.Append(" and UPPER(mold_type_cd) = UPPER(:moldtypecd)"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.MoldTypeCode != null) { sqlParameter.AddParameterString("moldtypecd", inVo.MoldTypeCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); MoldTypeVo outVo = new MoldTypeVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32("0" + dataReader["MoldCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { WarehouseVTVo inVo = (WarehouseVTVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <WarehouseVTVo> voList = new ValueObjectList <WarehouseVTVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select Count(*) as count from t_vt_machine where 1=1 "); sql.Append(" and machine_serial =:machine_serial"); sqlParameter.AddParameter("machine_serial", inVo.MachineSerial); if (!String.IsNullOrEmpty(inVo.RFId)) { sql.Append(@" or rfid_cd =:rfid_cd"); sqlParameter.AddParameter("rfid_cd", inVo.RFId); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { WarehouseVTVo outVo = new WarehouseVTVo { CheckCountID = dataReader["count"].ToString(), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { DocumentVo inVo = (DocumentVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <DocumentVo> voList = new ValueObjectList <DocumentVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"SELECT document_cd from t_document where 1 = 1"); if (!String.IsNullOrEmpty(inVo.DocumentType)) { sql.Append(" and document_type =:document_type "); sqlParameter.AddParameterString("document_type", inVo.DocumentType); } sql.Append(" and model_id =:model_id "); sqlParameter.AddParameterInteger("model_id", inVo.ModelID); sql.Append(" order by document_cd"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { DocumentVo outVo = new DocumentVo { DocumentCode = dataReader["document_cd"].ToString() }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select sapusr.mes_user_cd,sapusr.sap_user,sapusr.sap_password"); sqlQuery.Append(" from m_sap_user sapusr"); sqlQuery.Append(" inner join m_mes_user usr on usr.user_cd = sapusr.mes_user_cd"); sqlQuery.Append(" inner join m_user_factory uf on usr.user_cd = uf.user_cd"); sqlQuery.Append(" where usr.user_cd = :usercode "); sqlQuery.Append(" and uf.factory_cd = :factorycode "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("usercode", trxContext.UserData.UserCode); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); SapUserVo outVo = null; while (dataReader.Read()) { outVo = new SapUserVo(); outVo.MesUserCode = DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["mes_user_cd"]); outVo.SapUser = DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["sap_user"]); outVo.SapPassWord = DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["sap_password"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { DefectiveCategoryVo inVo = (DefectiveCategoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as DefectiveCategoryCount from m_defective_category "); sqlQuery.Append(" where 1 = 1 "); if (inVo.DefectiveCategoryCode != null) { sqlQuery.Append(" and UPPER(defective_category_cd) = UPPER(:defectiveCategorycd)"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.DefectiveCategoryCode != null) { sqlParameter.AddParameterString("defectiveCategorycd", inVo.DefectiveCategoryCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); DefectiveCategoryVo outVo = new DefectiveCategoryVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["DefectiveCategoryCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessWorkVo inVo = (ProcessWorkVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as DisplayCount from m_process_work"); sqlQuery.Append(" where 1 = 1 "); if (inVo.ProcessWorkCode != null) { sqlQuery.Append(" and display_order = :displayorder"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.DisplayOrder > 0) { sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ProcessWorkVo outVo = new ProcessWorkVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["DisplayCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { GA1ModelVo inVo = (GA1ModelVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <GA1ModelVo> voList = new ValueObjectList <GA1ModelVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select distinct b.line_cd from m_model_line a left join m_line b on b.line_id = a.line_id left join m_model c on c.model_id = a.model_id where 1=1 "); if (!string.IsNullOrEmpty(inVo.ModelCode)) { sql.Append(@" and c.model_cd =:model_cd"); sqlParameter.AddParameterString("model_cd", inVo.ModelCode); } sql.Append(@" order by b.line_cd"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { GA1ModelVo outVo = new GA1ModelVo { LineCode = dataReader["line_cd"].ToString() }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ProcessFlowRuleVo inVo = (ProcessFlowRuleVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as RuleCount from m_process_flow_rule "); sqlQuery.Append(" where 1 = 1 "); if (inVo.ProcessFlowRuleCode != null) { sqlQuery.Append(" and UPPER(process_flow_rule_cd) = UPPER(:processflowrulecd)"); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); if (inVo.ProcessFlowRuleCode != null) { sqlParameter.AddParameterString("processflowrulecd", inVo.ProcessFlowRuleCode); } //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); ProcessFlowRuleVo outVo = new ProcessFlowRuleVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["RuleCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { FunctionDeptVo inVo = (FunctionDeptVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("Select Count(*) as FunctionCount "); sql.Append(" from vcb_functiondept"); sql.Append(" Where 1=1 "); if (!string.IsNullOrEmpty(inVo.FunctionDeptCode)) { sql.Append(" and UPPER(vcb_functiondept_cd) = UPPER(:vcb_functiondept_cd) "); sqlParameter.AddParameterString("vcb_functiondept_cd", inVo.FunctionDeptCode); } if (inVo.FunctionDeptId > 0) { sql.Append(" and vcb_department_id != :vcb_department_id "); ///????? sqlParameter.AddParameterInteger("vcb_department_id", inVo.FunctionDeptId); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); FunctionDeptVo outVo = new FunctionDeptVo(); while (dataReader.Read()) { outVo.CheckRow = Convert.ToInt32(dataReader["FunctionCount"].ToString()); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { WareHouseMainVo inVo = ( WareHouseMainVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <WareHouseMainVo> voList = new ValueObjectList <WareHouseMainVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select g.warehouse_main_id from t_warehouse_main g left join m_asset e on e.asset_id = g.asset_id where 1=1 "); if (!String.IsNullOrEmpty(inVo.AssetCode)) { sql.Append(@" and e.asset_cd =:asset_cd"); sqlParameter.AddParameterString("asset_cd", inVo.AssetCode); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { WareHouseMainVo outVo = new WareHouseMainVo { WareHouseMainId = int.Parse(dataReader["warehouse_main_id"].ToString()), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { IPQCVo inVo = (IPQCVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <IPQCVo> voList = new ValueObjectList <IPQCVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select no, model, process, inspect, description, upper, lower, instrument, clm_set, row_set from tbl_measure_item where model='" + inVo.Model + "' order by no, process, inspect"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { IPQCVo outVo = new IPQCVo { No = dataReader["no"].ToString(), Model = dataReader["model"].ToString(), Process = dataReader["process"].ToString(), Inspect = dataReader["inspect"].ToString(), Description = dataReader["description"].ToString(), Upper = double.Parse(dataReader["upper"].ToString()), Lower = double.Parse(dataReader["lower"].ToString()), Instrument = dataReader["instrument"].ToString(), ClmSet = int.Parse(dataReader["clm_set"].ToString()), RowSet = int.Parse(dataReader["row_set"].ToString()) }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { AccountCodeVo inVo = (AccountCodeVo)vo; ValueObjectList <AccountCodeVo> voList = new ValueObjectList <AccountCodeVo>(); StringBuilder sql = new StringBuilder(); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select account_code_id, account_code_cd, account_code_name from m_account_code where 1=1 "); if (!string.IsNullOrEmpty(inVo.account_code_cd)) { sql.Append("and account_code_cd='").Append(inVo.account_code_cd).Append("' "); } if (!string.IsNullOrEmpty(inVo.account_code_name)) { sql.Append("and account_code_name='").Append(inVo.account_code_name).Append("' "); } sql.Append("order by account_code_id"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); sql.Clear(); //EXECUTE READER FROM COMMAND IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (datareader.Read()) { AccountCodeVo outVo = new AccountCodeVo { account_code_id = (int)datareader["account_code_id"], account_code_cd = datareader["account_code_cd"].ToString(), account_code_name = datareader["account_code_name"].ToString() }; voList.add(outVo); } datareader.Close(); base.CloseConnection(trxContext); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionTestInstructionVo inVo = (InspectionTestInstructionVo)arg; StringBuilder sql = new StringBuilder(); //create SQL sql.Append("Select inspection_test_instruction_detail_result_count from m_inspection_test_instruction_detail"); sql.Append(" where factory_cd = :faccd "); if (inVo.InspectionTestInstructionId > 0) { sql.Append(" and inspection_test_instruction_id = :inspectiontestinstructionid "); } //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameterInteger("inspectiontestinstructionid", inVo.InspectionTestInstructionId); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); InspectionTestInstructionVo outVo = new InspectionTestInstructionVo { AffectedCount = 0 }; while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["inspection_test_instruction_detail_result_count"]); } dataReader.Close(); return outVo; }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { OvenBarcodeVo inVo = (OvenBarcodeVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <OvenBarcodeVo> voList = new ValueObjectList <OvenBarcodeVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select distinct line_cd from t_ovenmachine_ls where 1=1 "); if (!String.IsNullOrEmpty(inVo.Model)) { sql.Append(@" and model = :model "); sqlParameter.AddParameterString("model", inVo.Model); } sql.Append(" order by line_cd"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { OvenBarcodeVo outVo = new OvenBarcodeVo { Line = dataReader["line_cd"].ToString(), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { TransferVo inVo = (TransferVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("Select Count(*) as AssetCount from t_transfer_detail_info where 1 = 1 and asset_id = :asset_id "); sqlParameter.AddParameterInteger("asset_id", inVo.AssetID); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); TransferVo outVo = new TransferVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["AssetCount"].ToString()); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RangeVo inVo = (RangeVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <RangeVo> voList = new ValueObjectList <RangeVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select distinct range_process from m_ovenmachinels12_range where 1=1 "); if (!String.IsNullOrEmpty(inVo.Model)) { sql.Append(@" and range_model = :range_model "); sqlParameter.AddParameterString("range_model", inVo.Model); } sql.Append(" order by range_process"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { RangeVo outVo = new RangeVo { Process = dataReader["range_process"].ToString(), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { AddBatchProcessVo inVo = (AddBatchProcessVo)arg; StringBuilder sqlQuery = new StringBuilder(); //create SQL sqlQuery.Append("SELECT "); sqlQuery.Append(" batch_process_cd"); sqlQuery.Append(" FROM t_batch_process "); sqlQuery.Append(" WHERE batch_process_cd = :batchprocesscd "); sqlQuery.Append(" AND factory_cd = :factorycd "); sqlQuery.Append(" FOR UPDATE "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("batchprocesscd", inVo.BatchProcessCode); sqlParameter.AddParameterString("factorycd", trxContext.UserData.FactoryCode); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); AddBatchProcessVo outVo = null; while (dataReader.Read()) { outVo = new AddBatchProcessVo(); outVo.BatchProcessCode = ConvertDBNull <string>(dataReader, "batch_process_cd"); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { StockLocationVo inVo = (StockLocationVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Select Count(*) as DisplayCount from m_stock_location"); sqlQuery.Append(" where factory_cd = :factcd "); sqlQuery.Append(" and display_order = :displayorder"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("factcd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); StockLocationVo outVo = null; while (dataReader.Read()) { outVo = new StockLocationVo(); outVo.AffectedCount = Convert.ToInt32(dataReader["DisplayCount"]); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { DetailPositionVo inVo = (DetailPositionVo)vo; StringBuilder sql = new StringBuilder(); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("Select Count(*) as DetailPositionCounter "); sql.Append(" from m_detail_postion"); sql.Append(" Where 1=1 "); if (!string.IsNullOrEmpty(inVo.DetailPositionCode)) { sql.Append(" and UPPER(detail_postion_cd) = UPPER(:detail_postion_cd) "); sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode); } if (inVo.DetailPositionId > 0) { sql.Append(" and detail_postion_id != :detail_postion_id "); ///????? sqlParameter.AddParameterInteger("detail_postion_id", inVo.DetailPositionId); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); DetailPositionVo outVo = new DetailPositionVo(); while (dataReader.Read()) { outVo.AffectedCount = Convert.ToInt32(dataReader["DetailPositionCounter"].ToString()); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ProductionControllerGA1Vo inVo = (ProductionControllerGA1Vo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <ProductionControllerGA1Vo> voList = new ValueObjectList <ProductionControllerGA1Vo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select distinct process from " + inVo.TableName); sql.Append(" where 1=1 "); if (!string.IsNullOrEmpty(inVo.LineCode)) { sql.Append(@" and line =:line"); sqlParameter.AddParameterString("line", inVo.LineCode); } sql.Append(@" order by process"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { ProductionControllerGA1Vo outVo = new ProductionControllerGA1Vo { ProcessCode = dataReader["process"].ToString() }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { DetailPositionVo inVo = (DetailPositionVo)vo; ValueObjectList <DetailPositionVo> voList = new ValueObjectList <DetailPositionVo>(); StringBuilder sql = new StringBuilder(); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select distinct detail_postion_id, detail_postion_cd, detail_postion_name from m_detail_postion where 1=1 "); if (!string.IsNullOrEmpty(inVo.detail_postion_cd)) { sql.Append("and detail_postion_cd='").Append(inVo.detail_postion_cd).Append("' "); } if (!string.IsNullOrEmpty(inVo.detail_postion_name)) { sql.Append("and detail_postion_name='").Append(inVo.detail_postion_name).Append("' "); } sql.Append("order by detail_postion_id"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); sql.Clear(); //EXECUTE READER FROM COMMAND IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (datareader.Read()) { DetailPositionVo outVo = new DetailPositionVo { detail_postion_id = (int)datareader["detail_postion_id"], detail_postion_cd = datareader["detail_postion_cd"].ToString(), detail_postion_name = datareader["detail_postion_name"].ToString() }; voList.add(outVo); } datareader.Close(); return(voList); }