public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
JigCauseVo inVo = (JigCauseVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select Count(*) as JigCauseCount ");
sql.Append(" from public.m_jig_cause");
sql.Append(" Where 1=1 ");
if (!String.IsNullOrEmpty(inVo.FactoryCode))
{
sql.Append(" and factory_cd = :factory_cd ");
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
}
if (!string.IsNullOrEmpty(inVo.JigCauseCode))
{
sql.Append(" and UPPER(jig_cause_cd) = UPPER(:jig_cause_cd) ");
sqlParameter.AddParameterString("jig_cause_cd", inVo.JigCauseCode);
}
if (inVo.JigCauseId > 0)
{
sql.Append(" and jig_cause_id != :jig_cause_id "); ///?????
sqlParameter.AddParameterInteger("jig_cause_id", inVo.JigCauseId);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
JigCauseVo outVo = new JigCauseVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["JigCauseCount"].ToString());
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
FactoryProductionDaysVo inVo = (FactoryProductionDaysVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append(" SELECT ");
sqlQuery.Append(" Count(*) AS FactoryProductionDaysCount ");
sqlQuery.Append(" FROM ");
sqlQuery.Append(" m_factory_production_days ");
sqlQuery.Append(" WHERE 1 = 1 ");
sqlQuery.Append(" AND UPPER(factory_cd) = UPPER(:factorycode) ");
sqlQuery.Append(" AND building_id = :buildingid ");
sqlQuery.Append(" AND year = :iyear ");
sqlQuery.Append(" AND month = :imonth ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factorycode", inVo.FactoryCode);
sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId);
sqlParameter.AddParameterInteger("iyear", inVo.iYear);
sqlParameter.AddParameterInteger("imonth", inVo.iMonth);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
FactoryProductionDaysVo outVo = new FactoryProductionDaysVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["FactoryProductionDaysCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ItemVo inVo = (ItemVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as ItemCount from m_local_item ");
sqlQuery.Append(" where factory_cd = :faccd ");
if (inVo.ItemCode != null)
{
sqlQuery.Append(" and UPPER(item_cd) = UPPER(:itemcd)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.ItemCode != null)
{
sqlParameter.AddParameterString("itemcd", inVo.ItemCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ItemVo outVo = new ItemVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["ItemCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorkMachineVo inVo = (ProcessWorkMachineVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as WorkCount from m_processwork_machine");
sqlQuery.Append(" where factory_cd = :faccd ");
if (inVo.MachineId >= 0)
{
sqlQuery.Append(" and machine_id = :machineid");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.MachineId >= 0)
{
sqlParameter.AddParameterInteger("machineid", inVo.MachineId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ProcessWorkMachineVo outVo = new ProcessWorkMachineVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["WorkCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
SapItemSearchVo inVo = (SapItemSearchVo)arg;
StringBuilder sqlQuery = new StringBuilder();
//create SQL
sqlQuery.Append("SELECT ");
sqlQuery.Append(" si.sap_matnr_item_cd, ");
sqlQuery.Append(" CONCAT(si.sap_matnr_item_cd, ' - ', si.sap_maktx_item_name) as sap_maktx_item_name");
sqlQuery.Append(" FROM sap_item si");
sqlQuery.Append(" WHERE si.factory_cd = :factorycode ORDER BY si.sap_matnr_item_cd ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
//execute SQL
ValueObjectList <SapItemSearchVo> outVo = null;
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
SapItemSearchVo currVo = new SapItemSearchVo();
currVo.SapItemCode = ConvertDBNull <string>(dataReader, "sap_matnr_item_cd");
currVo.SapItemName = ConvertDBNull <string>(dataReader, "sap_maktx_item_name");
if (outVo == null)
{
outVo = new ValueObjectList <SapItemSearchVo>();
}
outVo.add(currVo);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
CustomerVo inVo = (CustomerVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as CuCount from m_customer ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.CustomerCode != null)
{
sqlQuery.Append(" and UPPER(customer_cd) = UPPER(:cucode) ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.CustomerCode != null)
{
sqlParameter.AddParameterString("cucode", inVo.CustomerCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
CustomerVo outVo = new CustomerVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["CuCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select Count(*) as CountNum ");
sql.Append(" from m_work_content_type");
sql.Append(" Where 1=1 ");
if (!String.IsNullOrEmpty(inVo.FactoryCode))
{
sql.Append(" and factory_cd = :factory_cd ");
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
}
if (!string.IsNullOrEmpty(inVo.ProdutionWorkContentTypeCode))
{
sql.Append(" and UPPER(work_content_type_cd) = UPPER(:prodution_work_content_type_cd) ");
sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode);
}
if (inVo.ProdutionWorkContentTypeId > 0)
{
sql.Append(" and work_content_type_id != :prodution_work_content_type_id ");
sqlParameter.AddParameterInteger("prodution_work_content_type_id", inVo.ProdutionWorkContentTypeId);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["CountNum"].ToString());
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AccountInfoVo inVo = (AccountInfoVo)vo;
StringBuilder sql = new StringBuilder();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select * from t_account_main where 1=1 ");
sql.Append("and account_main_id ='").Append(inVo.account_main_id).Append("' ");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
inVo.asset_id = (int)datareader["asset_id"];
inVo.qty = (int)datareader["qty"];
inVo.unit_id = (int)datareader["unit_id"];
inVo.account_code_id = (int)datareader["account_code_id"];
inVo.account_location_id = (int)datareader["account_location_id"];
inVo.rank_id = (int)datareader["rank_id"];
inVo.comment_data = datareader["comment_data"].ToString();
inVo.depreciation_start = (DateTime)datareader["depreciation_start"];
inVo.depreciation_end = (DateTime)datareader["depreciation_end"];
inVo.current_depreciation = (double)datareader["current_depreciation"];
inVo.monthly_depreciation = (double)datareader["monthly_depreciation"];
inVo.accum_depreciation = (double)datareader["accum_depreciation_now"];
inVo.net_value = (double)datareader["net_value"];
inVo.location_id = (int)datareader["location_id"];
inVo.user_location_id = (int)datareader["user_location_id"];
inVo.registration_user_cd = datareader["registration_user_cd"].ToString();
inVo.registration_date_time = (DateTime)datareader["registration_date_time"];
inVo.factory_cd = datareader["factory_cd"].ToString();
inVo.invertory_time_id = (int)datareader["invertory_time_id"];
}
datareader.Close();
return(inVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldCategoryVo inVo = (MoldCategoryVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("select count(mc.mold_category_cd) as CategoryCount from m_mold_detail md");
sqlQuery.Append(" inner join m_mold_category mc on mc.mold_category_id = md.mold_category_id");
sqlQuery.Append(" where mc.factory_cd = :factorycode ");
if (inVo.MoldCategoryCode != null)
{
sqlQuery.Append(" and UPPER(mold_category_cd) = UPPER(:moldcategorycd) ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
if (inVo.MoldCategoryCode != null)
{
sqlParameter.AddParameterString("moldcategorycd", inVo.MoldCategoryCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
MoldCategoryVo outVo = new MoldCategoryVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32("0" + dataReader["CategoryCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
MoldTypeVo inVo = (MoldTypeVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("select Count(mo.mold_cd) as MoldCount from m_mold_type mt");
sqlQuery.Append(" inner join m_mold mo on mt.mold_type_id = mo.mold_type_id");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.MoldTypeCode != null)
{
sqlQuery.Append(" and UPPER(mold_type_cd) = UPPER(:moldtypecd)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.MoldTypeCode != null)
{
sqlParameter.AddParameterString("moldtypecd", inVo.MoldTypeCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
MoldTypeVo outVo = new MoldTypeVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32("0" + dataReader["MoldCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
WarehouseVTVo inVo = (WarehouseVTVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <WarehouseVTVo> voList = new ValueObjectList <WarehouseVTVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select Count(*) as count
from t_vt_machine
where 1=1 ");
sql.Append(" and machine_serial =:machine_serial");
sqlParameter.AddParameter("machine_serial", inVo.MachineSerial);
if (!String.IsNullOrEmpty(inVo.RFId))
{
sql.Append(@" or rfid_cd =:rfid_cd");
sqlParameter.AddParameter("rfid_cd", inVo.RFId);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
WarehouseVTVo outVo = new WarehouseVTVo
{
CheckCountID = dataReader["count"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DocumentVo inVo = (DocumentVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <DocumentVo> voList = new ValueObjectList <DocumentVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT document_cd from t_document where 1 = 1");
if (!String.IsNullOrEmpty(inVo.DocumentType))
{
sql.Append(" and document_type =:document_type ");
sqlParameter.AddParameterString("document_type", inVo.DocumentType);
}
sql.Append(" and model_id =:model_id ");
sqlParameter.AddParameterInteger("model_id", inVo.ModelID);
sql.Append(" order by document_cd");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
DocumentVo outVo = new DocumentVo
{
DocumentCode = dataReader["document_cd"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select sapusr.mes_user_cd,sapusr.sap_user,sapusr.sap_password");
sqlQuery.Append(" from m_sap_user sapusr");
sqlQuery.Append(" inner join m_mes_user usr on usr.user_cd = sapusr.mes_user_cd");
sqlQuery.Append(" inner join m_user_factory uf on usr.user_cd = uf.user_cd");
sqlQuery.Append(" where usr.user_cd = :usercode ");
sqlQuery.Append(" and uf.factory_cd = :factorycode ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("usercode", trxContext.UserData.UserCode);
sqlParameter.AddParameterString("factorycode", trxContext.UserData.FactoryCode);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
SapUserVo outVo = null;
while (dataReader.Read())
{
outVo = new SapUserVo();
outVo.MesUserCode = DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["mes_user_cd"]);
outVo.SapUser = DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["sap_user"]);
outVo.SapPassWord = DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["sap_password"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
DefectiveCategoryVo inVo = (DefectiveCategoryVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as DefectiveCategoryCount from m_defective_category ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.DefectiveCategoryCode != null)
{
sqlQuery.Append(" and UPPER(defective_category_cd) = UPPER(:defectiveCategorycd)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.DefectiveCategoryCode != null)
{
sqlParameter.AddParameterString("defectiveCategorycd", inVo.DefectiveCategoryCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
DefectiveCategoryVo outVo = new DefectiveCategoryVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["DefectiveCategoryCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorkVo inVo = (ProcessWorkVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as DisplayCount from m_process_work");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.ProcessWorkCode != null)
{
sqlQuery.Append(" and display_order = :displayorder");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.DisplayOrder > 0)
{
sqlParameter.AddParameterInteger("displayorder", inVo.DisplayOrder);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ProcessWorkVo outVo = new ProcessWorkVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["DisplayCount"]);
}
dataReader.Close();
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 distinct b.line_cd from m_model_line a
left join m_line b on b.line_id = a.line_id
left join m_model c on c.model_id = a.model_id
where 1=1 ");
if (!string.IsNullOrEmpty(inVo.ModelCode))
{
sql.Append(@" and c.model_cd =:model_cd");
sqlParameter.AddParameterString("model_cd", inVo.ModelCode);
}
sql.Append(@" order by b.line_cd");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
GA1ModelVo outVo = new GA1ModelVo
{
LineCode = dataReader["line_cd"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessFlowRuleVo inVo = (ProcessFlowRuleVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as RuleCount from m_process_flow_rule ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.ProcessFlowRuleCode != null)
{
sqlQuery.Append(" and UPPER(process_flow_rule_cd) = UPPER(:processflowrulecd)");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.ProcessFlowRuleCode != null)
{
sqlParameter.AddParameterString("processflowrulecd", inVo.ProcessFlowRuleCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ProcessFlowRuleVo outVo = new ProcessFlowRuleVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["RuleCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
FunctionDeptVo inVo = (FunctionDeptVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select Count(*) as FunctionCount ");
sql.Append(" from vcb_functiondept");
sql.Append(" Where 1=1 ");
if (!string.IsNullOrEmpty(inVo.FunctionDeptCode))
{
sql.Append(" and UPPER(vcb_functiondept_cd) = UPPER(:vcb_functiondept_cd) ");
sqlParameter.AddParameterString("vcb_functiondept_cd", inVo.FunctionDeptCode);
}
if (inVo.FunctionDeptId > 0)
{
sql.Append(" and vcb_department_id != :vcb_department_id "); ///?????
sqlParameter.AddParameterInteger("vcb_department_id", inVo.FunctionDeptId);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
FunctionDeptVo outVo = new FunctionDeptVo();
while (dataReader.Read())
{
outVo.CheckRow = Convert.ToInt32(dataReader["FunctionCount"].ToString());
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
WareHouseMainVo inVo = ( WareHouseMainVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <WareHouseMainVo> voList = new ValueObjectList <WareHouseMainVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select g.warehouse_main_id from t_warehouse_main g
left join m_asset e on e.asset_id = g.asset_id
where 1=1 ");
if (!String.IsNullOrEmpty(inVo.AssetCode))
{
sql.Append(@" and e.asset_cd =:asset_cd");
sqlParameter.AddParameterString("asset_cd", inVo.AssetCode);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
WareHouseMainVo outVo = new WareHouseMainVo
{
WareHouseMainId = int.Parse(dataReader["warehouse_main_id"].ToString()),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
IPQCVo inVo = (IPQCVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <IPQCVo> voList = new ValueObjectList <IPQCVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select no, model, process, inspect, description, upper, lower, instrument, clm_set, row_set from tbl_measure_item where model='" + inVo.Model + "' order by no, process, inspect");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
IPQCVo outVo = new IPQCVo
{
No = dataReader["no"].ToString(),
Model = dataReader["model"].ToString(),
Process = dataReader["process"].ToString(),
Inspect = dataReader["inspect"].ToString(),
Description = dataReader["description"].ToString(),
Upper = double.Parse(dataReader["upper"].ToString()),
Lower = double.Parse(dataReader["lower"].ToString()),
Instrument = dataReader["instrument"].ToString(),
ClmSet = int.Parse(dataReader["clm_set"].ToString()),
RowSet = int.Parse(dataReader["row_set"].ToString())
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
AccountCodeVo inVo = (AccountCodeVo)vo;
ValueObjectList <AccountCodeVo> voList = new ValueObjectList <AccountCodeVo>();
StringBuilder sql = new StringBuilder();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select account_code_id, account_code_cd, account_code_name from m_account_code where 1=1 ");
if (!string.IsNullOrEmpty(inVo.account_code_cd))
{
sql.Append("and account_code_cd='").Append(inVo.account_code_cd).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.account_code_name))
{
sql.Append("and account_code_name='").Append(inVo.account_code_name).Append("' ");
}
sql.Append("order by account_code_id");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
AccountCodeVo outVo = new AccountCodeVo
{
account_code_id = (int)datareader["account_code_id"],
account_code_cd = datareader["account_code_cd"].ToString(),
account_code_name = datareader["account_code_name"].ToString()
};
voList.add(outVo);
}
datareader.Close();
base.CloseConnection(trxContext);
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
InspectionTestInstructionVo inVo = (InspectionTestInstructionVo)arg;
StringBuilder sql = new StringBuilder();
//create SQL
sql.Append("Select inspection_test_instruction_detail_result_count from m_inspection_test_instruction_detail");
sql.Append(" where factory_cd = :faccd ");
if (inVo.InspectionTestInstructionId > 0)
{
sql.Append(" and inspection_test_instruction_id = :inspectiontestinstructionid ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("inspectiontestinstructionid", inVo.InspectionTestInstructionId);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
InspectionTestInstructionVo outVo = new InspectionTestInstructionVo { AffectedCount = 0 };
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["inspection_test_instruction_detail_result_count"]);
}
dataReader.Close();
return outVo;
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
OvenBarcodeVo inVo = (OvenBarcodeVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <OvenBarcodeVo> voList = new ValueObjectList <OvenBarcodeVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select distinct line_cd from t_ovenmachine_ls
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())
{
OvenBarcodeVo outVo = new OvenBarcodeVo
{
Line = dataReader["line_cd"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
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 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 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)
{
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)
{
DetailPositionVo inVo = (DetailPositionVo)vo;
ValueObjectList <DetailPositionVo> voList = new ValueObjectList <DetailPositionVo>();
StringBuilder sql = new StringBuilder();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select distinct detail_postion_id, detail_postion_cd, detail_postion_name from m_detail_postion where 1=1 ");
if (!string.IsNullOrEmpty(inVo.detail_postion_cd))
{
sql.Append("and detail_postion_cd='").Append(inVo.detail_postion_cd).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.detail_postion_name))
{
sql.Append("and detail_postion_name='").Append(inVo.detail_postion_name).Append("' ");
}
sql.Append("order by detail_postion_id");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
DetailPositionVo outVo = new DetailPositionVo
{
detail_postion_id = (int)datareader["detail_postion_id"],
detail_postion_cd = datareader["detail_postion_cd"].ToString(),
detail_postion_name = datareader["detail_postion_name"].ToString()
};
voList.add(outVo);
}
datareader.Close();
return(voList);
}