public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { GA1ModelVo inVo = (GA1ModelVo)vo; GA1ModelVo outVo = new GA1ModelVo(); StringBuilder sql = new StringBuilder(); StringBuilder sqlUpdate = new StringBuilder(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select case when (select count(*) from m_user_location where user_location_cd = :user_location_cd)=1 then (select user_location_name from m_user_location where user_location_cd = :user_location_cd) else 'User ID not found' end "); sqlParameter.AddParameterString("user_location_cd", inVo.UserCd); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); string user = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString(); outVo = new GA1ModelVo { UserName = user, }; 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 count(*) count_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); } if (!String.IsNullOrEmpty(inVo.Process)) { sql.Append(@" and range_process = :range_process "); sqlParameter.AddParameterString("range_process", inVo.Process); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); RangeVo outVo = new RangeVo(); outVo.Count = int.Parse(sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString()); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { GA1ModelVo inVo = (GA1ModelVo)vo; GA1ModelVo outVo = new GA1ModelVo(); StringBuilder sql = new StringBuilder(); StringBuilder sqlUpdate = new StringBuilder(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select count(*) from t_checkpusha90 where 1=1 "); if (!string.IsNullOrEmpty(inVo.A90Barcode)) { sql.Append(@" and a90_barcode =:a90_barcode"); sqlParameter.AddParameterString("a90_barcode", inVo.A90Barcode); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); int rowCount = int.Parse(sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString()); outVo = new GA1ModelVo { AffectedCount = rowCount, }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { GA1ModelVo inVo = (GA1ModelVo)vo; GA1ModelVo outVo = new GA1ModelVo(); StringBuilder sql = new StringBuilder(); StringBuilder sqlUpdate = new StringBuilder(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"SELECT count(*) FROM t_noisecheck_a90 WHERE noise_id IN (select MAX(noise_id) from t_noisecheck_a90 where registration_date_time > :datefrom and registration_date_time < :dateto AND eq_id = :eq_id GROUP BY BARCODE) "); sqlParameter.AddParameter("eq_id ", inVo.Noise_eq_id); sqlParameter.AddParameter("datefrom ", inVo.DateFrom); sqlParameter.AddParameter("dateto ", inVo.DateTo); if (!inVo.Status)//status = false => search output || status = true => search input { sql.Append(@" AND SUBSTRING(judgment,0,3) = 'OK'"); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); int rowCount = int.Parse(sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString()); outVo = new GA1ModelVo { AffectedCount = rowCount, }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { OvenBarcodeVo inVo = (OvenBarcodeVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <OvenBarcodeVo> voList = new ValueObjectList <OvenBarcodeVo>(); OvenBarcodeVo von = new OvenBarcodeVo(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select case when count(*) = 0 then '110' else max(range_upper) end ca 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); } if (!String.IsNullOrEmpty(inVo.Process)) { sql.Append(@" and range_process = :range_process "); sqlParameter.AddParameterString("range_process", inVo.Process); } sql.Append(" limit 1"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); string dataReader = ""; //execute SQL dataReader = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString(); von.Upper = dataReader; return(von); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { GA1ModelVo inVo = (GA1ModelVo)vo; GA1ModelVo outVo = new GA1ModelVo(); StringBuilder sql = new StringBuilder(); StringBuilder sqlUpdate = new StringBuilder(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"SELECT count(*) FROM t_checkpusha90 WHERE oid IN (select MAX(oid) from t_checkpusha90 where a90_date +a90_time > :datefrom and a90_date +a90_time < :dateto AND a90_factory =:a90_factory GROUP BY a90_barcode) and a90_line =:a90_line "); sqlParameter.AddParameter("a90_factory ", inVo.Noise_eq_id); sqlParameter.AddParameter("datefrom ", inVo.DateFrom); sqlParameter.AddParameter("dateto ", inVo.DateTo); sqlParameter.AddParameter("a90_line", inVo.LineCode); if (!inVo.Status)//status = false => search output || status = true => search input { sql.Append(@" AND a90_thurst_status = 'OK'"); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); int rowCount = int.Parse(sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString()); outVo = new GA1ModelVo { AffectedCount = rowCount, }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { DefectiveReasonVo inVo = (DefectiveReasonVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_defective_reason"); sqlQuery.Append(" ( "); sqlQuery.Append(" defective_reason_cd, "); sqlQuery.Append(" defective_reason_name, "); sqlQuery.Append(" defective_category_id, "); sqlQuery.Append(" display_order, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :defectivereasoncd ,"); sqlQuery.Append(" :defectivereasonname ,"); sqlQuery.Append(" :defectivecategoryid ,"); sqlQuery.Append(" :displayorder,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ) "); sqlQuery.Append(" RETURNING defective_reason_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("defectivereasoncd", inVo.DefectiveReasonCode); sqlParameter.AddParameterString("defectivereasonname", inVo.DefectiveReasonName); sqlParameter.AddParameterInteger("defectivecategoryid", inVo.DefectiveCategoryId); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); //return outVo; DefectiveReasonVo outVo = new DefectiveReasonVo(); outVo.DefectiveReasonId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; if (outVo != null && outVo.DefectiveReasonId > 0) { outVo.AffectedCount = 1; } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldCategoryVo inVo = (MoldCategoryVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_mold_category"); sqlQuery.Append(" ( "); sqlQuery.Append(" mold_category_cd, "); sqlQuery.Append(" mold_category_name, "); sqlQuery.Append(" display_order, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :moldcategorycd ,"); sqlQuery.Append(" :moldcategoryname ,"); sqlQuery.Append(" :displayorder ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ) "); sqlQuery.Append("RETURNING mold_category_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("moldcategorycd", inVo.MoldCategoryCode); sqlParameter.AddParameterString("moldcategoryname", inVo.MoldCategoryName); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); sqlParameter.AddParameterString("registrationusercode", trxContext.UserData.UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode); //execute SQL int outId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; MoldCategoryVo outVo = null; if (outId > 0) { outVo = new MoldCategoryVo(); outVo.MoldCategoryId = outId; } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { PersonVo inVo = (PersonVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <PersonVo> voList = new ValueObjectList <PersonVo>(); //PersonVo outVo = new PersonVo(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select count(*) as counter from t_productioncontroller_person where 1=1 "); if (!String.IsNullOrEmpty(inVo.DateTimes.ToString())) { sql.Append(" and cast(datetimes as date) = :datetimes"); sqlParameter.AddParameter("datetimes", inVo.DateTimes.Date); } if (!String.IsNullOrEmpty(inVo.Model)) { sql.Append(" and model_cd =:model_cd"); sqlParameter.AddParameterString("model_cd", inVo.Model); } if (!String.IsNullOrEmpty(inVo.Line)) { sql.Append(" and line_cd =:line_cd"); sqlParameter.AddParameterString("line_cd", inVo.Line); } if (inVo.Shift > 0 && inVo.Shift < 4) { sql.Append(" and shift =:shift"); sqlParameter.AddParameter("shift", inVo.Shift); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL string dataReader = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString(); PersonVo outVo = new PersonVo { AffectedCount = int.Parse(dataReader), //AffectedCount }; //voList.add(outVo); //dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionProcessVo inVo = (InspectionProcessVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_inspection_process"); sqlQuery.Append(" ( "); sqlQuery.Append(" inspection_process_cd,"); sqlQuery.Append(" inspection_process_name,"); sqlQuery.Append(" inspection_format_id,"); sqlQuery.Append(" display_order,"); sqlQuery.Append(" registration_user_cd,"); sqlQuery.Append(" registration_date_time,"); sqlQuery.Append(" factory_cd"); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :inspectionprocesscd,"); sqlQuery.Append(" :inspectionprocessname,"); sqlQuery.Append(" :inspectionformatid,"); sqlQuery.Append(" :displayorder,"); sqlQuery.Append(" :registrationusercode,"); sqlQuery.Append(" :regdatetime,"); sqlQuery.Append(" :factorycode"); sqlQuery.Append(" ) "); sqlQuery.Append(" RETURNING inspection_process_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("inspectionprocesscd", inVo.InspectionProcessCode); sqlParameter.AddParameterString("inspectionprocessname", inVo.InspectionProcessName); sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); UserData userdata = trxContext.UserData; sqlParameter.AddParameterString("registrationusercode", userdata.UserCode); sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", userdata.FactoryCode); InspectionProcessVo outVo = new InspectionProcessVo(); outVo.InspectionProcessId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ItemVo inVo = (ItemVo)arg; ItemVo outVo = new ItemVo(); StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_local_item"); sqlQuery.Append(" ( "); sqlQuery.Append(" item_cd, "); sqlQuery.Append(" item_name, "); sqlQuery.Append(" unit_type,"); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :itemcode ,"); sqlQuery.Append(" :itemname ,"); sqlQuery.Append(" :unittype ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ) returning item_id "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("itemcode", inVo.ItemCode); sqlParameter.AddParameterString("itemname", inVo.ItemName); sqlParameter.AddParameterInteger("unittype", inVo.UnitType); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); outVo.ItemId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; if (outVo.ItemId > 0) { outVo.AffectedCount = 1; } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { GlobalItemVo inVo = (GlobalItemVo)arg; GlobalItemVo outVo = null; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_global_item"); sqlQuery.Append(" ( "); sqlQuery.Append(" global_item_cd, "); sqlQuery.Append(" global_item_name, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append(" VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :globalitemcd, "); sqlQuery.Append(" :globalitemname, "); sqlQuery.Append(" :registrationusercode, "); sqlQuery.Append(" :registrationdatetime, "); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ) "); sqlQuery.Append(" RETURNING global_item_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("globalitemcd", inVo.GlobalItemCode); sqlParameter.AddParameterString("globalitemname", inVo.GlobalItemName); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); //execute SQL int outId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; if (outId > 0) { outVo = new GlobalItemVo(); outVo.GlobalItemId = outId; } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldItemVo inVo = (MoldItemVo)arg; // Building SQL StringBuilder sql = new StringBuilder(); sql.Append("Insert into m_gtrs_global_item_sap_item"); sql.Append("("); sql.Append(" global_item_id,"); sql.Append(" sap_item_cd,"); sql.Append(" registration_user_cd,"); sql.Append(" registration_date_time,"); sql.Append(" factory_cd"); sql.Append(") values ("); sql.Append(" :globalitemid,"); sql.Append(" :sapitemcd,"); sql.Append(" :registrationusercd,"); sql.Append(" :registrationdatetime,"); sql.Append(" :factrycode "); sql.Append(" ) "); sql.Append("RETURNING global_item_sap_item_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId); sqlParameter.AddParameterString("sapitemcd", inVo.LocalItemCode); sqlParameter.AddParameterString("registrationusercd", trxContext.UserData.UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factrycode", trxContext.UserData.FactoryCode); //execute SQL int outId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; MoldItemVo outVo = null; if (outId > 0) { outVo = new MoldItemVo(); outVo.GlobalLocalItemId = outId; } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionTestInstructionVo inVo = (InspectionTestInstructionVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_inspection_test_instruction"); sqlQuery.Append(" ( "); sqlQuery.Append(" inspection_test_instruction_cd,"); sqlQuery.Append(" inspection_test_instruction_text,"); sqlQuery.Append(" inspection_item_id,"); sqlQuery.Append(" registration_user_cd,"); sqlQuery.Append(" registration_date_time,"); sqlQuery.Append(" factory_cd"); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :inspectiontestinstructioncd,"); sqlQuery.Append(" :inspectiontestinstructiontext,"); sqlQuery.Append(" :inspectionitemid,"); sqlQuery.Append(" :registrationusercode,"); sqlQuery.Append(" :regdatetime,"); sqlQuery.Append(" :factorycode"); sqlQuery.Append(" ) "); sqlQuery.Append(" RETURNING inspection_test_instruction_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("inspectiontestinstructioncd", inVo.InspectionTestInstructionCode); sqlParameter.AddParameterString("inspectiontestinstructiontext", inVo.InspectionTestInstructionText); sqlParameter.AddParameterInteger("inspectionitemid", inVo.InspectionItemId); UserData userdata = trxContext.UserData; sqlParameter.AddParameterString("registrationusercode", userdata.UserCode); sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", userdata.FactoryCode); InspectionTestInstructionVo outVo = new InspectionTestInstructionVo(); outVo.InspectionTestInstructionId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LineVo inVo = (LineVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_line"); sqlQuery.Append(" ( "); sqlQuery.Append(" line_cd, "); sqlQuery.Append(" line_name, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :linecd ,"); sqlQuery.Append(" :linename ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ) "); sqlQuery.Append(" RETURNING line_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("linecd", inVo.LineCode); sqlParameter.AddParameterString("linename", inVo.LineName); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); LineVo outVo = new LineVo(); outVo.LineId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { RateNGVo inVo = (RateNGVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <RateNGVo> voList = new ValueObjectList <RateNGVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append("select rate_ng_ratio from m_rate_ng where 1=1 "); if (!string.IsNullOrEmpty(inVo.RateModel)) { sql.Append(@" and rate_ng_model =:rate_ng_model"); sqlParameter.AddParameterString("rate_ng_model", inVo.RateModel); } if (!string.IsNullOrEmpty(inVo.RateLine)) { sql.Append(@" and rate_ng_line =:rate_ng_line"); sqlParameter.AddParameterString("rate_ng_line", inVo.RateLine); } if (!string.IsNullOrEmpty(inVo.RateCode)) { sql.Append(@" and rate_ng_cd =:rate_ng_cd"); sqlParameter.AddParameterString("rate_ng_cd", inVo.RateCode); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL string a = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString(); RateNGVo outVo = new RateNGVo { RateRatio = a, }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { TransferVo inVo = (TransferVo)vo; StringBuilder sql = new StringBuilder(); TransferVo voNoList = new TransferVo(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"SELECT case when MAX(transfer_device_id) is null then 0 else MAX(transfer_device_id) end transfer_device_id from t_transfer_device"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); string transfer_device_id = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString(); inVo.TransferDeviceID = int.Parse(transfer_device_id); return(inVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { TransferVo inVo = (TransferVo)vo; StringBuilder sql = new StringBuilder(); TransferVo voNoList = new TransferVo(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select dept_cd from m_user_location where user_location_name = :user_location_name"); sqlParameter.AddParameterString("user_location_name", inVo.UserName); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); string dept_cd = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString(); inVo.DeptCD = dept_cd; return(inVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { TransferVo inVo = (TransferVo)vo; StringBuilder sql = new StringBuilder(); TransferVo voNoList = new TransferVo(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"SELECT role_cd FROM m_mes_user_role WHERE user_cd = :user_cd"); sqlParameter.AddParameterString("user_cd", inVo.RegistrationUserCode); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); string user_cd = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString(); inVo.RegistrationUserCode = user_cd; return(inVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { PersonVo inVo = (PersonVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <PersonVo> voList = new ValueObjectList <PersonVo>(); //PersonVo outVo = new PersonVo(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select count(*) as counter from t_productioncontroller_person where 1=1 "); if (inVo.PersonId > 0) { sql.Append(" and person_id =:person_id"); sqlParameter.AddParameter("person_id", inVo.PersonId); } if (!String.IsNullOrEmpty(inVo.RegistrationUserCode)) { sql.Append(" and registration_user_cd =:registration_user_cd"); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); } sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL string dataReader = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString(); PersonVo outVo = new PersonVo { AffectedCount = int.Parse(dataReader), }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { InvertoryVo inVo = (InvertoryVo)vo; StringBuilder sql = new StringBuilder(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select max(invertory_time_id) maxid from m_invertory_time "); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //IDataReader dataReader = sqlCommandAdapter.ExecuteScalar(sqlParameter); InvertoryVo outVo = new InvertoryVo { InvertoryTimeId = int.Parse(sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString()), }; //dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldVo inVo = (MoldVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_mold"); sqlQuery.Append(" ( "); sqlQuery.Append(" mold_cd, "); sqlQuery.Append(" mold_name, "); sqlQuery.Append(" mold_type_id, "); sqlQuery.Append(" width , depth , height , weight , "); sqlQuery.Append(" production_date_time , life_shot_count, "); sqlQuery.Append(" comment, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :moldcd ,"); sqlQuery.Append(" :moldname ,"); sqlQuery.Append(" :moldtypeid ,"); sqlQuery.Append(" :width , :depth , :height , :weight, "); sqlQuery.Append(" :pdt, :lfscount ,"); sqlQuery.Append(" :comment ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" now() ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ) "); sqlQuery.Append(" RETURNING mold_id "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("moldcd", inVo.MoldCode); sqlParameter.AddParameterString("moldname", inVo.MoldName); sqlParameter.AddParameterInteger("moldtypeid", inVo.MoldTypeId); sqlParameter.AddParameter("width", inVo.Width); sqlParameter.AddParameter("depth", inVo.Depth); sqlParameter.AddParameter("height", inVo.Height); sqlParameter.AddParameter("weight", inVo.Weight); if (inVo.ProductionDate != System.DateTime.MinValue) { sqlParameter.AddParameterDateTime("pdt", inVo.ProductionDate); } else { sqlParameter.AddParameter("pdt", System.DBNull.Value); } sqlParameter.AddParameter("lfscount", inVo.LifeShotCount); sqlParameter.AddParameter("comment", inVo.Comment); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); MoldVo outVo = new MoldVo();// {AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)}; outVo.MoldId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; if (outVo != null && outVo.MoldId > 0) { outVo.AffectedCount = 1; } return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionItemVo inVo = (InspectionItemVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_inspection_item"); sqlQuery.Append(" ( "); sqlQuery.Append(" inspection_item_cd, "); sqlQuery.Append(" inspection_item_name, "); if (inVo.ParentInspectionItemId > 0) { sqlQuery.Append(" parent_inspection_item_id, "); } if (inVo.InspectionResultItemDecimalDigits > 0) { sqlQuery.Append(" inspection_item_result_input_decimal_digits, "); } sqlQuery.Append(" inspection_process_id, "); sqlQuery.Append(" is_inspection_item_mandatory, "); sqlQuery.Append(" is_inspection_employee_mandatory, "); sqlQuery.Append(" is_inspection_machine_mandatory, "); sqlQuery.Append(" inspection_item_data_type, "); sqlQuery.Append(" display_order,"); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :inspectionitemcd ,"); sqlQuery.Append(" :inspectionitemname ,"); if (inVo.ParentInspectionItemId > 0) { sqlQuery.Append(" :parentitemcd ,"); } if (inVo.InspectionResultItemDecimalDigits > 0) { sqlQuery.Append(" :inputdecimaldigits ,"); } sqlQuery.Append(" :inspectionprocessid, "); sqlQuery.Append(" :inspectionitemmandatory, "); sqlQuery.Append(" :inspectionemployeemandatory, "); sqlQuery.Append(" :inspectionmachinemandatory, "); sqlQuery.Append(" :inspectionitemdatatype, "); sqlQuery.Append(" :displayorder,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime, "); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ) "); sqlQuery.Append(" RETURNING inspection_item_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("inspectionitemcd", inVo.InspectionItemCode); sqlParameter.AddParameterString("inspectionitemname", inVo.InspectionItemName); if (inVo.ParentInspectionItemId > 0) { sqlParameter.AddParameterInteger("parentitemcd", inVo.ParentInspectionItemId); } //else //{ // sqlParameter.AddParameterString("parentitemcd", DBNull.Value); //} sqlParameter.AddParameterInteger("inspectionitemmandatory", inVo.InspectionItemMandatory); sqlParameter.AddParameterInteger("inspectionemployeemandatory", inVo.InspectionEmployeeMandatory); sqlParameter.AddParameterInteger("inspectionmachinemandatory", inVo.InspectionMachineMandatory); sqlParameter.AddParameterInteger("inspectionprocessid", inVo.InspectionProcessId); sqlParameter.AddParameterInteger("inspectionitemdatatype", inVo.InspectionItemDataType); sqlParameter.AddParameterInteger("inputdecimaldigits", inVo.InspectionResultItemDecimalDigits); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); InspectionItemVo outVo = new InspectionItemVo(); outVo.InspectionItemId = (int?)sqlCommandAdapter.ExecuteScalar(sqlParameter) ?? 0; return(outVo); }
/// <summary> /// execute with ExecuteScalar /// </summary> /// <param name="parameterList"></param> /// <returns></returns> public object ExecuteScalar(DbParameterList parameterList) { return(internalAdaptor.ExecuteScalar(parameterList)); }