/// <summary> /// 得到一个对象实体 /// </summary> public YueYePlat.Model.sessions GetModel(string SessionId, string ApplicationName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select SessionId,ApplicationName,Created,Expires,LockDate,LockId,Timeout,Locked,SessionItems,Flags from sessions "); strSql.Append(" where SessionId=@SessionId and ApplicationName=@ApplicationName "); MySqlParameter[] parameters = { new MySqlParameter("@SessionId", MySqlDbType.VarChar, 80), new MySqlParameter("@ApplicationName", MySqlDbType.VarChar, 255) }; parameters[0].Value = SessionId; parameters[1].Value = ApplicationName; YueYePlat.Model.sessions model = new YueYePlat.Model.sessions(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(YueYePlat.Model.sessions model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update sessions set "); strSql.Append("Created=@Created,"); strSql.Append("Expires=@Expires,"); strSql.Append("LockDate=@LockDate,"); strSql.Append("LockId=@LockId,"); strSql.Append("Timeout=@Timeout,"); strSql.Append("Locked=@Locked,"); strSql.Append("SessionItems=@SessionItems,"); strSql.Append("Flags=@Flags"); strSql.Append(" where SessionId=@SessionId and ApplicationName=@ApplicationName "); MySqlParameter[] parameters = { new MySqlParameter("@Created", MySqlDbType.DateTime), new MySqlParameter("@Expires", MySqlDbType.DateTime), new MySqlParameter("@LockDate", MySqlDbType.DateTime), new MySqlParameter("@LockId", MySqlDbType.Int32, 10), new MySqlParameter("@Timeout", MySqlDbType.Int32, 10), new MySqlParameter("@Locked", MySqlDbType.Int16, 1), new MySqlParameter("@SessionItems", MySqlDbType.LongText), new MySqlParameter("@Flags", MySqlDbType.Int32, 10), new MySqlParameter("@SessionId", MySqlDbType.VarChar, 80), new MySqlParameter("@ApplicationName", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.Created; parameters[1].Value = model.Expires; parameters[2].Value = model.LockDate; parameters[3].Value = model.LockId; parameters[4].Value = model.Timeout; parameters[5].Value = model.Locked; parameters[6].Value = model.SessionItems; parameters[7].Value = model.Flags; parameters[8].Value = model.SessionId; parameters[9].Value = model.ApplicationName; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public YueYePlat.Model.sessions DataRowToModel(DataRow row) { YueYePlat.Model.sessions model = new YueYePlat.Model.sessions(); if (row != null) { if (row["SessionId"] != null) { model.SessionId = row["SessionId"].ToString(); } if (row["ApplicationName"] != null) { model.ApplicationName = row["ApplicationName"].ToString(); } if (row["Created"] != null && row["Created"].ToString() != "") { model.Created = DateTime.Parse(row["Created"].ToString()); } if (row["Expires"] != null && row["Expires"].ToString() != "") { model.Expires = DateTime.Parse(row["Expires"].ToString()); } if (row["LockDate"] != null && row["LockDate"].ToString() != "") { model.LockDate = DateTime.Parse(row["LockDate"].ToString()); } if (row["LockId"] != null && row["LockId"].ToString() != "") { model.LockId = int.Parse(row["LockId"].ToString()); } if (row["Timeout"] != null && row["Timeout"].ToString() != "") { model.Timeout = int.Parse(row["Timeout"].ToString()); } if (row["Locked"] != null && row["Locked"].ToString() != "") { model.Locked = int.Parse(row["Locked"].ToString()); } if (row["SessionItems"] != null) { model.SessionItems = row["SessionItems"].ToString(); } if (row["Flags"] != null && row["Flags"].ToString() != "") { model.Flags = int.Parse(row["Flags"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(YueYePlat.Model.sessions model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sessions("); strSql.Append("SessionId,ApplicationName,Created,Expires,LockDate,LockId,Timeout,Locked,SessionItems,Flags)"); strSql.Append(" values ("); strSql.Append("@SessionId,@ApplicationName,@Created,@Expires,@LockDate,@LockId,@Timeout,@Locked,@SessionItems,@Flags)"); MySqlParameter[] parameters = { new MySqlParameter("@SessionId", MySqlDbType.VarChar, 80), new MySqlParameter("@ApplicationName", MySqlDbType.VarChar, 255), new MySqlParameter("@Created", MySqlDbType.DateTime), new MySqlParameter("@Expires", MySqlDbType.DateTime), new MySqlParameter("@LockDate", MySqlDbType.DateTime), new MySqlParameter("@LockId", MySqlDbType.Int32, 10), new MySqlParameter("@Timeout", MySqlDbType.Int32, 10), new MySqlParameter("@Locked", MySqlDbType.Int16, 1), new MySqlParameter("@SessionItems", MySqlDbType.LongText), new MySqlParameter("@Flags", MySqlDbType.Int32, 10) }; parameters[0].Value = model.SessionId; parameters[1].Value = model.ApplicationName; parameters[2].Value = model.Created; parameters[3].Value = model.Expires; parameters[4].Value = model.LockDate; parameters[5].Value = model.LockId; parameters[6].Value = model.Timeout; parameters[7].Value = model.Locked; parameters[8].Value = model.SessionItems; parameters[9].Value = model.Flags; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }