public void INSN_KEYPART_DETAIL(OleExec DB, string bu, string SN_ID, string SN, string KEYPART_SN, string STATION_NAME, string PART_NO, double?SEQ_NO, string CATEGORY_NAME, string CATEGORY, string EDIT_EMP)
{
T_R_SN_KEYPART_DETAIL T_kd = new T_R_SN_KEYPART_DETAIL(DB, DB_TYPE_ENUM.Oracle);
Row_R_SN_KEYPART_DETAIL R_kd = (Row_R_SN_KEYPART_DETAIL)T_kd.NewRow();
try
{
R_kd.ID = T_kd.GetNewID(bu, DB);
R_kd.R_SN_ID = SN_ID;
R_kd.SN = SN;
R_kd.KEYPART_SN = KEYPART_SN;
R_kd.STATION_NAME = STATION_NAME;
R_kd.PART_NO = PART_NO;
R_kd.SEQ_NO = SEQ_NO;
R_kd.CATEGORY_NAME = CATEGORY_NAME;
R_kd.CATEGORY = CATEGORY;
R_kd.ORIGINAL_CSN = KEYPART_SN;
R_kd.VALID = "1";
R_kd.CREATE_EMP = EDIT_EMP;
R_kd.CREATE_TIME = GetDBDateTime(DB);
R_kd.EDIT_EMP = EDIT_EMP;
R_kd.EDIT_TIME = GetDBDateTime(DB);
DB.ExecSQL(R_kd.GetInsertString(DB_TYPE_ENUM.Oracle));
}
catch (Exception ex)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000037", new string[] { ex.Message }));
}
}
public List <R_SN_KEYPART_DETAIL> GetKeypartBySub_Sn(OleExec sfcdb, string sn, string station)
{
if (string.IsNullOrEmpty(sn))
{
return(null);
}
DataTable dt = null;
Row_R_SN_KEYPART_DETAIL row_main = null;
List <R_SN_KEYPART_DETAIL> mains = new List <R_SN_KEYPART_DETAIL>();
string sql = $@"select * from {TableName} where SN='{sn.Replace("'", "''")}' and STATION_NAME='{station}' order by SEQ_NO ";
if (DBType == DB_TYPE_ENUM.Oracle)
{
try
{
dt = sfcdb.ExecSelect(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
row_main = (Row_R_SN_KEYPART_DETAIL)this.NewRow();
row_main.loadData(dr);
mains.Add(row_main.GetDataObject());
}
}
catch (Exception ex)
{
//MES00000037
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000037", new string[] { ex.Message }));
}
}
else
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() }));
}
return(mains);
}