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