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));
}
