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 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)
{
UserLocationVo inVo = (UserLocationVo)vo;
ValueObjectList <UserLocationVo> voList = new ValueObjectList <UserLocationVo>();
StringBuilder sql = new StringBuilder();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select user_location_id, user_location_cd, user_location_name from m_user_location where 1=1 ");
if (!string.IsNullOrEmpty(inVo.user_location_cd))
{
sql.Append("and user_location_cd ='").Append(inVo.user_location_cd).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.user_location_name))
{
sql.Append("and user_location_name ='").Append(inVo.user_location_name).Append("' ");
}
sql.Append("order by user_location_id");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
UserLocationVo outVo = new UserLocationVo
{
user_location_id = (int)datareader["user_location_id"],
user_location_cd = datareader["user_location_cd"].ToString(),
user_location_name = datareader["user_location_name"].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 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)
{
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)
{
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 line_cd from t_ovenmachine where 1=1 ");
if (!String.IsNullOrEmpty(inVo.Model))
{
sql.Append(@" and model = :model ");
sqlParameter.AddParameterString("model", inVo.Model);
}
sql.Append(" order by line_cd");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
RangeVo outVo = new RangeVo
{
Line = dataReader["line_cd"].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)
{
AssetMaster2019Vo inVo = (AssetMaster2019Vo)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 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 arg)
{
BuildingVo inVo = (BuildingVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_building");
sqlQuery.Append(" Where ");
sqlQuery.Append(" building_id = :buildingid ");
sqlQuery.Append(" and factory_cd = :faccd ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId);
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
BuildingVo outVo = new BuildingVo {
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_mes_user");
sqlQuery.Append(" Where ");
sqlQuery.Append(" 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)
{
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)
{
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);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
LocalSupplierVo inVo = (LocalSupplierVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_local_supplier");
sqlQuery.Append(" Set ");
sqlQuery.Append(" local_supplier_name = :localsuppliername ");
sqlQuery.Append(" Where ");
sqlQuery.Append(" local_supplier_id = :localsupplierid ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("localsupplierid", inVo.LocalSupplierId);
sqlParameter.AddParameterString("localsuppliername", inVo.LocalSupplierName);
LocalSupplierVo outVo = new LocalSupplierVo { AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)};
return outVo;
}
static void Main(string[] args)
{
IDbConnector dbConnector = new SqlServerConnector(@"Data Source=CO-IT-CHATHURAN\CSBUNLIMITED; Initial Catalog=Eclipse; User id=sa; Password=5556;");
IDbParameterList dataParameters = new DbParameterList()
{
new DbDataParameter("@Id", 10, dbType: System.Data.DbType.Int32),
new DbDataParameter("@OT", 10, dbType: System.Data.DbType.Int32, direction: System.Data.ParameterDirection.Output)
};
QueryMultipleListsReturnItem <dynamic, dynamic, dynamic> t = dbConnector.ExecuteQueryMultipleStoredProcedure <dynamic, dynamic, dynamic>("[usm].[Test_DapperWrapper]", dataParameters);
var d = dbConnector.ExecuteQueryMultipleStoredProcedure("[usm].[Test_DapperWrapper]", dataParameters);
IDbParameterList dataParameters2 = new DbParameterList()
{
new DbDataParameter("@BaseAgentId", 5, dbType: System.Data.DbType.Int32)
};
var x = dbConnector.ExecuteQueryMultipleSqlText <dynamic, dynamic>(
$"SELECT * FROM usm.ApplicationUser ; Select* from usm.Agent where BaseAgentId = @BaseAgentId;",
dataParameters2);
}
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)
{
ChangePasswordVo inVo = (ChangePasswordVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select count(user_cd) as UserCount from m_login_password");
sqlQuery.Append(" Where user_cd = :usercode ");
sqlQuery.Append(" and ");
sqlQuery.Append(" password = :password ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("password", inVo.Password);
sqlParameter.AddParameterString("usercode", inVo.UserCode);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ChangePasswordVo outVo = new ChangePasswordVo();
outVo.AffectedCount = 0;
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["UserCount"].ToString());
}
dataReader.Close();
return(outVo);
}
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)
{
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 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 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 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 vo)
{
//DataTable dtadd = new DataTable();
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO t_product_serial(boxid, serialno, line, lot, thurst, thurst_mc, noise, noise_mc, model) " +
"VALUES (:boxid, :serialno, :line, :lot, :thurst, :thurst_mc, :noise, :noise_mc, :model)");
//dtadd = inVo.dt;
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("boxid", inVo.BoxID);
sqlParameter.AddParameter("serialno", inVo.A90Barcode);
sqlParameter.AddParameter("line", inVo.LineCode);
sqlParameter.AddParameter("lot", inVo.Lot);
sqlParameter.AddParameter("thurst", inVo.A90ThurstStatus);
sqlParameter.AddParameter("thurst_mc", inVo.Thurst_MC);
sqlParameter.AddParameter("noise", inVo.A90NoiseStatus);
sqlParameter.AddParameter("noise_mc", inVo.Noise_eq_id);
sqlParameter.AddParameter("model", inVo.ModelCode);
//execute SQL
GA1ModelVo outVo = new GA1ModelVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
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)
{
ProcessWorkLineVo inVo = (ProcessWorkLineVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete from m_processwork_line");
sqlQuery.Append(" where ");
sqlQuery.Append(" process_work_id = :processworkid");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId);
ProcessWorkLineVo outVo = new ProcessWorkLineVo {
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 ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("moldid", inVo.MoldId);
MoldVo outVo = new MoldVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
CauseVo inVo = (CauseVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into m_cause(machine_id,defective_reason_id,registration_user_cd,registration_date_time,factory_cd) ");
sql.Append("values");
sql.Append(" (");
sql.Append(" :machine_id,");
sql.Append(" :defective_reason_id,");
sql.Append(" :registrationusercode,");
sql.Append(" :registrationdatetime,");
sql.Append(" :factorycode ");
sql.Append(" ) ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("machine_id", inVo.MachineID);
sqlParameter.AddParameterInteger("defective_reason_id", inVo.DefectiveID);
sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode);
//execute SQL
CauseVo outVo = new CauseVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
