public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select serial_short, boxid FROM product_serial_printdate WHERE printdate BETWEEN '" + System.DateTime.Today.AddDays(-7) + "' AND '" + System.DateTime.Today.AddDays(1) + "'");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DataSet ds = new DataSet();
ds = sqlCommandAdapter.ExecuteDataSet(sqlParameter);
GA1ModelVo outVo = new GA1ModelVo
{
dt = ds.Tables[0]
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into t_checkpusha90(a90_model, a90_line, a90_barcode, a90_thurst_status, a90_shipping ,a90_user_cd, a90_date, a90_time, a90_factory) ");
sql.Append("values(:a90_model,:a90_line, :a90_barcode, :a90_thurst_status,:a90_shipping,:a90_user_cd,now(),now(),:a90_factory)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("a90_model", inVo.A90Model);
sqlParameter.AddParameter("a90_line", inVo.A90Line);
sqlParameter.AddParameter("a90_barcode", inVo.A90Barcode);
sqlParameter.AddParameter("a90_thurst_status", inVo.A90ThurstStatus);
sqlParameter.AddParameter("a90_shipping", inVo.A90Shipping);
//sqlParameter.AddParameter("a90_date", inVo.Date);
//sqlParameter.AddParameter("a90_time", inVo.Time);
sqlParameter.AddParameter("a90_user_cd", inVo.RegistrationUserCode);
// sqlParameter.AddParameter("registration_date_time", inVo.RegistrationDateTime);
sqlParameter.AddParameter("a90_factory", inVo.FactoryCode);
//execute SQL
GA1ModelVo outVo = new GA1ModelVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("select boxid, serno, model, ship_date, status from t_shipment_record where serno = '" + inVo.A90Barcode + "'");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//sqlParameter.AddParameter("serno", inVo.A90Barcode);
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)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("update t_box_id set shipdate = :shipdate");
//sql.Append("where 1 = 1 and ");
sql.Append(" where boxid = :boxid");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("shipdate", inVo.ShipDate);
sqlParameter.AddParameter("boxid", inVo.BoxID);
//execute SQL
GA1ModelVo outVo = new GA1ModelVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
GA1ModelVo outVo = new GA1ModelVo();
StringBuilder sql = new StringBuilder();
StringBuilder sqlUpdate = new StringBuilder();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select count(*) from t_checkpusha90 where 1=1 ");
if (!string.IsNullOrEmpty(inVo.A90Barcode))
{
sql.Append(@" and a90_barcode =:a90_barcode");
sqlParameter.AddParameterString("a90_barcode", inVo.A90Barcode);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
int rowCount = int.Parse(sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString());
outVo = new GA1ModelVo
{
AffectedCount = rowCount,
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
//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 vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("update t_product_serial set serialno = :serialno, line = :line, thurst = :thurst, noise = :noise, lot = :lot, thurst_mc = :thurst_mc, noise_mc = :noise_mc where serialno = '" + inVo.A90Barcode + "'");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("serialno", inVo.ReplaceSerial);
sqlParameter.AddParameterString("line", inVo.LineCode);
sqlParameter.AddParameterString("thurst", inVo.A90ThurstStatus);
sqlParameter.AddParameterString("noise", inVo.A90NoiseStatus);
sqlParameter.AddParameterString("lot", inVo.Lot);
sqlParameter.AddParameterString("thurst_mc", inVo.Thurst_MC);
sqlParameter.AddParameterString("noise_mc", inVo.Noise_eq_id);
//execute SQL
GA1ModelVo outVo = new GA1ModelVo
{
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 model, line,barcode, eq_id as Machine, judgment from t_noisecheck_a90 where barcode = '" + inVo.A90Barcode + "' order by date_check desc");
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)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
GA1ModelVo outVo = new GA1ModelVo();
StringBuilder sql = new StringBuilder();
StringBuilder sqlUpdate = new StringBuilder();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select case when (select count(*) from m_user_location where user_location_cd = :user_location_cd)=1 then (select user_location_name from m_user_location where user_location_cd = :user_location_cd) else 'User ID not found' end ");
sqlParameter.AddParameterString("user_location_cd", inVo.UserCd);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
string user = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString();
outVo = new GA1ModelVo
{
UserName = user,
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
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 eq_id from t_noisecheck_a90 where 1=1 ");
if (!string.IsNullOrEmpty(inVo.LineCode))
{
sql.Append(" and line = :line ");
}
sql.Append(@" order by eq_id");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
GA1ModelVo outVo = new GA1ModelVo
{
Noise_eq_id = dataReader["eq_id"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select Count(*) as rowcount ");
sql.Append(" from t_checkpusha90");
sql.Append(" Where 1=1 ");
sql.Append(" and a90_barcode =:a90_barcode ");
sqlParameter.AddParameterString("a90_barcode", inVo.A90Barcode);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
GA1ModelVo outVo = new GA1ModelVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["rowcount"].ToString());
}
dataReader.Close();
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 a.a90_model as Model, a.a90_line as Line, a.a90_thurst_status as Thurst, a.a90_factory as Thurst_MC, a.a90_noise_status as Noise, a90_oqc_data as NG_Thurst,weight from t_checkpusha90 a left join m_machine_thurst b on a.a90_model = b.model and a.a90_line = b.line and a.a90_factory = b.machine where a90_barcode = '" + inVo.A90Barcode + "' order by a90_date + a90_time desc");
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)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into t_serno(barcode, model, line, regist_date, user_cd) values(:barcode, :model, :line, now(), :user_cd)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("barcode ", inVo.A90Barcode);
sqlParameter.AddParameter("model ", inVo.ModelCode);
sqlParameter.AddParameter("line ", inVo.LineCode);
sqlParameter.AddParameter("user_cd", UserData.GetUserData().UserCode);
//execute SQL
GA1ModelVo outVo = new GA1ModelVo
{
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 a.boxid as BoxID, a.printdate as PrintDate, a.user_cd as User, a.shipdate as ShipDate from t_box_id a left join t_product_serial b on b.boxid = a.boxid where 1 = 1");
sql.Append(" and b.serialno >= :serialno");
sqlParameter.AddParameterString("serialno", inVo.A90Barcode);
sql.Append(@" order by a.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)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
GA1ModelVo ovo = new GA1ModelVo();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select a90_model as Model, a90_line as Line, a90_thurst_status as Thurst, a90_factory as Thurst_MC, a90_noise_status as Noise, eq_id as Noise_MC from thurst_noise where a90_barcode = :a90_barcode order by oid desc limit 1");
sqlParameter.AddParameterString("a90_barcode", inVo.A90Barcode);
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 void trans(PanelCommon panel, LabelCommon lblIn, LabelCommon lblOut, LabelCommon lblYeild, string eqid)
{
GA1ModelVo Input = (GA1ModelVo)DefaultCbmInvoker.Invoke(new GetCountNoiseCbm(), new GA1ModelVo()
{
Status = true, DateFrom = dtp_From.Value, DateTo = dtp_To.Value, Noise_eq_id = eqid
});
GA1ModelVo Output = (GA1ModelVo)DefaultCbmInvoker.Invoke(new GetCountNoiseCbm(), new GA1ModelVo()
{
Status = false, DateFrom = dtp_From.Value, DateTo = dtp_To.Value, Noise_eq_id = eqid
});
lblIn.Text = "INPUT: " + Input.AffectedCount.ToString();
lblOut.Text = "OUTPUT: " + Output.AffectedCount.ToString();
if (Input.AffectedCount > 0)
{
double yeild = (double.Parse(Output.AffectedCount.ToString()) / double.Parse(Input.AffectedCount.ToString())) * 100;
lblYeild.Text = "YIELD: " + Math.Round(yeild, 3).ToString() + " %";
if (yeild < 90)//NG
{
panel.BackColor = Color.FromArgb(255, 60, 60);
}
else if (yeild >= 90 && yeild <= 95)
{
panel.BackColor = Color.Yellow;
}
else
{
panel.BackColor = Color.LightGreen;
}
}
else
{
panel.BackColor = Color.FromArgb(255, 192, 128);
}
}
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 MAX(boxid) as boxid FROM t_box_id");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
GA1ModelVo outVo = new GA1ModelVo
{
BoxID = dataReader["boxid"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
//Check duplicate barcode
public string CheckDuplicateBarcode(DataTable dt1)
{
string result = String.Empty;
GA1ModelVo outVo = new GA1ModelVo();
outVo = (GA1ModelVo)DefaultCbmInvoker.Invoke(new CheckBoxCbm(), new GA1ModelVo());
DataTable dt2 = new DataTable();
dt2 = outVo.dt;
for (int i = 0; i < dt1.Rows.Count; i++)
{
string serial = dt1.Rows[i]["Serial"].ToString();
DataRow[] dr = dt2.Select("serial_short = '" + serial + "'");
if (dr.Length >= 1)
{
string boxid = dr[0]["boxid"].ToString();
result += (i + 1 + ": " + serial + " / " + boxid + Environment.NewLine);
}
}
if (result == String.Empty)
{
return(String.Empty);
}
else
{
return(result);
}
}
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("delete from t_product_serial where boxid = '" + inVo.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
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
GA1ModelVo outVo = new GA1ModelVo();
StringBuilder sql = new StringBuilder();
StringBuilder sqlUpdate = new StringBuilder();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT count(*) FROM t_noisecheck_a90 WHERE noise_id IN (select MAX(noise_id) from t_noisecheck_a90 where registration_date_time > :datefrom and registration_date_time < :dateto AND eq_id = :eq_id GROUP BY BARCODE) ");
sqlParameter.AddParameter("eq_id ", inVo.Noise_eq_id);
sqlParameter.AddParameter("datefrom ", inVo.DateFrom);
sqlParameter.AddParameter("dateto ", inVo.DateTo);
if (!inVo.Status)//status = false => search output || status = true => search input
{
sql.Append(@" AND SUBSTRING(judgment,0,3) = 'OK'");
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
int rowCount = int.Parse(sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString());
outVo = new GA1ModelVo
{
AffectedCount = rowCount,
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
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 model,line, eq_id machine,barcode, serial_id , id, date_check, judgment, l1_v_cw, l1_v_ccw, e1_v_cw, e2_v_cw, e3_v_cw, e4_v_cw, e5_v_cw, e1_v_ccw, e2_v_ccw, e3_v_ccw, e4_v_ccw, e5_v_ccw, registration_user_cd, registration_date_time, factory_cd from t_noisecheck_a90 where ");
sql.Append(@" registration_date_time >= :datefrom and registration_date_time <= :dateto ");
sqlParameter.AddParameter("datefrom", inVo.DateFrom);
sqlParameter.AddParameter("dateto", inVo.DateTo);
if (!string.IsNullOrEmpty(inVo.Noise_eq_id))
{
sql.Append(" and eq_id = :eq_id ");
sqlParameter.AddParameter("eq_id", inVo.Noise_eq_id);
}
sql.Append("order by eq_id,date_check");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DataSet ds = sqlCommandAdapter.ExecuteDataSet(sqlParameter);
//execute SQL
GA1ModelVo outVo1 = new GA1ModelVo
{
dt = ds.Tables[0],
};
return(outVo1);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into t_box_id(boxid, printdate, user_cd) ");
sql.Append("values(:boxid, now(), :user_cd)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("boxid", inVo.BoxID);
sqlParameter.AddParameter("printdate", inVo.PrintDate);
sqlParameter.AddParameter("user_cd", inVo.User);
//execute SQL
GA1ModelVo outVo = new GA1ModelVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("update t_checkpusha90 set a90_oqc_status=:a90_oqc_status, a90_oqc_data =:a90_oqc_data ");
//sql.Append("where 1 = 1 and ");
sql.Append(" where a90_barcode=:a90_barcode");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("a90_oqc_data", inVo.A90OQCData);
sqlParameter.AddParameter("a90_barcode", inVo.A90Barcode);
sqlParameter.AddParameter("a90_oqc_status", inVo.A90OQCStatus);
//execute SQL
GA1ModelVo outVo = new GA1ModelVo
{
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 serialno as Serial, line, model, lot, thurst, thurst_mc, noise, noise_mc from t_product_serial where");
sql.Append(" boxid = :boxid");
sqlParameter.AddParameterString("boxid", inVo.BoxID);
//sqlParameter.AddParameterDateTime("printdate1", inVo.PrintDate.AddDays(1));
sql.Append(" order by serialno");
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)
{
GA1ModelVo inVo = (GA1ModelVo)vo;
GA1ModelVo outVo = new GA1ModelVo();
StringBuilder sql = new StringBuilder();
StringBuilder sqlUpdate = new StringBuilder();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT count(*) FROM t_checkpusha90 WHERE oid IN (select MAX(oid) from t_checkpusha90 where a90_date +a90_time > :datefrom and a90_date +a90_time < :dateto AND a90_factory =:a90_factory GROUP BY a90_barcode) and a90_line =:a90_line ");
sqlParameter.AddParameter("a90_factory ", inVo.Noise_eq_id);
sqlParameter.AddParameter("datefrom ", inVo.DateFrom);
sqlParameter.AddParameter("dateto ", inVo.DateTo);
sqlParameter.AddParameter("a90_line", inVo.LineCode);
if (!inVo.Status)//status = false => search output || status = true => search input
{
sql.Append(@" AND a90_thurst_status = 'OK'");
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
int rowCount = int.Parse(sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString());
outVo = new GA1ModelVo
{
AffectedCount = rowCount,
};
return(outVo);
}
private void txt_barcode_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
Checkdata();
if (txt_barcode.Text.Length == 8)
{
GA1ModelVo testbarcodeVo = new GA1ModelVo()
{
A90Barcode = txt_barcode.Text,
};
GA1ModelVo BarcodeVo = (GA1ModelVo)DefaultCbmInvoker.Invoke(new Cbm.SearchBarcodeandUpdateNGThurstCbm(), testbarcodeVo);
if (BarcodeVo.AffectedCount >= 1)//update thanh cong
{
pb_NG.Visible = true;
pb_NoData.Visible = false;
dgv_thurst.Rows.Add(txt_barcode.Text, "NG");
}
else
{
pb_NG.Visible = false;
pb_NoData.Visible = true;
}
timer1.Interval = int.Parse(txt_timer.Text) * 1000;
timer1.Enabled = true;
}
txt_barcode.Clear();
}
}
private bool checkTestTimes(string serial)
{
GA1ModelVo getList = (GA1ModelVo)DefaultCbmInvoker.Invoke(new GetTestTimeCbm(), new GA1ModelVo
{
A90Barcode = serial
});
GA1ModelVo getListNoise = (GA1ModelVo)DefaultCbmInvoker.Invoke(new GetTestTimeNoiseCbm(), new GA1ModelVo
{
A90Barcode = serial
});
dgvTestTimeThurst.DataSource = getList.dt;
dgvTestTimeNoise.DataSource = getListNoise.dt;
ShowRowNumber(dgvTestTimeThurst);
ShowRowNumber(dgvTestTimeNoise);
colorViewForFailAndBlank(ref dgvTestTimeThurst);
lblTestTime.Text = "Test Times Thurst: " + dgvTestTimeThurst.RowCount;
bool kq = false;
if (dgvTestTimeThurst.RowCount > 20)
{
lblTestTime.BackColor = Color.Red;
txt_barcode.BackColor = Color.Red;
txt_barcode.ReadOnly = true;
kq = false;
}
else
{
lblTestTime.BackColor = Color.LightGreen;
kq = true;
}
return(kq);
}
private void txtProduct_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
// Disenalbe the textbox to block scanning
//txtProduct.Enabled = false;
if (txtProduct.Text.Length != 8)
{
return;
}
DataTable dt1 = new DataTable();
GA1ModelVo getList = (GA1ModelVo)DefaultCbmInvoker.Invoke(new SearchBoxIDProductCbm(), new GA1ModelVo
{
A90Barcode = txtProduct.Text
});
dt1 = getList.dt;
// Even when no tester data is found, the module have to appear in the datagridview
DataRow newrow = dtOverall.NewRow();
string serial = txtProduct.Text;
string lot = VBStrings.Left(txtProduct.Text, 5);
// If tester data exists, show it in the datagridview
if (dt1.Rows.Count != 0)
{
string model = dt1.Rows[0][0].ToString();
string line = dt1.Rows[0][1].ToString();
string thurst = dt1.Rows[0][2].ToString();
string thurst_mc = dt1.Rows[0][3].ToString();
string noise = dt1.Rows[0][4].ToString();
string noise_mc = dt1.Rows[0][5].ToString();
newrow["Model"] = model;
newrow["Line"] = line;
newrow["Thurst"] = thurst;
newrow["Thurst_MC"] = thurst_mc;
newrow["Noise"] = noise;
newrow["Noise_MC"] = noise_mc;
}
newrow["Serial"] = serial;
newrow["Lot"] = lot;
// Add the row to the datatable
dtOverall.Rows.Add(newrow);
dgvProductSerial.DataSource = dtOverall;
txtProduct.SelectAll();
ShowRowNumber(dgvProductSerial);
colorViewForFailAndBlank(ref dgvProductSerial);
colorViewForDuplicateSerial(ref dgvProductSerial);
//colorMixedConfig(dtOverall, ref dgvProductSerial);
limitOkChange();
updateDataGripViewsSub(dtOverall, ref dgvProductSerial);
}
}
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 row_number() over(order by a90_datetime asc) stt, a90_model, a90_line, a90_barcode, a90_thurst_status, a90_noise_status, a90_oqc_status,
a90_oqc_data, a90_shipping, a90_user_cd, a90_datetime from t_checkpusha90
where 1=1 ");
if (!string.IsNullOrEmpty(inVo.A90Model))
{
sql.Append(@" and a90_model =:a90_model");
sqlParameter.AddParameterString("a90_model", inVo.A90Model);
}
if (inVo.DaTa == false)
{
sql.Append(@" and a90_datetime >= :dtpfrom and a90_datetime <= :dtpto");
}
else if (inVo.DaTa == true)
{
sql.Append(@" and a90_datetime >= :dtpfrom ");
}
sqlParameter.AddParameterDateTime("dtpfrom", inVo.DateTimeFrom);
sqlParameter.AddParameterDateTime("dtpto", inVo.DateTimeTo);
sql.Append(@" order by a90_datetime desc");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
GA1ModelVo outVo = new GA1ModelVo
{
STT = dataReader["stt"].ToString(),
A90Model = dataReader["a90_model"].ToString(),
A90Line = dataReader["a90_line"].ToString(),
A90Barcode = dataReader["a90_barcode"].ToString(),
A90ThurstStatus = dataReader["a90_thurst_status"].ToString(),
A90NoiseStatus = dataReader["a90_noise_status"].ToString(),
A90OQCStatus = dataReader["a90_oqc_status"].ToString(),
A90OQCData = dataReader["a90_oqc_data"].ToString(),
A90Shipping = bool.Parse(dataReader["a90_shipping"].ToString()),
RegistrationUserCode = dataReader["a90_user_cd"].ToString(),
RegistrationDateTime = DateTime.Parse(dataReader["a90_datetime"].ToString()),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
private void txtNewSerial_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
// Disenalbe the textbox to block scanning
if (txtNewSerial.Text.Length != 8)
{
return;
}
DataTable dt = new DataTable();
defineDataTable(ref dt);
DataTable dt1 = new DataTable();
GA1ModelVo getList = (GA1ModelVo)DefaultCbmInvoker.Invoke(new SearchBoxIDProductCbm(), new GA1ModelVo
{
A90Barcode = txtNewSerial.Text
});
dt1 = getList.dt;
// Even when no tester data is found, the module have to appear in the datagridview
DataRow newrow = dt.NewRow();
string serial = txtNewSerial.Text;
string lot = VBStrings.Left(txtNewSerial.Text, 5);
// If tester data exists, show it in the datagridview
if (dt1.Rows.Count != 0)
{
string model = dt1.Rows[0][0].ToString();
string line = dt1.Rows[0][1].ToString();
string thurst = dt1.Rows[0][2].ToString();
string thurst_mc = dt1.Rows[0][3].ToString();
string noise = dt1.Rows[0][4].ToString();
string noise_mc = dt1.Rows[0][5].ToString();
newrow["Model"] = model;
newrow["Line"] = line;
newrow["Thurst"] = thurst;
newrow["Thurst_MC"] = thurst_mc;
newrow["Noise"] = noise;
newrow["Noise_MC"] = noise_mc;
}
newrow["Serial"] = serial;
newrow["Lot"] = lot;
// Add the row to the datatable
dt.Rows.Add(newrow);
dgvNewSerial.DataSource = dt;
txtNewSerial.SelectAll();
bool col = colorViewForFailAndBlank(ref dgvNewSerial);
if (!col)
{
btnReplace.Enabled = true;
}
}
}
