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