public string GetModelFromLot(string lot, Model.SettingClass setting)
{
string model = "";
try
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select distinct isnull(model,'') from m_ERPMQC_REALTIME where 1=1 ");
stringBuilder.Append(" and lot = '" + lot + "'");
LocalPLCSql sqlERPCON = new LocalPLCSql();
model = sqlERPCON.sqlExecuteScalarString(stringBuilder.ToString(), setting);
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetModelFromLot (string lot)", ex.Message);
return("");
}
return(model);
}
