/// <summary> /// 得到一个对象实体 /// </summary> public WMS_Database.SysLogModel DataRowToModel(DataRow row) { WMS_Database.SysLogModel model = new WMS_Database.SysLogModel(); if (row != null) { if (row["SysLog_ID"] != null) { model.SysLog_ID = row["SysLog_ID"].ToString(); } if (row["SysLog_Source"] != null) { model.SysLog_Source = row["SysLog_Source"].ToString(); } if (row["SysLog_Level"] != null) { model.SysLog_Level = row["SysLog_Level"].ToString(); } if (row["SysLog_Time"] != null && row["SysLog_Time"].ToString() != "") { model.SysLog_Time = DateTime.Parse(row["SysLog_Time"].ToString()); } if (row["SysLog_Content"] != null) { model.SysLog_Content = row["SysLog_Content"].ToString(); } if (row["SysLog_Reserve1"] != null) { model.SysLog_Reserve1 = row["SysLog_Reserve1"].ToString(); } if (row["SysLog_Reserve2"] != null) { model.SysLog_Reserve2 = row["SysLog_Reserve2"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public WMS_Database.SysLogModel GetModel(string SysLog_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SysLog_ID,SysLog_Source,SysLog_Level,SysLog_Time,SysLog_Content,SysLog_Reserve1,SysLog_Reserve2 from SysLog "); strSql.Append(" where SysLog_ID=@SysLog_ID "); SqlParameter[] parameters = { new SqlParameter("@SysLog_ID", SqlDbType.NVarChar, 50) }; parameters[0].Value = SysLog_ID; WMS_Database.SysLogModel model = new WMS_Database.SysLogModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }