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); }