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