public DataSet selNewVideo() { tb_Video video = new tb_Video(); string sel = "select top 10 VideoID,VideoName,TypeName,FBDate from tb_Video,tb_Type where VideoType=TypeID order by FBDate desc"; return(sqlDal.sqlDs(sel, null, null)); }
private void dataSouceBind() { if (Request.Params["TutorialType"] == "Sound") { tb_Sound sound = new tb_Sound(); int SoundID = Convert.ToInt32(Request.Params["TutorialID"]); soundb.AddClickNum(SoundID); sound = soundb.selOneSound(SoundID); Url = sound.SoundUrl; lblClickSum.Text = sound.ClickSum.ToString(); lblFBDate.Text = sound.FBDate.ToString(); lblName.Text = sound.Name; lblTutorialName.Text = sound.SoundName; txtContainer.Text = sound.SoundContent; } else { tb_Video video = new tb_Video(); int VideoID = Convert.ToInt32(Request.Params["TutorialID"]); videob.AddClickNum(VideoID); video = videob.selOneVideo(VideoID); Url = video.VideoUrl; lblClickSum.Text = video.ClickSum.ToString(); lblFBDate.Text = video.FBDate.ToString(); lblName.Text = video.Name; lblTutorialName.Text = video.VideoName; txtContainer.Text = video.VideoContent; } }
public DataSet selTopVideo() { tb_Video video = new tb_Video(); string sel = "select top 5 VideoID,VideoName,TypeName,ClickSum from tb_Video,tb_Type where VideoType=TypeID order by ClickSum desc"; return(sqlDal.sqlDs(sel, null, null)); }
public ActionResult DeleteConfirmed(int id) { tb_Video tb_Video = db.tb_Video.Find(id); db.tb_Video.Remove(tb_Video); db.SaveChanges(); return(RedirectToAction("Index")); }
private void dataSouceBind() { tb_Video video = new tb_Video(); video = vb.selOneVideo(Convert.ToInt32(Request.Params["VideoID"])); VUrl = video.VideoUrl; lblClickSum.Text = video.ClickSum.ToString(); lblFBDate.Text = video.FBDate.ToString(); lblName.Text = video.Name; lblVideoName.Text = video.VideoName; txtContent.Text = video.VideoContent; }
public ActionResult Edit([Bind(Include = "VID,UID,VName,VAddress,CreateTime,Remake,Vimage")] tb_Video tb_Video) { tb_Video.UID = Convert.ToInt32(Request.Cookies["UID"].Value); tb_Video.State = 0; if (ModelState.IsValid) { db.Entry(tb_Video).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UID = new SelectList(db.tb_User, "UID", "User_Name", tb_Video.UID); return(View(tb_Video)); }
// GET: Video/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tb_Video tb_Video = db.tb_Video.Find(id); if (tb_Video == null) { return(HttpNotFound()); } return(View(tb_Video)); }
// GET: Video/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tb_Video tb_Video = db.tb_Video.Find(id); if (tb_Video == null) { return(HttpNotFound()); } ViewBag.UID = new SelectList(db.tb_User, "UID", "User_Name", tb_Video.UID); return(View(tb_Video)); }
public ActionResult AddClassCareData() { var OrderID = Request["OrderID"]; var Title = Request["Title"]; var Memo = Request["Memo"]; var VideoUrl = Request["VideoUrl"]; var ImgUrl = Request["ImgUrl"]; //var OrderClassify = Request["OrderClassify"]; //var OrderType = Request["OrderType"]; //var OrderIntro = Request["OrderIntro"]; //var OrderID = Utility.GetNewGUID(); int picCnt = 0; //图片 int videoCnt = 0; //视频 //图片 if (!string.IsNullOrEmpty(ImgUrl)) { tb_Pictuer pic = new tb_Pictuer(); pic.PicTitle = Title; pic.OrderID = OrderID; pic.PicUrl = ImgUrl; pic.Memo = Memo; picCnt = DemandBLL.PictureIns(pic); } //视频 if (!string.IsNullOrEmpty(VideoUrl)) { tb_Video video = new tb_Video(); video.VideoTitle = Title; video.OrderID = OrderID; video.VideoUrl = VideoUrl; video.Memo = Memo; videoCnt = DemandBLL.VideoIns(video); } if (!string.IsNullOrEmpty(ImgUrl) && picCnt <= 0) { return(OperContext.PackagingAjaxMsg(AjaxStatu.err, "图片提交失败,请联系管理员!")); } if (!string.IsNullOrEmpty(VideoUrl) && videoCnt <= 0) { return(OperContext.PackagingAjaxMsg(AjaxStatu.err, "视频提交失败,请联系管理员!")); } return(OperContext.PackagingAjaxMsg(AjaxStatu.ok, "信息提交成功请查看详情!", null, "/MemberM/AdminClassCare/")); }
public tb_Video selOneVideo(int VideoID) { tb_Video video = new tb_Video(); string sel = "select VideoID,VideoName,FBDate,ClickSum,Name,VideoUrl,VideoContent from tb_Video where VideoID=@VideoID"; ArrayList list = sqlDal.sqlOnesDr(sel, new string[] { "@VideoID" }, new string[] { VideoID.ToString() }); video.VideoID = (int)list[0]; video.VideoName = list[1].ToString(); video.FBDate = (DateTime)list[2]; video.ClickSum = (int)list[3]; video.Name = list[4].ToString(); video.VideoUrl = list[5].ToString(); video.VideoContent = list[6].ToString(); return(video); }
public List <tb_Video> selVideo() { tb_Video video = null; string sel = "select VideoID,VideoName,FBDate from tb_Video"; List <ArrayList> list = sqlDal.sqlDr(sel, null, null); List <tb_Video> videoList = new List <tb_Video>(); foreach (ArrayList obj in list) { video = new tb_Video(); video.VideoID = (int)obj[0]; video.VideoName = obj[1].ToString(); video.FBDate = (DateTime)obj[2]; videoList.Add(video); } return(videoList); }
protected void btnIssuanced_Click(object sender, EventArgs e) { try { if (ddlType.SelectedIndex == 0) { Response.Write("<script>alert('请选择课程类型')</script>"); } else { string fileName = FileUpload1.FileName; string newFileName = Guid.NewGuid().ToString() + fileName.Substring(fileName.LastIndexOf(".")); if (rdoVideo.Checked == true) { string filePath = Server.MapPath("./video/"); FileUpload1.SaveAs(filePath + newFileName); tb_Video video = new tb_Video(); video.VideoContent = txtContainer.Text; video.VideoName = txtTitle.Text; video.VideoUrl = filePath + newFileName; video.Name = Session["UserName"].ToString(); video.VideoType = Convert.ToInt32(ddlType.SelectedIndex); vb.addVideo(video); } else { string filePath = Server.MapPath("./sound/"); FileUpload1.SaveAs(filePath + newFileName); tb_Sound sound = new tb_Sound(); sound.SoundContent = txtContainer.Text; sound.SoundName = txtTitle.Text; sound.SoundUrl = filePath + newFileName; sound.Name = Session["UserName"].ToString(); sound.SoundType = Convert.ToInt32(ddlType.SelectedIndex); sb.addSound(sound); } Response.Write("<script>alert('上传成功')</script>"); Response.AddHeader("Refresh", "0"); } } catch (Exception ee) { Response.Write(ee.Message); throw; } }
public List <tb_Video> selSearchVideo(string VideoType, string SearchKey, string pageIndex, string pageSize) { tb_Video video = null; List <ArrayList> list = sqlDal.sqlProcDr("GETTUTORIALTABLEPAGE", new string[] { "@TABLENAME", "@TutorialID", "@SearchKey", "@pageIndex", "@pageSize" }, new string[] { "Video", VideoType, SearchKey, pageIndex, pageSize }); List <tb_Video> videoList = new List <tb_Video>(); foreach (ArrayList obj in list) { video = new tb_Video(); video.VideoID = (int)obj[0]; video.VideoName = obj[1].ToString(); video.FBDate = (DateTime)obj[2]; video.Name = obj[3].ToString(); videoList.Add(video); } return(videoList); }
// GET: Video/Details/5 public ActionResult Details(int?id) { int uid = Convert.ToInt32(Request.Cookies["UID"].Value); var user = db.tb_User.Where(x => x.UID == uid).FirstOrDefault(); if (user.PState == null) { return(RedirectToAction("About", "Home")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tb_Video tb_Video = db.tb_Video.Find(id); if (tb_Video == null) { return(HttpNotFound()); } return(View(tb_Video)); }
/// <summary> /// 新增视频 /// </summary> /// <param name="video"></param> /// <returns></returns> public static int VideoIns(tb_Video video) { using (CareCenterEntities entity = new CareCenterEntities()) { try { int count = 0; video.VideoID = Utility.GetNewGUID(); video.Status = 1; video.CreateDate = Utility.GetSysDateTime(); entity.Entry(video).State = System.Data.Entity.EntityState.Added; entity.SaveChanges(); count = 1; return(count); } catch (Exception ex) { throw ex; } } }
public ActionResult SetOwnNeedData() { var Title = Request["Title"]; var Memo = Request["Memo"]; var VideoUrl = Request["VideoUrl"]; var ImgUrl = Request["ImgUrl"]; var OrderClassify = Request["OrderClassify"]; var OrderType = Request["OrderType"]; var OrderIntro = Request["OrderIntro"]; var OrderID = Utility.GetNewGUID(); var PersonInro = Request["PersonInro"];//被照护人情况 var Address = Request["Address"]; var CeraRange = Request["CeraRange"]; var DateType = Request["DateType"];// 照护方式 如:4H(半天)、10h(白天)、24h(全天) var CarePerson = Request["CarePerson"]; var CareAddress = Request["CareAddress"]; int picCnt = 0; //图片 int videoCnt = 0; //视频 var userphone = User.Identity.Name; var userInfo = HomeBLL.GetUserInfoByPhone(userphone);; //获取用户信息 //需求数据 tb_Order order = new tb_Order(); order.UserID = userInfo.ID; order.OrderID = OrderID; order.OrderTitle = Title; order.OrderType = OrderType; order.OrderClassify = Convert.ToInt32(OrderClassify); order.Memo = Memo; order.OrderIntor = OrderIntro; order.PersonInro = PersonInro; order.Address = Address; order.CeraRange = CeraRange; order.DateType = DateType; order.CarePerson = CarePerson; order.CareAddress = CareAddress; int count = DemandBLL.OwnNeedDataIns(order); var ordertemp = UserBLL.GetOrderDataBYOrderID(OrderID); if (count > 0 && ordertemp != null) { //图片 if (!string.IsNullOrEmpty(ImgUrl)) { tb_Pictuer pic = new tb_Pictuer(); pic.OrderID = OrderID; pic.PicUrl = ImgUrl; picCnt = DemandBLL.PictureIns(pic); } //视频 if (!string.IsNullOrEmpty(VideoUrl)) { tb_Video video = new tb_Video(); video.OrderID = OrderID; video.VideoUrl = VideoUrl; videoCnt = DemandBLL.VideoIns(video); } if (!string.IsNullOrEmpty(ImgUrl) && picCnt <= 0) { return(OperContext.PackagingAjaxMsg(AjaxStatu.err, "图片提交失败,请联系管理员!")); } if (!string.IsNullOrEmpty(VideoUrl) && videoCnt <= 0) { return(OperContext.PackagingAjaxMsg(AjaxStatu.err, "视频提交失败,请联系管理员!")); } return(OperContext.PackagingAjaxMsg(AjaxStatu.ok, "需求提交成功请至个人中心查看!", null, "/User/OwnNeed/")); } else { return(OperContext.PackagingAjaxMsg(AjaxStatu.err, "需求提交失败,请联系管理员!")); } }
public int addVideo(tb_Video video) { return(sqlDal.sqlUpdate("insert into tb_Video(VideoType,VideoName,VideoUrl,Name,VideoContent) values(@VideoType,@VideoName,@VideoUrl,@Name,@VideoContent)", new string[] { "@VideoType", "@VideoName", "@VideoUrl", "@Name", "@VideoContent" }, new string[] { video.VideoType.ToString(), video.VideoName, video.VideoUrl, video.Name, video.VideoContent })); }
public int addVideo(tb_Video video) { return(vd.addVideo(video)); }