/// <summary>
/// 根据条件语句取得第一个实体
/// </summary>
/// <param name="m_where">条件语句，不包含“where”</param>
/// <returns></returns>
public static MovieUrl Find(string m_where)
{
IDbHelper Sql = GetHelper();
MovieUrl M = new MovieUrl();
DbDataReader Rs = Sql.ExecuteReader(CommandType.Text, "select [id],[MoviewID],[MoviewTitle],[Title],[UpdateTime],[Enable],[HttpUrl],[MagUrl],[KuaibUrl],[BaiduUrl] from [MovieUrl] where " + m_where, true);
if (!Rs.Read())
{
M.Id = long.MinValue;
}
else
{
M.Id = Rs["id"].ToInt64();
M.MoviewID = Rs["MoviewID"].ToInt32();
M.MoviewTitle = Rs["MoviewTitle"].ToString();
M.Title = Rs["Title"].ToString();
M.UpdateTime = Rs["UpdateTime"].ToDateTime();
M.Enable = Rs["Enable"].ToBoolean();
M.HttpUrl = Rs["HttpUrl"].ToString();
M.MagUrl = Rs["MagUrl"].ToString();
M.KuaibUrl = Rs["KuaibUrl"].ToString();
M.BaiduUrl = Rs["BaiduUrl"].ToString();
}
Rs.Close();
Rs = null;
return(M);
}
public override string ToString()
{
string flashvars = string.Empty;
foreach (string key in Keys)
{
flashvars += $"{key}={this[key]}&";
}
return(string.Format(_clientLoaderFormat,
BaseUrl, MovieUrl.Replace("http:", string.Empty), flashvars));
}
/// <summary>
/// 将修改过的实体修改到数据库
/// </summary>
/// <param name="M">赋值后的实体</param>
/// <returns></returns>
public static int Update(MovieUrl M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("update [MovieUrl] set ");
sb.Append("[MoviewID]=" + M.MoviewID.ToS());
sb.Append(",");
sb.Append("[MoviewTitle]=N'" + M.MoviewTitle + "'");
sb.Append(",");
sb.Append("[Title]=N'" + M.Title + "'");
sb.Append(",");
sb.Append("[UpdateTime]=N'" + M.UpdateTime + "'");
sb.Append(",");
sb.Append("[Enable]=" + M.Enable.ToS());
sb.Append(",");
sb.Append("[HttpUrl]=N'" + M.HttpUrl + "'");
sb.Append(",");
sb.Append("[MagUrl]=N'" + M.MagUrl + "'");
sb.Append(",");
sb.Append("[KuaibUrl]=N'" + M.KuaibUrl + "'");
sb.Append(",");
sb.Append("[BaiduUrl]=N'" + M.BaiduUrl + "'");
sb.Append(" where Id='" + M.Id + "'");
sb.Append("");
if (DataBase.CmsDbType == DataBase.DbType.SqlServer)
{
sb.Append(";select @@ROWCOUNT");
}
if (DataBase.CmsDbType == DataBase.DbType.SQLite)
{
sb.Append(";select 0");
}
if (DataBase.CmsDbType == DataBase.DbType.MySql)
{
sb.Append(";SELECT ROW_COUNT()");
}
if (DataBase.CmsDbType == DataBase.DbType.Access)
{
sb.Append(";select 0");
}
if (DataBase.CmsDbType == DataBase.DbType.Oracle)
{
sb.Append(";select SQL%ROWCOUNT");
}
return(Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32());
}
/// <summary>
/// 将数据插入表
/// </summary>
/// <param name="M">赋值后的实体</param>
/// <returns></returns>
public static void Insert(MovieUrl M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("insert into [MovieUrl]([id],[MoviewID],[MoviewTitle],[Title],[UpdateTime],[Enable],[HttpUrl],[MagUrl],[KuaibUrl],[BaiduUrl]) values(");
sb.Append(M.MoviewID.ToS());
sb.Append(",");
sb.Append("N'" + M.MoviewTitle + "'");
sb.Append(",");
sb.Append("N'" + M.Title + "'");
sb.Append(",");
sb.Append("N'" + M.UpdateTime + "'");
sb.Append(",");
sb.Append(M.Enable.ToS());
sb.Append(",");
sb.Append("N'" + M.HttpUrl + "'");
sb.Append(",");
sb.Append("N'" + M.MagUrl + "'");
sb.Append(",");
sb.Append("N'" + M.KuaibUrl + "'");
sb.Append(",");
sb.Append("N'" + M.BaiduUrl + "'");
sb.Append(")");
if (DataBase.CmsDbType == DataBase.DbType.SqlServer)
{
sb.Append(";select @@Identity");
}
if (DataBase.CmsDbType == DataBase.DbType.SQLite)
{
sb.Append(";select last_insert_rowid()");
}
if (DataBase.CmsDbType == DataBase.DbType.MySql)
{
sb.Append(";select LAST_INSERT_ID()");
}
if (DataBase.CmsDbType == DataBase.DbType.Access)
{
sb.Append(";select max(id) from MovieUrl");
}
if (DataBase.CmsDbType == DataBase.DbType.Oracle)
{
sb.Append(";select LAST_INSERT_ID()");
}
M.Id = Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32();
}
protected virtual void MediaCommandExecute()
{
if (IsMovie)
{
// Per Youtube's policies, all videos must be presenting on their site
if (MovieUrl.Contains("youtube"))
{
_browserService.OpenUrl(MovieUrl);
}
else if (RequestMovieViewer != null)
{
RequestMovieViewer(this);
}
}
else
{
if (RequestPhotoViewer != null)
{
RequestPhotoViewer(this);
}
}
}
/// <summary>
/// DataTable转换为list
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
protected static List <MovieUrl> DataTableToList(DataTable dt)
{
List <MovieUrl> Ms = new List <MovieUrl>();
for (int i = 0; i < dt.Rows.Count; i++)
{
MovieUrl M = new MovieUrl();
M.Id = dt.Rows[i]["id"].ToInt64();
M.MoviewID = dt.Rows[i]["MoviewID"].ToInt32();
M.MoviewTitle = dt.Rows[i]["MoviewTitle"].ToString();
M.Title = dt.Rows[i]["Title"].ToString();
M.UpdateTime = dt.Rows[i]["UpdateTime"].ToDateTime();
M.Enable = dt.Rows[i]["Enable"].ToBoolean();
M.HttpUrl = dt.Rows[i]["HttpUrl"].ToString();
M.MagUrl = dt.Rows[i]["MagUrl"].ToString();
M.KuaibUrl = dt.Rows[i]["KuaibUrl"].ToString();
M.BaiduUrl = dt.Rows[i]["BaiduUrl"].ToString();
Ms.Add(M);
}
return(Ms);
}
public HGameData(string source)
{
this["connection.info.host"] = string.Empty;
this["connection.info.port"] = string.Empty;
Match flashVarsMatch =
_flashVarsSingleLineMatcher.Match(source);
bool isSwfObject = false;
if (isSwfObject = !flashVarsMatch.Success)
{
flashVarsMatch =
GetVariable(source, "flashvars");
}
string variables =
flashVarsMatch.Groups["value"].Value + ";";
try
{
string movieUrl = string.Empty;
if (!isSwfObject)
{
string dataParam = "data=\"";
string movieParam = "<param name=\"movie\" value=\"";
movieUrl = (source.GetChild((source.Contains(
movieParam) ? movieParam : dataParam), '"'));
movieUrl = $"\"{movieUrl}\"";
}
else
{
movieUrl = source.GetChild(".embedSWF(", ',');
}
char charBegin = movieUrl[0];
bool isFieldName = (charBegin != '\"' && charBegin != '\'');
if (isSwfObject)
{
Match paramsMatch = GetVariable(source, "params");
if (paramsMatch.Success)
{
string flashParams = paramsMatch.Groups["value"].Value
.GetChild("{", '}').Replace(" :", ":").Replace(": ", ":").Trim();
BaseUrl = FixUrlString(flashParams.GetChild("\"base\":\"", '"'));
}
if (isFieldName)
{
movieUrl = GetVariable(source, movieUrl).Groups["value"].Value;
charBegin = movieUrl[0];
}
}
if (!string.IsNullOrWhiteSpace(movieUrl))
{
movieUrl = movieUrl.GetChild(charBegin.ToString(), charBegin);
MovieUrl = FixUrlString(movieUrl);
string[] segments = MovieUrl.GetChild("//")
.GetChild("/").Split('/');
int buildSegmentIndex = segments.Length > 1 ?
segments.Length - 2 : 0;
MovieName = segments[buildSegmentIndex];
if (buildSegmentIndex == 0)
{
MovieName = MovieName.GetParent(".swf");
}
}
}
catch { }
if (isSwfObject)
{
variables = variables.GetChild("{").GetParent("};")
.Replace(" :", ":").Replace(": ", ":").Trim();
int previousLength = 0;
string parsedVariables = string.Empty;
while (variables.Contains("\""))
{
string name = variables.GetChild("\"", '"');
string child = variables.GetChild($"\"{name}\":").Trim();
string value = string.Empty;
string fieldName = string.Empty;
bool isField = (child[0] != '"' && child[0] != '\'');
bool isEmpty = (child.Length > 1 && (child[1] == '"' || child[1] == '\''));
if (isField)
{
fieldName = child.GetParent(",");
Match variableMatch =
GetVariable(source, fieldName);
string fieldValue = variableMatch.Groups["value"].Value;
isEmpty = string.IsNullOrWhiteSpace(fieldValue);
if (!isEmpty)
{
child = child.Replace(fieldName,
variableMatch.Groups["value"].Value);
}
}
if (!isEmpty)
{
value = child.GetChild("\"", '"');
}
string toRemove = string.Format("\"{0}\":{1}{2}{1}",
name, (isField ? string.Empty : "\""), (isField ? fieldName : value));
variables = variables.Replace(toRemove, string.Empty);
parsedVariables += $"{name}={value}&";
previousLength = variables.Length;
}
variables = parsedVariables;
}
if (!variables.Contains("&"))
{
variables = variables.Replace("&", "&");
}
string[] valuePairs = variables
.Split(_flashValuesSeparator, StringSplitOptions.RemoveEmptyEntries);
foreach (string pair in valuePairs)
{
int separatorIndex = pair.IndexOf('=');
string name = pair.Substring(0, separatorIndex);
string value = pair.Substring(separatorIndex + 1);
value = FixUrlString(value);
this[name] = value;
}
}
public void AddToMovieUrl(MovieUrl movieUrl)
{
base.AddObject("MovieUrl", movieUrl);
}
public static MovieUrl CreateMovieUrl(long id)
{
MovieUrl movieUrl = new MovieUrl();
movieUrl.id = id;
return movieUrl;
}
