/// <summary> /// 得到一个对象实体 /// </summary> public SmartLaw.Model.Message DataRowToModel(DataRow row) { SmartLaw.Model.Message model = new SmartLaw.Model.Message(); if (row != null) { if (row["AutoID"] != null && row["AutoID"].ToString() != "") { model.AutoID = long.Parse(row["AutoID"].ToString()); } if (row["Title"] != null) { model.Title = row["Title"].ToString(); } if (row["Contents"] != null) { model.Contents = row["Contents"].ToString(); } if (row["Orders"] != null) { model.Orders =Int32.Parse( row["Orders"].ToString()); } if (row["MessageType"] != null) { model.MessageType = row["MessageType"].ToString(); } if (row["DisappearType"] != null) { model.DisappearType = row["DisappearType"].ToString(); } if (row["AvailableTime"] != null && row["AvailableTime"].ToString() != "") { model.AvailableTime = DateTime.Parse(row["AvailableTime"].ToString()); } if (row["ExpiredTime"] != null && row["ExpiredTime"].ToString() != "") { model.ExpiredTime = DateTime.Parse(row["ExpiredTime"].ToString()); } if (row["LastModifyTime"] != null && row["LastModifyTime"].ToString() != "") { model.LastModifyTime = DateTime.Parse(row["LastModifyTime"].ToString()); } if (row["Publisher"] != null) { model.Publisher = row["Publisher"].ToString(); } if (row["IsValid"] != null && row["IsValid"].ToString() != "") { if ((row["IsValid"].ToString() == "1") || (row["IsValid"].ToString().ToLower() == "true")) { model.IsValid = true; } else { model.IsValid = false; } } if (row["AndOr"] != null && row["AndOr"].ToString() != "") { if ((row["AndOr"].ToString() == "1") || (row["AndOr"].ToString().ToLower() == "true")) { model.AndOr = true; } else { model.AndOr = false; } } if (row["Memo"] != null) { model.Memo = row["Memo"].ToString(); } if (row["DataType"] != null) { model.DataType = row["DataType"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public SmartLaw.Model.Message GetModel(long AutoID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select AutoID,Title,Contents,Orders,MessageType,DisappearType,AvailableTime,ExpiredTime,LastModifyTime,Publisher,IsValid,AndOr,Memo,DataType from Message"); strSql.Append(" where AutoID=@AutoID limit 1"); MySqlParameter[] parameters = { new MySqlParameter("@AutoID", MySqlDbType.Int64) }; parameters[0].Value = AutoID; SmartLaw.Model.Message model = new SmartLaw.Model.Message(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }