public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ProductionControllerNCVCVo inVo = (ProductionControllerNCVCVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <ProductionControllerNCVCVo> voList = new ValueObjectList <ProductionControllerNCVCVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select Case When times between '06:00:00' and '23:59:00' then dates when "); sql.Append("times between '00:00:00' and '05:59:00' then dates+1 end datesss, model_cd,'All Line' line_cd, sum(ba_bm_brush_deform_scracth) ba_bm_brush_deform_scracth, sum(ba_bm_metal_deform_scracth) ba_bm_metal_deform_scracth, sum(ba_bm_ba_deform) ba_bm_ba_deform, sum(ba_bm_endplay_deform_scracth) ba_bm_endplay_deform_scracth from "); sql.Append("(select i2.dates,i2.times,i2.model_cd,i2.line_cd, ba_bm_brush_deform_scracth, ba_bm_metal_deform_scracth, ba_bm_ba_deform, ba_bm_endplay_deform_scracth from t_ncvc_pdc_ba i2 left join (select dates, line_cd, Case when idca3 is null then idca1 else idca3 end id from(select tblca1.dates, tblca1.line_cd, idca1, idca3 from(select line_cd, o.dates, max(o.ba_id) idca1 from t_ncvc_pdc_ba o where o.times > '06:00:00' and o.times <= '23:59:00' and o.dates >= :datefrom and o.dates <= :dateto group by o.dates, line_cd order by dates) tblca1 left join(select line_cd, (o.dates - 1) dates, max(o.ba_id) idca3 from t_ncvc_pdc_ba o where o.times > '00:00:00' and o.times <= '05:30:00' and o.dates > :datefrom and o.dates - 1 <= :dateto group by line_cd, o.dates order by idca3) tblca3 on tblca1.dates = tblca3.dates and tblca1.line_cd = tblca3.line_cd) tbl order by dates, line_cd) l on l.line_cd = i2.line_cd where i2.ba_id = l.id order by i2.dates,i2.line_cd ) t where model_cd = :model_cd group by datesss,model_cd order by datesss"); sqlParameter.AddParameterDateTime("datefrom", DateTime.Parse(inVo.DateFrom)); sqlParameter.AddParameterDateTime("dateto", DateTime.Parse(inVo.DateTo)); sqlParameter.AddParameterString("model_cd", inVo.ProModel); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { ProductionControllerNCVCVo outVo = new ProductionControllerNCVCVo { TimeHour = DateTime.Parse(dataReader["datesss"].ToString()), ProModel = dataReader["model_cd"].ToString(), ProLine = dataReader["line_cd"].ToString(), BA_bm_brush_deform_scracth = int.Parse(dataReader["ba_bm_brush_deform_scracth"].ToString()), BA_bm_metal_deform_scracth = int.Parse(dataReader["ba_bm_metal_deform_scracth"].ToString()), BA_bm_deform = int.Parse(dataReader["ba_bm_ba_deform"].ToString()), BA_bm_endplay_deform_scracth = int.Parse(dataReader["ba_bm_endplay_deform_scracth"].ToString()), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ItemProcessWorkVo inVo = (ItemProcessWorkVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_item_process_work"); sqlQuery.Append(" ( "); sqlQuery.Append(" item_id, "); sqlQuery.Append(" process_work_id, "); sqlQuery.Append(" process_work_sequence, "); sqlQuery.Append(" is_optional_process, "); sqlQuery.Append(" skip_prevention_flg, "); sqlQuery.Append(" work_order, "); sqlQuery.Append(" process_flow_rule_id, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :itemid ,"); sqlQuery.Append(" :processworkid ,"); sqlQuery.Append(" :processworkseq ,"); sqlQuery.Append(" :optionalflg ,"); sqlQuery.Append(" :skippreventionflg ,"); sqlQuery.Append(" :workorder ,"); sqlQuery.Append(" :processflowruleid ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime ,"); sqlQuery.Append(" :factorycd "); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("itemid", inVo.ItemId); sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId); sqlParameter.AddParameterInteger("processworkseq", inVo.ProcessWorkSeq); sqlParameter.AddParameterString("optionalflg", inVo.OptionalProcessFlag); sqlParameter.AddParameterString("skippreventionflg", inVo.SkipPreventionFlag); sqlParameter.AddParameterInteger("workorder", inVo.WorkOrder); sqlParameter.AddParameterInteger("processflowruleid", inVo.ProcessFlowRuleId); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycd", UserData.GetUserData().FactoryCode); ItemProcessWorkVo outVo = new ItemProcessWorkVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ProductionControllerVo inVo = (ProductionControllerVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <ProductionControllerVo> voList = new ValueObjectList <ProductionControllerVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select Case When times between '06:00:00' and '23:59:00' then dates when "); sql.Append("times between '00:00:00' and '05:59:00' then dates+1 end datesss,'LA459' model_cd,'All Line' line_cd, sum(fd_fundou_deform) fd_fundou_deform, sum(fd_ng_beat_point) fd_ng_beat_point from "); sql.Append("(select i2.dates,i2.times,i2.line_cd, fd_ng_beat_point, fd_fundou_deform from t_productioncontroller_output02 i2 left join (select dates, line_cd, Case when idca3 is null then idca1 else idca3 end id from(select tblca1.dates, tblca1.line_cd, idca1, idca3 from(select line_cd, o.dates, max(o.output02_id) idca1 from t_productioncontroller_output02 o where o.times > '06:00:00' and o.times <= '23:59:00' and o.dates >= :datefrom and o.dates <= :dateto group by o.dates, line_cd order by dates) tblca1 left join(select line_cd, (o.dates - 1) dates, max(o.output02_id) idca3 from t_productioncontroller_output02 o where o.times > '00:00:00' and o.times <= '05:30:00' and o.dates > :datefrom and o.dates - 1 <= :dateto group by line_cd, o.dates order by idca3) tblca3 on tblca1.dates = tblca3.dates and tblca1.line_cd = tblca3.line_cd) tbl order by dates, line_cd) l on l.line_cd = i2.line_cd where i2.output02_id = l.id order by i2.dates,i2.line_cd ) t group by datesss order by datesss"); sqlParameter.AddParameterDateTime("datefrom", DateTime.Parse(inVo.DateFrom)); sqlParameter.AddParameterDateTime("dateto", DateTime.Parse(inVo.DateTo)); //sqlParameter.AddParameterString("model_cd", inVo.ProModel); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { ProductionControllerVo outVo = new ProductionControllerVo { //StartDay = DateTime.Parse(dataReader["dates"].ToString()), TimeHour = DateTime.Parse(dataReader["datesss"].ToString()), ProModel = dataReader["model_cd"].ToString(), ProLine = dataReader["line_cd"].ToString(), Fd_ng_beat_point = int.Parse(dataReader["fd_ng_beat_point"].ToString()), Fd_fundou_deform = int.Parse(dataReader["fd_fundou_deform"].ToString()), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { InspectionFormatVo inVo = (InspectionFormatVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_inspection_format"); sqlQuery.Append(" ( "); sqlQuery.Append(" inspection_format_cd, "); sqlQuery.Append(" inspection_format_name, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" is_deleted, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :inspectionformatcd ,"); sqlQuery.Append(" :inspectionformatname ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :regdatetime ,"); sqlQuery.Append(" :isdeleted, "); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ) "); sqlQuery.Append("RETURNING inspection_format_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("inspectionformatcd", inVo.InspectionFormatCode); sqlParameter.AddParameterString("inspectionformatname", inVo.InspectionFormatName); UserData userdata = trxContext.UserData; sqlParameter.AddParameterString("registrationusercode", userdata.UserCode); sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", userdata.FactoryCode); sqlParameter.AddParameterString("isdeleted", GlobalMasterDataTypeEnum.FLAG_OFF.GetValue().ToString()); IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); InspectionFormatVo outVo = null; while (dataReader.Read()) { outVo = new InspectionFormatVo(); outVo.InspectionFormatId = ConvertDBNull <int>(dataReader, "inspection_format_id"); } dataReader.Close(); return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { EquipmentVo inVo = (EquipmentVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_equipment"); sqlQuery.Append(" ( "); sqlQuery.Append(" equipment_cd, "); sqlQuery.Append(" equipment_name, "); sqlQuery.Append(" instration_dt, "); sqlQuery.Append(" asset_no, "); sqlQuery.Append(" manufacturer, "); sqlQuery.Append(" model_name, "); sqlQuery.Append(" model_cd, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :equipmentcd ,"); sqlQuery.Append(" :equipmentname ,"); sqlQuery.Append(" :instrationdt ,"); sqlQuery.Append(" :assetno ,"); sqlQuery.Append(" :manufacturer ,"); sqlQuery.Append(" :modelname ,"); sqlQuery.Append(" :modelcd ,"); sqlQuery.Append(" :registrationusercd ,"); sqlQuery.Append(" now(),"); sqlQuery.Append(" :factorycd "); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("equipmentcd", inVo.EquipmentCode); 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("registrationusercd", inVo.RegistrationUserCode); //sqlParameter.AddParameterDateTime("registrationdt", inVo.RegistrationDateTime); sqlParameter.AddParameterString("factorycd", inVo.FactoryCode); EquipmentVo outVo = new EquipmentVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { AssetInfoVo inVo = (AssetInfoVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(@"INSERT INTO m_asset( asset_no, asset_cd, asset_name, asset_model, asset_serial, asset_supplier, asset_invoice, asset_life, acquistion_date, acquistion_cost, asset_type, registration_user_cd, registration_date_time, factory_cd, label_status, asset_po) VALUES(:asset_no, :asset_cd, :asset_name, :asset_model, :asset_serial, :asset_supplier, :asset_invoice, :asset_life, :acquistion_date, :acquistion_cost, :asset_type, :registration_user_cd, :registration_date_time, :factory_cd, :label_status, :asset_po)"); //CREATE SQL ADAPTER AND PARAMETER LIST DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("asset_no", inVo.asset_no); sqlParameter.AddParameterString("asset_cd", inVo.asset_cd); sqlParameter.AddParameterString("asset_name", inVo.asset_name); sqlParameter.AddParameterString("asset_model", inVo.asset_model); sqlParameter.AddParameterString("asset_serial", inVo.asset_serial); sqlParameter.AddParameterString("asset_supplier", inVo.asset_supplier); sqlParameter.AddParameterString("asset_invoice", inVo.asset_invoice); sqlParameter.AddParameter("asset_life", inVo.asset_life); sqlParameter.AddParameterDateTime("acquistion_date", inVo.acquistion_date); sqlParameter.AddParameter("acquistion_cost", inVo.acquistion_cost); sqlParameter.AddParameterString("asset_type", inVo.asset_type); sqlParameter.AddParameterString("registration_user_cd", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registration_date_time", DateTime.Now); sqlParameter.AddParameterString("factory_cd", UserData.GetUserData().FactoryCode); sqlParameter.AddParameterString("label_status", inVo.label_status); sqlParameter.AddParameterString("asset_po", inVo.asset_po); sql.Clear(); //EXECUTE READER FROM COMMAND AssetMaster2019Vo outVo = new AssetMaster2019Vo { executeInt = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CustomerVo inVo = (CustomerVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_customer"); sqlQuery.Append(" ( "); sqlQuery.Append(" customer_cd, "); sqlQuery.Append(" customer_name,"); sqlQuery.Append(" address1, "); sqlQuery.Append(" address2, "); sqlQuery.Append(" phone_no, "); sqlQuery.Append(" email, "); sqlQuery.Append(" remarks, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd"); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :cucode ,"); sqlQuery.Append(" :cuname ,"); sqlQuery.Append(" :add1 ,"); sqlQuery.Append(" :add2 ,"); sqlQuery.Append(" :phno ,"); sqlQuery.Append(" :email ,"); sqlQuery.Append(" :rem ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ); "); DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("cucode", inVo.CustomerCode); sqlParameter.AddParameterString("cuname", inVo.CustomerName); sqlParameter.AddParameterString("add1", inVo.Address1); sqlParameter.AddParameterString("add2", inVo.Address2); sqlParameter.AddParameterString("email", inVo.EmailId); sqlParameter.AddParameterString("rem", inVo.Remarks); sqlParameter.AddParameterString("phno ", inVo.PhoneNo); sqlParameter.AddParameterString("registrationusercode ", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime ", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode ", UserData.GetUserData().FactoryCode); CustomerVo outVo = new CustomerVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; 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) { MoldVo inVo = (MoldVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Update m_mold"); sqlQuery.Append(" Set "); sqlQuery.Append(" mold_name = :moldname, "); sqlQuery.Append(" mold_type_id = :moldtypeid, "); sqlQuery.Append(" width = :width ,"); sqlQuery.Append(" depth = :depth ,"); sqlQuery.Append(" height = :height ,"); sqlQuery.Append(" weight = :weight ,"); sqlQuery.Append(" production_date_time = :pdt ,"); sqlQuery.Append(" life_shot_count = :lfscount ,"); sqlQuery.Append(" comment = :comment"); sqlQuery.Append(" Where "); sqlQuery.Append(" mold_id = :moldid"); sqlQuery.Append(" and factory_cd = :faccd;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("moldid", inVo.MoldId); 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); sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode); if (inVo.ProductionDate != System.DateTime.MinValue) { sqlParameter.AddParameterDateTime("pdt", inVo.ProductionDate); } else { sqlParameter.AddParameter("pdt", System.DBNull.Value); } sqlParameter.AddParameter("lfscount", inVo.LifeShotCount); sqlParameter.AddParameterString("comment", inVo.Comment); MoldVo outVo = new MoldVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ReportDownTimeVo inVo = (ReportDownTimeVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(@"insert into t_downtime_report(time_from,time_to,prodution_work_content_id,line_id,model_id, machine_id,defective_reason_id,remarks,registration_user_cd,registration_date_time,factory_cd)"); sql.Append(@" values(:time_from,:time_to,:prodution_work_content_id,:line_id,:model_id, :machine_id,:defective_reason_id,:remarks,:registration_user_cd,now(),:factory_cd)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("downtime_report_id", inVo.DowntimeReportId); sqlParameter.AddParameterDateTime("time_to", inVo.TimeTo); sqlParameter.AddParameterDateTime("time_from", inVo.TimeFrom); sqlParameter.AddParameterString("remarks", inVo.Remakes); sqlParameter.AddParameterInteger("line_id", inVo.LineId); sqlParameter.AddParameterInteger("machine_id", inVo.MachineId); sqlParameter.AddParameterInteger("model_id", inVo.ModelId); sqlParameter.AddParameterInteger("prodution_work_content_id", inVo.ProductionWorkContentId); sqlParameter.AddParameterInteger("defective_reason_id", inVo.DefectiveReasonId); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); //execute SQL ReportDownTimeVo outVo = new ReportDownTimeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { PersonVo inVo = (PersonVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("insert into t_productioncontroller_person(model_cd, line_cd,datetimes,factory_cd,building_cd, "); sql.Append("lot_numbers, leader_name, shift, plan_pro, plan_st, actual_st, doing_co, absent_co, doing_ra,"); sql.Append("absent_ra,doing_ca, absent_ca, doing_ba, absent_ba,doing_ma, absent_ma, timeover, timeoffset, sum_timedoing, registration_user_cd )"); sql.Append("values(:model_cd,:line_cd, :datetimes,:factory_cd,:building_cd,"); sql.Append(":lot_numbers, :leader_name, :shift, :plan_pro,:plan_st,:actual_st,:doing_co,:absent_co,:doing_ra,"); sql.Append(":absent_ra, :doing_ca,:absent_ca,:doing_ba, :absent_ba, :doing_ma, :absent_ma, :timeover, :timeoffset, :sum_timedoing, :registration_user_cd)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("model_cd", inVo.Model); sqlParameter.AddParameterString("line_cd", inVo.Line); sqlParameter.AddParameterDateTime("datetimes", inVo.DateTimes); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("building_cd", inVo.BuildingCode); sqlParameter.AddParameterString("lot_numbers", inVo.LotNumber); sqlParameter.AddParameterString("leader_name", inVo.LeaderName); sqlParameter.AddParameterInteger("shift", inVo.Shift); sqlParameter.AddParameterInteger("plan_pro", inVo.PlanPro); sqlParameter.AddParameter("plan_st", inVo.PlanST); sqlParameter.AddParameter("actual_st", inVo.ActualSt); sqlParameter.AddParameter("doing_co", inVo.DoCo); sqlParameter.AddParameter("doing_ra", inVo.DoRa); sqlParameter.AddParameter("doing_ca", inVo.DoCa); sqlParameter.AddParameter("doing_ba", inVo.DoBa); sqlParameter.AddParameter("doing_ma", inVo.DoMa); sqlParameter.AddParameter("absent_co", inVo.AbsentCo); sqlParameter.AddParameter("absent_ra", inVo.AbsentRa); sqlParameter.AddParameter("absent_ca", inVo.AbsentCa); sqlParameter.AddParameter("absent_ba", inVo.AbsentBa); sqlParameter.AddParameter("absent_ma", inVo.AbsentMa); sqlParameter.AddParameter("timeover", inVo.TimeOver); sqlParameter.AddParameter("timeoffset", inVo.TimeOffset); sqlParameter.AddParameter("sum_timedoing", inVo.TimeTotal); sqlParameter.AddParameter("registration_user_cd", inVo.RegistrationUserCode); //execute SQL PersonVo outVo = new PersonVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { MoldDetailVo inVo = (MoldDetailVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_mold_detail"); sqlQuery.Append(" ( "); sqlQuery.Append(" mold_id, "); sqlQuery.Append(" mold_category_id, "); sqlQuery.Append(" life_alarm_shot_count, "); sqlQuery.Append(" periodic_mnt_alarm_shot_count1, "); sqlQuery.Append(" periodic_mnt_alarm_shot_count2, "); sqlQuery.Append(" periodic_mnt_alarm_shot_count3, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd ) "); sqlQuery.Append(" values ("); sqlQuery.Append(" :moldid , "); sqlQuery.Append(" :moldcategoryid , "); sqlQuery.Append(" :lfacount , "); sqlQuery.Append(" :pascount1 , "); sqlQuery.Append(" :pascount2 , "); sqlQuery.Append(" :pascount3 , "); sqlQuery.Append(" :registrationusercode , "); sqlQuery.Append(" :registrationdatetime , "); sqlQuery.Append(" :factorycode ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("moldid", inVo.MoldId); sqlParameter.AddParameter("moldcategoryid", inVo.MoldCategoryId); sqlParameter.AddParameter("lfacount", inVo.LifeAlarmShotCount); sqlParameter.AddParameter("pascount1", inVo.PeriodicAlarmShotCount1); sqlParameter.AddParameter("pascount2", inVo.PeriodicAlarmShotCount2); sqlParameter.AddParameter("pascount3", inVo.PeriodicAlarmShotCount3); UserData userdata = trxContext.UserData; sqlParameter.AddParameterString("registrationusercode", userdata.UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", userdata.FactoryCode); MoldDetailVo outVo = new MoldDetailVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ProductionControllerNCVCVo inVo = (ProductionControllerNCVCVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <ProductionControllerNCVCVo> voList = new ValueObjectList <ProductionControllerNCVCVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select tblout.datetimes, model_cd,h, tblout.line_cd,ba_input, output,( final_app+ en2 + en1+case_assy+ case_mg+ case_bonding+ trust_gap+ rotor+ bracket_assy +bracket_metal) sum_ng, final_app, en2, en1,case_assy, case_mg, case_bonding, trust_gap, rotor, bracket_assy ,bracket_metal from(select min, t.dates + min datetimes, h, fc.model_cd, t.line_cd, ba_input, output, (fc_endplay_small + fc_endplay_big + fc_shaft_scracth + fc_terminal_low + fc_case_scracth_dirty + fc_pinion_worm_ng + fc_shaft_lock + fc_ba_deform + fc_tape_hole_deform + fc_brush_rust + fc_metal_deform_scracth + fc_washer_tape_hole) final_app, (en2_insulation_resistance_ng + en2_cut_coil_wire + en2_no_load_current_hight + en2_ripple + en2_chattering + en2_lock + en2_open + en2_no_load_speed_low + en2_starting_voltage + en2_no_load_speed_high + en2_rotor_mix + en2_surge_volt_max + en2_wrong_post_of_pole + en2_err + en2_noise) en2, (en1_insulation_resistace_ng + en1_cut_coil_wire + en1_lock + en1_wareform_ma_abnormal + en1_shaft_bent + en1_ripple + en1_short + en1_chattering + en1_no_load_current_high + en1_vibration_ng + en1_open + en1_rotor_mix) en1, (ca_app_metal_dirty + ca_app_tape_hole_deform + ca_app_metal_high + ca_app_case_deform_scracth + ca_app_metal_deform_scratch + ca_app_magnet_broken) as case_assy, (ca_mg_metal_deform_scratch + ca_mg_case_deform_scratch) as case_mg, (ca_bonding_metal_deform_scratch + ca_bonding_case_deform_scracth) case_bonding, (ba_tc_endplay_big + ba_tc_endplay_small + ba_tc_brush_bent + ba_tc_shaft_mix) as trust_gap, (ba_rto_ng + ba_rto_mix) as rotor, (ba_app_metal_deform_scracth + ba_app_ba_deform + ba_app_endplate_deform_scracth + ba_app_error_other) as bracket_assy, (ba_bm_brush_deform_scracth + ba_bm_metal_deform_scracth + ba_bm_ba_deform + ba_bm_endplay_deform_scracth) as bracket_metal from t_ncvc_pdc_fc fc left join t_ncvc_pdc_en2 e2 on fc.fc_id = e2.en2_id left join t_ncvc_pdc_en1 e1 on e1.en1_id = fc.fc_id left join t_ncvc_pdc_ca ca on ca.ca_id = fc.fc_id left join t_ncvc_pdc_ba ba on ba.ba_id = fc.fc_id left join (select dates, '06:00' h, min(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '06:00:00' and '06:55:00' group by line_cd, dates union select dates, '07:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '06:00:00' and '07:05:00' group by line_cd, dates union select dates, '08:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '07:00:00' and '08:05:00' group by line_cd, dates union select dates, '09:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '08:00:00' and '09:05:00' group by line_cd, dates union select dates, '10:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '09:00:00' and '10:05:00' group by line_cd, dates union select dates, '11:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '10:00:00' and '11:05:00' group by line_cd, dates union select dates, '12:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '11:00:00' and '12:05:00' group by line_cd, dates union select dates, '13:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '12:00:00' and '13:05:00' group by line_cd, dates union select dates, '14:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '13:00:00' and '14:05:00' group by line_cd, dates union select dates, '15:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '14:00:00' and '15:05:00' group by line_cd, dates union select dates, '16:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '15:00:00' and '16:05:00' group by line_cd, dates union select dates, '17:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '16:00:00' and '17:05:00' group by line_cd, dates union select dates, '18:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '17:00:00' and '18:05:00' group by line_cd, dates union select dates, '19:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '18:00:00' and '19:05:00' group by line_cd, dates union select dates, '20:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '19:00:00' and '20:05:00' group by line_cd, dates union select dates, '21:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '20:00:00' and '21:05:00' group by line_cd, dates union select dates, '22:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '21:00:00' and '22:05:00' group by line_cd, dates union select dates, '23:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates = :dates and times between '22:00:00' and '23:05:00' group by line_cd, dates union select dates, '00:00' h, min(times), line_cd from t_ncvc_pdc_fc where dates - 1 = :dates and times between '00:00:00' and '01:05:00' group by line_cd, dates union select dates, '01:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates - 1 = :dates and times between '00:00:00' and '01:05:00' group by line_cd, dates union select dates, '02:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates - 1 = :dates and times between '01:00:00' and '02:05:00' group by line_cd, dates union select dates, '03:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates - 1 = :dates and times between '02:00:00' and '03:05:00' group by line_cd, dates union select dates, '04:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates - 1 = :dates and times between '03:00:00' and '04:05:00' group by line_cd, dates union select dates, '05:00' h, max(times), line_cd from t_ncvc_pdc_fc where dates - 1 = :dates and times between '04:00:00' and '05:05:00' group by line_cd, dates union select dates, '05:55' h, max(times), line_cd from t_ncvc_pdc_fc where dates - 1 = :dates and times between '05:00:00' and '05:55:00' group by line_cd, dates) t on fc.line_cd = t.line_cd and fc.times = t.min where fc.line_cd = t.line_cd and fc.times = t.min order by line_cd, ca.times) tblout order by line_cd,datetimes"); sqlParameter.AddParameterDateTime("dates", inVo.StartDay); //sqlParameter.AddParameterDateTime("datesto", inVo.EndDay); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { ProductionControllerNCVCVo outVo = new ProductionControllerNCVCVo { //StartDay = DateTime.Parse(dataReader["datetimes"].ToString()), TimeHour = DateTime.Parse(dataReader["datetimes"].ToString()), ProModel = dataReader["model_cd"].ToString(), ProLine = dataReader["line_cd"].ToString(), TotalNG = int.Parse(dataReader["sum_ng"].ToString()), ProInput = int.Parse(dataReader["ba_input"].ToString()), ProOutput = int.Parse(dataReader["output"].ToString()), Final_App = int.Parse(dataReader["final_app"].ToString()), En2NG = int.Parse(dataReader["en2"].ToString()), Case_Assy = int.Parse(dataReader["case_assy"].ToString()), En1NG = int.Parse(dataReader["en1"].ToString()), Case_MG = int.Parse(dataReader["case_mg"].ToString()), MG_Bongding = int.Parse(dataReader["case_bonding"].ToString()), TrustGap = int.Parse(dataReader["trust_gap"].ToString()), Rotor = int.Parse(dataReader["rotor"].ToString()), Braket = int.Parse(dataReader["bracket_assy"].ToString()), Bracket_Metal = int.Parse(dataReader["bracket_metal"].ToString()), }; voList.add(outVo); } dataReader.Close(); return(voList); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ReportDownTimeVo inVo = (ReportDownTimeVo)vo; StringBuilder sql = new StringBuilder(); sql.Append(@"update t_downtime_report set time_from=:time_from,time_to=:time_to, prodution_work_content_id=:prodution_work_content_id,line_id=:line_id, model_id=:model_id,machine_id=:machine_id,defective_reason_id=:defective_reason_id, process_work_id=:process_work_id,remarks=:remarks"); sql.Append(" where downtime_report_id =:downtime_report_id"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("downtime_report_id", inVo.DowntimeReportId); sqlParameter.AddParameterDateTime("time_to", inVo.TimeTo); sqlParameter.AddParameterDateTime("time_from", inVo.TimeFrom); sqlParameter.AddParameterString("remarks", inVo.Remakes); sqlParameter.AddParameterInteger("downtime_report_id", inVo.GroupProcessWorkId); sqlParameter.AddParameterInteger("line_id", inVo.LineId); sqlParameter.AddParameterInteger("machine_id", inVo.MachineId); sqlParameter.AddParameterInteger("model_id", inVo.ModelId); sqlParameter.AddParameterInteger("process_work_id", inVo.ProcessWorkId); sqlParameter.AddParameterInteger("prodution_work_content_id", inVo.ProductionWorkContentId); sqlParameter.AddParameterInteger("defective_reason_id", inVo.DefectiveReasonId); //execute SQL ReportDownTimeVo outVo = new ReportDownTimeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; 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) { AssetVo inVo = (AssetVo)vo; StringBuilder sql = new StringBuilder(); sql.Append("insert into m_asset(asset_id, asset_cd,asset_no, asset_name, asset_model, asset_supplier, asset_invoice, asset_life,acquistion_date, acquistion_cost, asset_serial, asset_type, registration_user_cd, registration_date_time, factory_cd, label_status, asset_po) "); sql.Append(@"values((select max(asset_id)+1 from m_asset),:asset_cd,:asset_no, :asset_name, :asset_model, :asset_supplier,:asset_invoice, :asset_life, :acquistion_date, :acquistion_cost, :asset_serial, :asset_type, :registration_user_cd, now(), :factory_cd, :label_status, :asset_po)"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("asset_cd", inVo.AssetCode); sqlParameter.AddParameterInteger("asset_no", inVo.AssetNo); sqlParameter.AddParameterString("asset_name", inVo.AssetName); sqlParameter.AddParameterString("asset_model", inVo.AssetModel); sqlParameter.AddParameterString("asset_supplier", inVo.AssetSuppiler); sqlParameter.AddParameterString("asset_invoice", inVo.AssetInvoice); sqlParameter.AddParameterString("asset_serial", inVo.AssetSerial); sqlParameter.AddParameter("asset_life", inVo.AssetLife); sqlParameter.AddParameterDateTime("acquistion_date", inVo.AcquistionDate); sqlParameter.AddParameter("acquistion_cost", inVo.AcquistionCost); sqlParameter.AddParameterString("asset_type", inVo.AssetType); sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode); sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode); sqlParameter.AddParameterDateTime("registration_date_time", inVo.RegistrationDateTime); sqlParameter.AddParameterString("label_status", inVo.LabelStatus); sqlParameter.AddParameterString("asset_po", inVo.AssetPO); //execute SQL AssetVo outVo = new AssetVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; 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) { InspectionTestInstructionVo inVo = (InspectionTestInstructionVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_inspection_test_instruction_detail"); sqlQuery.Append(" ( "); sqlQuery.Append(" inspection_test_instruction_detail_cd,"); sqlQuery.Append(" inspection_test_instruction_detail_text,"); sqlQuery.Append(" inspection_test_instruction_detail_result_count,"); sqlQuery.Append(" inspection_test_instruction_detail_machine_text, "); sqlQuery.Append(" inspection_test_instruction_id,"); sqlQuery.Append(" registration_user_cd,"); sqlQuery.Append(" registration_date_time,"); sqlQuery.Append(" factory_cd"); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :inspectiontestinstructiondetailcd,"); sqlQuery.Append(" :inspectiontestinstructiondetailtext,"); sqlQuery.Append(" :inspectiontestinstructiondetailresultcount,"); sqlQuery.Append(" :inspectiontestinstructiondetailmachine,"); sqlQuery.Append(" :inspectiontestinstructionid,"); sqlQuery.Append(" :registrationusercode,"); sqlQuery.Append(" :regdatetime,"); sqlQuery.Append(" :factorycode"); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("inspectiontestinstructiondetailcd", inVo.InspectionTestInstructionDetailCode); sqlParameter.AddParameterString("inspectiontestinstructiondetailtext", inVo.InspectionTestInstructionDetailText); sqlParameter.AddParameterInteger("inspectiontestinstructiondetailresultcount", inVo.InspectionTestInstructionDetailResultCount); sqlParameter.AddParameterInteger("inspectiontestinstructionid", inVo.InspectionTestInstructionId); sqlParameter.AddParameterString("inspectiontestinstructiondetailmachine", inVo.InspectionTestInstructionDetailMachine); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo) { ProductionControllerVo inVo = (ProductionControllerVo)vo; StringBuilder sql = new StringBuilder(); ValueObjectList <ProductionControllerVo> voList = new ValueObjectList <ProductionControllerVo>(); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sql.Append(@"select case when max(output_data) is null then 0 else max(output_data) end output from t_productioncontroller_output04 "); sql.Append(" where 1=1 "); sql.Append(@" and dates =:dates"); sqlParameter.AddParameterDateTime("dates", DateTime.Parse(inVo.Date)); if (!String.IsNullOrEmpty(inVo.ProModel)) { sql.Append(" and model_cd =:model_cd"); sqlParameter.AddParameterString("model_cd", inVo.ProModel); } if (!String.IsNullOrEmpty(inVo.ProLine)) { sql.Append(" and line_cd =:line_cd"); sqlParameter.AddParameterString("line_cd", inVo.ProLine); } //sql.Append(" order by datetimes"); sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //execute SQL IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter); while (dataReader.Read()) { ProductionControllerVo outVo = new ProductionControllerVo { // , h., i., k., o.prodution_work_content_name ProOutput = int.Parse(dataReader["output"].ToString()), }; voList.add(outVo); } dataReader.Close(); return(voList); }
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) { 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) { MoldItemVo inVo = (MoldItemVo)arg; MoldItemVo outVo = new MoldItemVo(); // Building SQL StringBuilder sql = new StringBuilder(); sql.Append("Insert into m_mold_item"); sql.Append("("); sql.Append(" mold_id,"); sql.Append(" global_item_id,"); sql.Append(" std_cycle_time,"); sql.Append(" model_id,"); sql.Append(" drawing_no,"); sql.Append(" registration_user_cd,"); sql.Append(" registration_date_time,"); sql.Append(" factory_cd"); sql.Append(") values ("); sql.Append(" :moldid,"); sql.Append(" :globalitemid,"); sql.Append(" :stdcycletime,"); sql.Append(" :modelid,"); sql.Append(" :drawingno,"); sql.Append(" :registrationusercd,"); sql.Append(" :registrationdatetime,"); sql.Append(" :factrycode "); sql.Append(" ) "); sql.Append("RETURNING mold_item_id;"); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("moldid", inVo.MoldId); sqlParameter.AddParameterInteger("globalitemid", inVo.GlobalItemId); sqlParameter.AddParameterDecimal("stdcycletime", inVo.StdCycleTime); sqlParameter.AddParameterInteger("modelid", inVo.ModelId); sqlParameter.AddParameterString("drawingno", inVo.DrawingNo); sqlParameter.AddParameterString("registrationusercd", trxContext.UserData.UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factrycode", trxContext.UserData.FactoryCode); outVo.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("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) { InspectionItemSelectionDatatypeValueVo inVo = (InspectionItemSelectionDatatypeValueVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_inspection_item_selection_datatype_value"); sqlQuery.Append(" ( "); sqlQuery.Append(" inspection_item_selection_datatype_value_cd, "); sqlQuery.Append(" inspection_item_selection_datatype_value_text, "); sqlQuery.Append(" display_order,"); 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(" :datatypevaluecd ,"); sqlQuery.Append(" :datatypevaluetext ,"); sqlQuery.Append(" :displayorder,"); sqlQuery.Append(" :itemid,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime, "); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("datatypevaluecd", inVo.InspectionItemSelectionDatatypeValueCode); sqlParameter.AddParameterString("datatypevaluetext", inVo.InspectionItemSelectionDatatypeValueText); sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder); sqlParameter.AddParameterInteger("itemid", inVo.InspectionItemId); sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { EmployeeVo inVo = (EmployeeVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_employee"); sqlQuery.Append(" ( "); sqlQuery.Append(" employee_cd, "); sqlQuery.Append(" employee_name, "); sqlQuery.Append(" department, "); sqlQuery.Append(" is_active, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :empcd ,"); sqlQuery.Append(" :empname ,"); sqlQuery.Append(" :department ,"); sqlQuery.Append(" :isactive ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :registrationdatetime ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("empcd", inVo.EmployeeCode); sqlParameter.AddParameterString("empname", inVo.EmployeeName); sqlParameter.AddParameterString("department", inVo.Department); sqlParameter.AddParameterInteger("isactive", inVo.IsActive); sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", inVo.FactoryCode); EmployeeVo outVo = new EmployeeVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { CavityVo inVo = (CavityVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_cavity"); sqlQuery.Append(" ( "); sqlQuery.Append(" cavity_cd, "); sqlQuery.Append(" cavity_name, "); sqlQuery.Append(" mold_id, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :cavitycd ,"); sqlQuery.Append(" :cavityname ,"); sqlQuery.Append(" :moldid ,"); sqlQuery.Append(" :registrationusercode ,"); sqlQuery.Append(" :regdatetime ,"); sqlQuery.Append(" :factorycode "); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("cavitycd", inVo.CavityCode); sqlParameter.AddParameterString("cavityname", inVo.CavityName); sqlParameter.AddParameterInteger("moldid", inVo.MoldId); UserData userdata = trxContext.UserData; sqlParameter.AddParameterString("registrationusercode", userdata.UserCode); sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", userdata.FactoryCode); CavityVo outVo = new CavityVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { ItemLineInspectionFormatVo inVo = (ItemLineInspectionFormatVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append("Insert into m_item_line_inspection_format"); sqlQuery.Append(" ( "); sqlQuery.Append(" sap_matnr_item_cd,"); sqlQuery.Append(" line_id,"); sqlQuery.Append(" inspection_format_id,"); sqlQuery.Append(" registration_user_cd,"); sqlQuery.Append(" registration_date_time,"); sqlQuery.Append(" factory_cd"); sqlQuery.Append(" ) "); sqlQuery.Append("VALUES "); sqlQuery.Append(" ( "); sqlQuery.Append(" :sapitemcd,"); sqlQuery.Append(" :lineid,"); sqlQuery.Append(" :inspectionformatid,"); sqlQuery.Append(" :registrationusercode,"); sqlQuery.Append(" :regdatetime,"); sqlQuery.Append(" :factorycode"); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("sapitemcd", inVo.SapItemCode); sqlParameter.AddParameterInteger("lineid", inVo.LineId); sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId); UserData userdata = trxContext.UserData; sqlParameter.AddParameterString("registrationusercode", userdata.UserCode); sqlParameter.AddParameterDateTime("regdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycode", userdata.FactoryCode); ItemLineInspectionFormatVo outVo = new ItemLineInspectionFormatVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; 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) { LineRestTimeVo inVo = (LineRestTimeVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append(" Insert into"); sqlQuery.Append(" m_line_rest_time "); sqlQuery.Append(" ( "); sqlQuery.Append(" line_id, "); sqlQuery.Append(" shift, "); sqlQuery.Append(" plan_rest_minutes, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append(" Values "); sqlQuery.Append(" ( "); sqlQuery.Append(" :lineid, "); sqlQuery.Append(" :shift, "); sqlQuery.Append(" :planrestminutes, "); sqlQuery.Append(" :registrationusercd, "); sqlQuery.Append(" :registrationdatetime, "); sqlQuery.Append(" :factorycd "); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterInteger("lineid", inVo.LineId); sqlParameter.AddParameterInteger("shift", inVo.Shift); sqlParameter.AddParameter("planrestminutes", inVo.PlanRestMinutes); sqlParameter.AddParameterString("registrationusercd", trxContext.UserData.UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycd", trxContext.UserData.FactoryCode); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg) { LineItemCycleTimeVo inVo = (LineItemCycleTimeVo)arg; StringBuilder sqlQuery = new StringBuilder(); sqlQuery.Append(" Insert into"); sqlQuery.Append(" m_line_sap_item "); sqlQuery.Append(" ( "); sqlQuery.Append(" sap_matnr_item_cd, "); sqlQuery.Append(" line_id, "); sqlQuery.Append(" cycle_time, "); sqlQuery.Append(" registration_user_cd, "); sqlQuery.Append(" registration_date_time, "); sqlQuery.Append(" factory_cd "); sqlQuery.Append(" ) "); sqlQuery.Append(" Values "); sqlQuery.Append(" ( "); sqlQuery.Append(" :sapitemcd, "); sqlQuery.Append(" :lineid, "); sqlQuery.Append(" :cycletime, "); sqlQuery.Append(" :registrationusercd, "); sqlQuery.Append(" :registrationdatetime, "); sqlQuery.Append(" :factorycd "); sqlQuery.Append(" ); "); //create command DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString()); //create parameter DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList(); sqlParameter.AddParameterString("sapitemcd", inVo.SapItemCode); sqlParameter.AddParameterInteger("lineid", inVo.LineId); sqlParameter.AddParameterDecimal("cycletime", inVo.StdCycleTime); sqlParameter.AddParameterString("registrationusercd", trxContext.UserData.UserCode); sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime); sqlParameter.AddParameterString("factorycd", trxContext.UserData.FactoryCode); UpdateResultVo outVo = new UpdateResultVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter) }; return(outVo); }