protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
userId = (int)base.NowUserInfo.UserId;
IsFristUser = new T_UserBLL().CheckUser(userId);
if (IsFristUser == false)
{
new T_UserBLL().Add(new T_UserModel()
{
UserId = userId, UserName = base.NowUserInfo.UserName
});
}
if (Request.QueryString["roomId"] != "")
{
roomId = int.Parse(Request.QueryString["roomId"]);
item = new T_RoomBLL().Get(roomId);
IsCollect = new T_UserCollectBLL().GetUserRoom(userId, roomId);
}
else
{
item = new T_RoomModel();
}
if (Request.QueryString["pageType"] != "")
{
pageType = Request.QueryString["pageType"];
}
}
}
public List <T_RoomModel> GetWebData()
{
string YouKuUrl_Fan = DataURL.YouKuUrl_Fan;
string webResult = HttpFunction.Get(YouKuUrl_Fan, Encoding.UTF8, 25600000);
Regex webRegex = new Regex(@"<a.*target=""video"".*?title=.*>(.*?)</a>", RegexOptions.IgnoreCase);
MatchCollection douyumc = webRegex.Matches(webResult);
List <T_RoomModel> modelList = new List <T_RoomModel>();
foreach (Match m in douyumc)
{
Regex regex = new Regex("<a\\s*?href=\"(?<href>.*)\"\\s*?target=\"(?<target>.*?)\\s*?title=\"(?<title>.*?)\">.*</a>",
RegexOptions.Singleline);
string href = regex.Match(m.Value).Groups["href"].Value;
href = href.Substring(0, href.IndexOf(".html")).Replace("http://v.youku.com/v_show/", "http://player.youku.com/embed/").Replace("id_", "");
string title = regex.Match(m.Value).Groups["title"].Value;
T_RoomModel t_RoomModel = new T_RoomModel();
t_RoomModel.PlatType = (int)PlatTypeEmun.youku;
t_RoomModel.RoomName = title;
t_RoomModel.PlayUrl = href;
t_RoomModel.RoomBG = GetImgUrl(webResult, title);
t_RoomModel.RoomType = (int)RoomTypeEmun.fan;
t_RoomModel.CreateTime = DateTime.Now;
t_RoomModel.UpateTime = DateTime.Now;
t_RoomModel.Status = 1;
t_RoomModel.OwnerName = "优酷";
t_RoomModel.PlayTime = "";
modelList.Add(t_RoomModel);
}
return(modelList);
}
public int Add(T_RoomModel t_RoomModel)
{
var sqlparams = new SqlParameter[] {
new SqlParameter("@RoomName", t_RoomModel.RoomName),
new SqlParameter("@OwnerName", t_RoomModel.OwnerName),
new SqlParameter("@OwnerInfo", t_RoomModel.OwnerInfo),
new SqlParameter("@PlatType", t_RoomModel.PlatType),
new SqlParameter("@PlayTime", t_RoomModel.PlayTime),
new SqlParameter("@PlayUrl", t_RoomModel.PlayUrl),
new SqlParameter("@ActiveUrl", t_RoomModel.ActiveUrl),
new SqlParameter("@CollectNum", t_RoomModel.CollectNum),
new SqlParameter("@RoomType", t_RoomModel.RoomType),
new SqlParameter("@IsHot", t_RoomModel.IsHot),
new SqlParameter("@RoomBG", t_RoomModel.RoomBG),
new SqlParameter("@OrderNum", t_RoomModel.OrderNum),
new SqlParameter("@Status", t_RoomModel.Status),
new SqlParameter("@CreateTime", DateTime.Now),
new SqlParameter("@UpateTime", DateTime.Now),
};
string sql = @" INSERT INTO [T_Room]
([RoomName]
,[OwnerName]
,[OwnerInfo]
,[PlatType]
,[PlayTime]
,[PlayUrl]
,[ActiveUrl]
,[CollectNum]
,[RoomType]
,[IsHot]
,[RoomBG]
,[OrderNum]
,[Status]
,[CreateTime]
,[UpateTime])
VALUES
(@RoomName
,@OwnerName
,@OwnerInfo
,@PlatType
,@PlayTime
,@PlayUrl
,@ActiveUrl
,@CollectNum
,@RoomType
,@IsHot
,@RoomBG
,@OrderNum
,@Status
,@CreateTime
,@UpateTime
) ";
return(SqlHelper.ExecuteNonQuery(ConnectionString.WTVDns, CommandType.Text, sql, sqlparams));
}
protected void Savebtn_ServerClick(object sender, EventArgs e)
{
try
{
T_RoomModel model = new T_RoomModel();
model.ActiveUrl = ActiveUrlTxt.Value;
model.IsHot = cbxIsHot.Checked == true ? 1 : 0;
if (OrderNumTxt.Value != "")
{
model.OrderNum = int.Parse(OrderNumTxt.Value);
}
else
{
model.OrderNum = 0;
}
model.OwnerInfo = OwnerInfoTxt.Value;
model.OwnerName = OwnerNameTxt.Value;
model.PlatType = int.Parse(PlatTypeSelet.Value);
model.PlayTime = PlayTimeTxt.Value;
model.PlayUrl = PlayUrlTxt.Value;
model.RoomName = RoomNameTxt.Value;
model.RoomType = int.Parse(RoomTypeSelect.Value);
if (HiddenFieldRoomBG.Value != "")
{
model.RoomBG = HiddenFieldRoomBG.Value;
}
else
{
model.RoomBG = "";
}
model.Status = int.Parse(StatusSelet.Value);
int roomId = 0;
if (Request.QueryString["roomId"] != null)
{
int.TryParse(Request.QueryString["roomId"], out roomId);
}
if (roomId == 0)
{
new T_RoomBLL().Add(model);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('提交成功'); var index = parent.layer.getFrameIndex(window.name); parent.layer.close(index);", true);
}
else
{
new T_RoomBLL().Update(model, roomId);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('提交成功'); var index = parent.layer.getFrameIndex(window.name); parent.layer.close(index);", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('错误');", true);
}
}
public T_RoomModel getRoomLive(T_RoomModel baseT_RoomModel)
{
if (baseT_RoomModel != null)
{
baseT_RoomModel.isLive = GetIsLive(baseT_RoomModel);
return(baseT_RoomModel);
}
else
{
return(null);
}
}
public bool GetUserRoom(int userId, int roomId)
{
List <T_RoomModel> list = new T_UserCollectDAL().GetUserRoom(userId);
T_RoomModel model = list.Find(e => e.RoomId == roomId);
if (model == null || model.RoomId == 0)
{
return(false);
}
else
{
return(true);
}
}
public int Update(T_RoomModel t_RoomModel, int roomId)
{
var sqlparams = new SqlParameter[] {
new SqlParameter("@RoomId", roomId),
new SqlParameter("@RoomName", t_RoomModel.RoomName),
new SqlParameter("@OwnerName", t_RoomModel.OwnerName),
new SqlParameter("@OwnerInfo", t_RoomModel.OwnerInfo),
new SqlParameter("@PlatType", t_RoomModel.PlatType),
new SqlParameter("@PlayTime", t_RoomModel.PlayTime),
new SqlParameter("@PlayUrl", t_RoomModel.PlayUrl),
new SqlParameter("@ActiveUrl", t_RoomModel.ActiveUrl),
new SqlParameter("@CollectNum", t_RoomModel.CollectNum),
new SqlParameter("@RoomType", t_RoomModel.RoomType),
new SqlParameter("@IsHot", t_RoomModel.IsHot),
new SqlParameter("@RoomBG", t_RoomModel.RoomBG),
new SqlParameter("@OrderNum", t_RoomModel.OrderNum),
new SqlParameter("@Status", t_RoomModel.Status),
new SqlParameter("@UpateTime", DateTime.Now),
};
string sql = @"UPDATE [T_Room]
SET [RoomName] = @RoomName
,[OwnerName] = @OwnerName
,[OwnerInfo] = @OwnerInfo
,[PlatType] = @PlatType
,[PlayTime] = @PlayTime
,[PlayUrl] = @PlayUrl
,[ActiveUrl] = @ActiveUrl
,[CollectNum] = @CollectNum
,[RoomType] = @RoomType
,[IsHot] = @IsHot
,[RoomBG] = @RoomBG
,[OrderNum] = @OrderNum
,[Status] = @Status
,[UpateTime] = @UpateTime
WHERE RoomId=@RoomId";
return(SqlHelper.ExecuteNonQuery(ConnectionString.WTVDns, CommandType.Text, sql, sqlparams));
}
public int Update(T_RoomModel t_RoomModel, int roomId)
{
return(new T_RoomDAL().Update(t_RoomModel, roomId));
}
public int Add(T_RoomModel t_RoomModel)
{
return(new T_RoomDAL().Add(t_RoomModel));
}
public int GetIsLive(T_RoomModel baseT_RoomModel)
{
return(GetCacheLiveStatus(baseT_RoomModel.OwnerName));
}
