public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CavityVo inVo = (CavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_cavity");
sqlQuery.Append(" Where mold_id = :moldid");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("moldid", inVo.MoldId);
CavityVo outVo = new CavityVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TransferVo inVo = (TransferVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select Count(*) as AssetCount from t_transfer_detail_info where 1 = 1 and asset_id = :asset_id ");
sqlParameter.AddParameterInteger("asset_id", inVo.AssetID);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
TransferVo outVo = new TransferVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["AssetCount"].ToString());
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
FactoryProductionDaysVo inVo = (FactoryProductionDaysVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append(" DELETE from");
sqlQuery.Append(" m_factory_production_days ");
sqlQuery.Append(" WHERE ");
sqlQuery.Append(" factory_production_days_id = :factoryproductiondaysid; ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("factoryproductiondaysid", inVo.FactoryProductionDaysId);
FactoryProductionDaysVo outVo = new FactoryProductionDaysVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
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)
{
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_inspection_item_selection_datatype_value");
sqlQuery.Append(" where factory_cd = :faccd ");
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);
UpdateResultVo outVo = new UpdateResultVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
UserVo inVo = (UserVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete from m_login_password");
sqlQuery.Append(" Where user_cd = :usercode ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("usercode", inVo.UserCode);
UserVo outVo = new UserVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldVo inVo = (MoldVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_mold");
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("faccd", UserData.GetUserData().FactoryCode);
MoldVo outVo = new MoldVo {AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)};
return outVo;
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CustomerVo inVo = (CustomerVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_customer");
sqlQuery.Append(" Set ");
sqlQuery.Append(" customer_name = :cuname,");
sqlQuery.Append(" address1 = :add1, ");
sqlQuery.Append(" address2 = :add2, ");
sqlQuery.Append(" phone_no = :phno, ");
sqlQuery.Append(" email = :email, ");
sqlQuery.Append(" remarks = :rem ");
sqlQuery.Append(" Where ");
sqlQuery.Append(" customer_id = :cuid ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("cuid", inVo.CustomerId);
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);
CustomerVo outVo = new CustomerVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
//Delete BoxID
StringBuilder sql = new StringBuilder();
sql.Append("delete from t_box_id where boxid = :boxid");
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("boxid", inVo.BoxID);
sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
//Delete Production
StringBuilder sqlDelPro = new StringBuilder();
sqlDelPro.Append("delete from t_product_serial where boxid = :boxid");
DbCommandAdaptor sqlCommandAdapterDelPro = base.GetDbCommandAdaptor(trxContext, sqlDelPro.ToString());
DbParameterList sqlParameterDelPro = sqlCommandAdapterDelPro.CreateParameterList();
sqlParameterDelPro.AddParameter("boxid", inVo.BoxID);
sqlCommandAdapterDelPro.ExecuteNonQuery(sqlParameterDelPro);
GA1ModelVo outVo = new GA1ModelVo
{
AffectedCount = 1
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DocumentVo inVo = (DocumentVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"insert into t_document(document_cd, document_name, document_type, model_id, department, groups, revision,
update_date_time, registration_user_cd, registration_date_time, factory_cd)");
sql.Append(@"values(:document_cd, :document_name, :document_type, :model_id, :department, :groups, :revision,
now(), :registration_user_cd, now(), :factory_cd)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("document_id", inVo.DocumentID);
sqlParameter.AddParameter("document_cd", inVo.DocumentCode);
sqlParameter.AddParameter("document_name", inVo.DocumentName);
sqlParameter.AddParameter("document_type", inVo.DocumentType);
sqlParameter.AddParameter("model_id", inVo.ModelID);
sqlParameter.AddParameter("department", inVo.Department);
sqlParameter.AddParameter("groups", inVo.Group);
sqlParameter.AddParameter("revision", inVo.Revision);
sqlParameter.AddParameter("update_date_time", inVo.TimeFrom);
sqlParameter.AddParameter("registration_user_cd", inVo.RegistrationUserCode);
sqlParameter.AddParameter("registration_date_time", inVo.RegistrationDateTime);
sqlParameter.AddParameter("factory_cd", inVo.FactoryCode);
//execute SQL
DocumentVo outVo = new DocumentVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
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, 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("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);
//execute SQL
ReportDownTimeVo outVo = new ReportDownTimeVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
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_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) ");
sql.Append("values(: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)");
//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);
//execute SQL
AssetVo outVo = new AssetVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DetailPositionVo inVo = (DetailPositionVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select Count(*) as DetailPositionCounter ");
sql.Append(" from m_detail_postion");
sql.Append(" Where 1=1 ");
if (!string.IsNullOrEmpty(inVo.DetailPositionCode))
{
sql.Append(" and UPPER(detail_postion_cd) = UPPER(:detail_postion_cd) ");
sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode);
}
if (inVo.DetailPositionId > 0)
{
sql.Append(" and detail_postion_id != :detail_postion_id "); ///?????
sqlParameter.AddParameterInteger("detail_postion_id", inVo.DetailPositionId);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
DetailPositionVo outVo = new DetailPositionVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["DetailPositionCounter"].ToString());
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
StockLocationVo inVo = (StockLocationVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as DisplayCount from m_stock_location");
sqlQuery.Append(" where factory_cd = :factcd ");
sqlQuery.Append(" and display_order = :displayorder");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factcd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
StockLocationVo outVo = null;
while (dataReader.Read())
{
outVo = new StockLocationVo();
outVo.AffectedCount = Convert.ToInt32(dataReader["DisplayCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ProductionControllerGA1Vo inVo = (ProductionControllerGA1Vo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <ProductionControllerGA1Vo> voList = new ValueObjectList <ProductionControllerGA1Vo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select distinct process from " + inVo.TableName);
sql.Append(" where 1=1 ");
if (!string.IsNullOrEmpty(inVo.LineCode))
{
sql.Append(@" and line =:line");
sqlParameter.AddParameterString("line", inVo.LineCode);
}
sql.Append(@" order by process");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
ProductionControllerGA1Vo outVo = new ProductionControllerGA1Vo
{
ProcessCode = dataReader["process"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
RangeVo inVo = (RangeVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <RangeVo> voList = new ValueObjectList <RangeVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select distinct range_process from m_ovenmachinels12_range where 1=1 ");
if (!String.IsNullOrEmpty(inVo.Model))
{
sql.Append(@" and range_model = :range_model ");
sqlParameter.AddParameterString("range_model", inVo.Model);
}
sql.Append(" order by range_process");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
RangeVo outVo = new RangeVo
{
Process = dataReader["range_process"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
AddBatchProcessVo inVo = (AddBatchProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("SELECT ");
sqlQuery.Append(" batch_process_cd");
sqlQuery.Append(" FROM t_batch_process ");
sqlQuery.Append(" WHERE batch_process_cd = :batchprocesscd ");
sqlQuery.Append(" AND factory_cd = :factorycd ");
sqlQuery.Append(" FOR UPDATE ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("batchprocesscd", inVo.BatchProcessCode);
sqlParameter.AddParameterString("factorycd", trxContext.UserData.FactoryCode);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
AddBatchProcessVo outVo = null;
while (dataReader.Read())
{
outVo = new AddBatchProcessVo();
outVo.BatchProcessCode = ConvertDBNull <string>(dataReader, "batch_process_cd");
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
RankInfoVo inVo = (RankInfoVo)vo;
ValueObjectList <RankInfoVo> voList = new ValueObjectList <RankInfoVo>();
StringBuilder sql = new StringBuilder();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select rank_id, rank_cd, rank_name from m_rank where 1=1 ");
if (!string.IsNullOrEmpty(inVo.rank_cd))
{
sql.Append("and rank_cd='").Append(inVo.rank_cd).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.rank_name))
{
sql.Append("and rank_name='").Append(inVo.rank_name).Append("' ");
}
sql.Append("order by rank_id");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
RankInfoVo outVo = new RankInfoVo
{
rank_id = (int)datareader["rank_id"],
rank_cd = datareader["rank_cd"].ToString(),
rank_name = datareader["rank_name"].ToString()
};
voList.add(outVo);
}
datareader.Close();
return(voList);
}
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());
if (rowCount > 0)//neu co barcode
{
sqlUpdate.Append("update t_checkpusha90 set a90_oqc_data = 'NG' where a90_barcode = '" + inVo.A90Barcode + "'");
DbCommandAdaptor sqlCommandAdapterUpdate = base.GetDbCommandAdaptor(trxContext, sqlUpdate.ToString());
DbParameterList sqlParameterUpdate = sqlCommandAdapterUpdate.CreateParameterList();
sqlParameterUpdate.AddParameterString("a90_barcode2", inVo.A90Barcode);
outVo = new GA1ModelVo
{
AffectedCount = sqlCommandAdapterUpdate.ExecuteNonQuery(sqlParameterUpdate)
};
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AssetMasterFAWHVo inVo = (AssetMasterFAWHVo)vo;
StringBuilder sql = new StringBuilder();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("DELETE from m_asset where 1=1 ");
if (!string.IsNullOrEmpty(inVo.asset_cd))
{
sql.Append("and asset_cd = '").Append(inVo.asset_cd).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.asset_name))
{
sql.Append("and asset_name = '").Append(inVo.asset_name).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.asset_type))
{
sql.Append("and asset_type = '").Append(inVo.asset_type).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.asset_life))
{
sql.Append("and asset_life = '").Append(inVo.asset_life).Append("' ");
}
//if (inVo.checkDateFrom)
// sql.Append("and acquistion_date > '").Append(inVo.dateFrom.ToString("yyyy-MM-dd")).Append("' ");
//if (inVo.checkDateTo)
// sql.Append("and acquistion_date < '").Append(inVo.dateTo.ToString("yyyy-MM-dd")).Append("' ");
//sql.Append("order by asset_cd");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//EXECUTE READER FROM COMMAND
int datareader = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(inVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
RoleVo inVo = (RoleVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_mes_role");
sqlQuery.Append(" Where ");
sqlQuery.Append(" role_cd = :rolecd ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("rolecd", inVo.RoleCode);
RoleVo outVo = new RoleVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <GA1ModelVo> voList = new ValueObjectList <GA1ModelVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select a90_barcode,a90_thurst_status from t_checkpusha90 where 1=1 ");
if (!string.IsNullOrEmpty(inVo.A90Barcode))
{
sql.Append(@" and oid = (select max(oid) oid from t_checkpusha90 where a90_barcode = :a90_barcode)");
sqlParameter.AddParameterString("a90_barcode", inVo.A90Barcode);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
GA1ModelVo outVo = new GA1ModelVo
{
A90Barcode = dataReader["a90_barcode"].ToString(),
A90ThurstStatus = dataReader["a90_thurst_status"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
FactoryVo inVo = (FactoryVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete from m_factory");
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);
FactoryVo outVo = new FactoryVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
SapUserVo inVo = (SapUserVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete from m_sap_user");
sqlQuery.Append(" Where ");
sqlQuery.Append(" sap_user_id = :sapuserid ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("sapuserid", inVo.SapUserId);
SapUserVo outVo = new SapUserVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MaintenanceMachineVTVo inVo = (MaintenanceMachineVTVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("Delete From t_vt_maintenance");
sql.Append(" Where ");
sql.Append(" machine_serial = :machine_serial ;");
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("machine_serial", inVo.MachineSerial);
MaintenanceMachineVTVo outVo = new MaintenanceMachineVTVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
GA1ModelVo voList = new GA1ModelVo();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select boxid, printdate, user_cd as User, shipdate, child_model from t_box_id where 1 = 1");
DateTime nextdate = inVo.PrintDate.AddDays(1);
sql.Append(" and printdate >= '" + inVo.PrintDate + "' and printdate < '" + nextdate + "'");
//sqlParameter.AddParameterDateTime("printdate", inVo.PrintDate);
//sqlParameter.AddParameterDateTime("printdate1", inVo.PrintDate.AddDays(1));
sql.Append(" order by boxid");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DataSet ds = new DataSet();
ds = sqlCommandAdapter.ExecuteDataSet(sqlParameter);
//execute SQL
//IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
GA1ModelVo outVo = new GA1ModelVo
{
dt = ds.Tables[0]
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CastingMachineVo inVo = (CastingMachineVo)arg;
CastingMachineVo outVo = new CastingMachineVo();
StringBuilder sql = new StringBuilder();
sql.Append("Delete from m_casting_machine");
sql.Append(" where ");
sql.Append(" casting_machine_id = :castid");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("castid", inVo.CastingMachineId);
outVo.AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
InspectionProcessVo inVo = (InspectionProcessVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("select");
sqlQuery.Append(" inspection_process_cd ");
sqlQuery.Append(" from m_inspection_process");
sqlQuery.Append(" where factory_cd = :faccd ");
sqlQuery.Append(" and inspection_format_id = :inspectionformatid ");
sqlQuery.Append(" order by inspection_process_id desc ");
sqlQuery.Append(" limit 1 ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("inspectionformatid", inVo.InspectionFormatId);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
InspectionProcessVo currOutVo = new InspectionProcessVo();
while (dataReader.Read())
{
currOutVo.InspectionProcessCode = ConvertDBNull <string>(dataReader, "inspection_process_cd");
}
dataReader.Close();
return(currOutVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocalSupplierCavityVo inVo = (LocalSupplierCavityVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_local_supplier_cavity");
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.LocalSupplierCavityId);
LocalSupplierCavityVo outVo = new LocalSupplierCavityVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AccountMainVo inVo = (AccountMainVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"update t_account_main set rank_id =:rank_id,
location_id =:location_id,
user_location_id =:user_location_id,
registration_user_cd =:registration_user_cd,
registration_date_time= :registration_date_time");
sql.Append(" where asset_id =:asset_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//sqlParameter.AddParameter("asset_id", inVo.AcountMainId);
sqlParameter.AddParameter("asset_id", inVo.AssetId);
sqlParameter.AddParameter("rank_id", inVo.RankId);
sqlParameter.AddParameter("location_id", inVo.LocationId);
sqlParameter.AddParameter("user_location_id", inVo.UserLocationId);
sqlParameter.AddParameter("registration_user_cd", inVo.RegistrationUserCode);
sqlParameter.AddParameter("registration_date_time", inVo.RegistrationDateTime);
//execute SQL
AccountMainVo outVo = new AccountMainVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}