public JsonResult SubmitModify(int id, int flag = 1, string Name = "")
{
int t = 0;
Cl_VideoManage video = _videoManageBL.GetCl_VideoManageList(out t, "Id=" + id, 0, 1, "ORDER BY Cl_VideoManage.Id,Cl_VideoManage.LastUpdateTime ASC").FirstOrDefault();
if (flag == 1)
{
video.IsDelete = 1;
}
else
{
video.Name = Name;
}
if (_videoManageBL.Modify(video))
{
return(Json(new
{
result = 1,
content = flag == 0 ? "操作成功！" : "删除成功！"
}, JsonRequestBehavior.AllowGet));
}
return(Json(new
{
result = 1,
content = "操作失败！"
}, JsonRequestBehavior.AllowGet));
}
public int Add(Cl_VideoManage model)
{
using (IDbConnection connection = OpenConnection())
{
const string strSql =
@"insert into Cl_VideoManage(Name,Path,LastUpdateTime,Size,IsDelete,TopContent,LeftContent,RightContent,BottomContent) values(@Name,@Path,@LastUpdateTime,@Size,@IsDelete,@TopContent,@LeftContent,@RightContent,@BottomContent)
SELECT @@Identity AS ID
";
var param = new
{
model.Name,
model.Path,
model.LastUpdateTime,
model.Size,
model.IsDelete,
model.TopContent,
model.LeftContent,
model.RightContent,
model.BottomContent
};
decimal id =
connection.Query <decimal>(strSql, param)
.FirstOrDefault();
model.Id = decimal.ToInt32(id);
return(model.Id);
}
}
public ActionResult EditVideo(int?Id)
{
ViewBag.Id = 0;
if (Id.HasValue)
{
int t = 0;
Cl_VideoManage video = _videoManageBL.GetCl_VideoManageList(out t, "Id=" + Id.Value, 0, 1, "ORDER BY Cl_VideoManage.Id,Cl_VideoManage.LastUpdateTime DESC").FirstOrDefault();
ViewBag.Id = Id.Value;
ViewBag.Name = video.Name;
}
return(View());
}
public bool Modify(Cl_VideoManage model)
{
using (IDbConnection connection = OpenConnection())
{
const string strSql =
@"Update Cl_VideoManage set Name=@Name,Path=@Path,LastUpdateTime=@LastUpdateTime,Size=@Size,IsDelete=@IsDelete where Id=@Id
SELECT @@Identity AS ID
";
var param = new
{
model.Name,
model.Path,
model.LastUpdateTime,
model.Size,
model.IsDelete,
model.Id
};
return(connection.Execute(strSql, param) > 0);
}
}
public bool Modify(Cl_VideoManage model)
{
return(_videoManageDAL.Modify(model));
}
public int Add(Cl_VideoManage model)
{
return(_videoManageDAL.Add(model));
}
public ContentResult SubmitVideo(HttpPostedFileBase FileData, string folder, string videoName)
{
string filename = "";
string resultName = "";
if (null != FileData)
{
try
{
filename = Path.GetFileName(FileData.FileName); //获得文件名
string fullPathname = Path.Combine(folder, filename);
//文件后缀名
string suffix = FileData.FileName.Substring(FileData.FileName.LastIndexOf(".") + 1).ToLower();
resultName = Guid.NewGuid() + "." + suffix;
if (saveFile(FileData, folder, resultName))
{
//解压操作 然后获得解压后的文件名 保存在数据库中
int i = resultName.LastIndexOf(".");
GzipHelper.UnZip(UFCOVideoADDR, UFCOVideoZIP,
UFCOVideoUSR, UFCOVideoPwd,
HttpContext.Server.MapPath(folder + resultName),
UFCOVideoZIP + @"\" + resultName.Substring(0, i), "", true);
Cl_VideoManage model = new Cl_VideoManage()
{
LastUpdateTime = DateTime.Now,
Name = videoName.Replace("%2B", "+"), //.Replace("%3C","<").Replace("%3E",">").Replace("%2F","/"),
Path =
resultName.Substring(0, i) +
@"/Untitled/Untitled_media/Untitled.wmv",
Size = FileData.ContentLength / 1024,
IsDelete = 0
};
int status = NetworkConnection.Connect(UFCOVideoADDR, UFCOVideoZIP,
string.Format(@"{0}", UFCOVideoUSR), UFCOVideoPwd);
if (status == (int)ERROR_ID.ERROR_SUCCESS || status == 1202)
{
string aa =
ProcessRequest(UFCOVideoZIP + resultName.Substring(0, i) + @"/Untitled/Untitled.html");
var lefttop = getmodelList(aa, "<div id=\"indexlinks\" (.+?)></div>", 1);
var leftbot = getmodelList(aa,
"<table width=\"202\" height=\"200\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-bottom:1px solid #669966\">(.+?)</table>",
1);
model.BottomContent = "";
model.TopContent = "";
if (lefttop.Count != 0)
{
model.LeftContent = lefttop[0].ToString();
}
else
{
model.LeftContent = "";
}
if (leftbot.Count != 0)
{
model.RightContent = leftbot[0].ToString();
}
else
{
model.RightContent = "";
}
_videoManageBL.Add(model);
}
NetworkConnection.Disconnect(UFCOVideoZIP);
return(Content(model.Id.ToString() + status.ToString()));
}
else
{
return(Content("-1"));
}
}
catch (Exception ex)
{
return(Content(ex.Message + "--------" + ex.Source + "-----------" + ex.StackTrace));
}
}
return(Content("-1"));
}
public ContentResult SubmitVideo(HttpPostedFileBase FileData, string videoName, string folder = "~/UploadFiles/UFCOVideoZip/")
{
if (null != FileData)
{
try
{
//文件后缀名
var suffix = FileData.FileName.Substring(FileData.FileName.LastIndexOf(".") + 1).ToLower();
var resultName = Guid.NewGuid() + "." + suffix;
saveFile(FileData, resultName, folder);
//解压操作 然后获得解压后的文件名 保存在数据库中
var i = resultName.LastIndexOf(".");
UnZip(HttpContext.Server.MapPath(folder + resultName), HttpContext.Server.MapPath(@"~/UploadFiles/UFCOVideo/") + resultName.Substring(0, i) + "/", true);
var count = 0;
//获取子文件夹
var dirname = "/Untitled";
var di = new DirectoryInfo(HttpContext.Server.MapPath(@"~/UploadFiles/UFCOVideo/") + resultName.Substring(0, i));
var dirarr = di.GetDirectories();//获取子文件夹列表
if (dirarr.Length > 0)
{
dirname = "/" + dirarr[0].Name;
count++;
}
//获取html页面
var wenjianname = "Untitled.html";
var di1 = new DirectoryInfo(HttpContext.Server.MapPath(@"~/UploadFiles/UFCOVideo/") + resultName.Substring(0, i) + dirname);
var wenjlist = di1.GetFiles();
foreach (var obj in wenjlist.Where(obj => obj.FullName.IndexOf(".html") >= 0))
{
wenjianname = obj.Name;
count++;
break;
}
//获取第二层文件夹名称
var di2 = new DirectoryInfo(HttpContext.Server.MapPath(@"~/UploadFiles/UFCOVideo/") + resultName.Substring(0, i) + "/" + dirname);
var dirname1 = "/Untitled_media";
var dirarr1 = di2.GetDirectories();//获取子文件夹列表
if (dirarr1.Length > 0)
{
dirname1 = "/" + dirarr1[0].Name;
count++;
}
//获取视频名字
var ship = "Untitled.wmv";
var di3 = new DirectoryInfo(HttpContext.Server.MapPath(@"~/UploadFiles/UFCOVideo/") + resultName.Substring(0, i) + dirname + dirname1);
var shiplist = di3.GetFiles();
foreach (var obj in shiplist.Where(obj => obj.FullName.IndexOf(".wmv") >= 0))
{
ship = obj.Name;
count++;
break;
}
if (count == 4)
{
var model = new Cl_VideoManage()
{
LastUpdateTime = DateTime.Now,
Name = videoName.Replace("%3C", "<").Replace("%3E", ">"),
Path = resultName.Substring(0, i) + dirname + dirname1 + "/" + ship,
Size = FileData.ContentLength / 1024,
IsDelete = 0
};
var aa =
ProcessRequest(HttpContext.Server.MapPath(@"~/UploadFiles/UFCOVideo/") +
resultName.Substring(0, i) + dirname + @"/" + wenjianname);
var lefttop = getmodelList(aa, "<div class=\"contentWrapper_left\">(.+?)</div>", 1);
model.BottomContent = "";
model.TopContent = "";
model.LeftContent = lefttop.Count != 0 ? lefttop[0].ToString() : "";
model.RightContent = "../../UploadFiles/UFCOVideo/" + resultName.Substring(0, i) + dirname +
dirname1 + "/images/photo.gif";
_videoManageBL.Add(model);
return(Content(model.Id.ToString()));
}
return(Content("-1"));
}
catch (Exception ex)
{
return(Content(ex.Message));
}
}
return(Content("-1"));
}
