//添加电影信息
public static bool insertMovies(MovieModel.MovieModel aa)
{
string sql = string.Format("insert into MovieinfoTable(MovieNAME,MovieADDtime,MoviePrice,MovieStarring,MoviePath,MovieImg,MovieAreaID,MovieTypeID,MovieLength) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", aa.MovieNAME, aa.MovieADDtime, aa.MoviePrice, aa.MovieStarring, aa.MoviePath, aa.MovieImg, aa.MovieAreaID, aa.MovieTypeID, aa.MovieLength);
bool isucc = DBHelper.en(sql);
return(isucc);
}
//修改传入的电影信息
public static bool updatemovies(MovieModel.MovieModel aa)
{
string sql = string.Format("update MovieinfoTable set MovieNAME='{0}',MovieTypeID='{1}',MovieADDtime='{2}',MovieStarring='{3}',MovieLength='{4}',MovieAreaID='{5}',MoviePath='{6}',MoviePrice='{7}',MovieImg='{8}'where MovieID='{9}'", aa.MovieNAME, aa.MovieTypeID, aa.MovieADDtime, aa.MovieStarring, aa.MovieLength, aa.MovieAreaID, aa.MoviePath, aa.MoviePrice, aa.MovieImg, aa.MovieID);
bool isucc = DBHelper.en(sql);
return(isucc);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string MovieID = context.Request["MovieID"].ToString();
string MovieNAME = context.Request["MovieNAME"].ToString();
string MovieADDtime = context.Request["MovieADDtime"].ToString();
string MoviePrice = context.Request["MoviePrice"].ToString();
string MovieStarring = context.Request["MovieStarring"].ToString();
string MovieTypeID = context.Request["MovieTypeID"].ToString();
string MovieAreaID = context.Request["MovieAreaID"].ToString();
string MovieLength = context.Request["MovieLength"].ToString();
//string MovieImg = context.Request["MovieImg"].ToString();
//视频
HttpPostedFile file2 = context.Request.Files["MoviePath1"];
FileInfo fi2 = new FileInfo(file2.FileName);
//扩展名
string fil2 = fi2.Extension;
//时间名
string kz2 = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
string newpath2 = context.Server.MapPath(".") + "\\../MP4\\" + kz2 + fil2;
file2.SaveAs(newpath2);
string newpathmp4 = "\\../MP4\\" + kz2 + fil2;
//封面
HttpPostedFile file = context.Request.Files["MovieImg1"];
FileInfo fi = new FileInfo(file.FileName);
//扩展名
string fil = fi.Extension;
//时间名
string kz = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
string newpath = context.Server.MapPath(".") + "\\../static\\images\\" + kz + fil;
file.SaveAs(newpath);
string newimages = "..\\static\\images\\" + kz + fil;
MovieModel.MovieModel aa = new MovieModel.MovieModel();
aa.MovieID = int.Parse(MovieID);
aa.MoviePath = newpathmp4;
aa.MovieNAME = MovieNAME;
aa.MovieADDtime = int.Parse(MovieADDtime);
aa.MoviePrice = MoviePrice;
aa.MovieStarring = MovieStarring;
aa.MovieTypeID = int.Parse(MovieTypeID);
aa.MovieAreaID = int.Parse(MovieAreaID);
aa.MovieLength = MovieLength;
aa.MovieImg = newimages;
bool isucc = MovieBLL.BLL.updateMovies(aa);
context.Response.Write(isucc);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
DataTable dt = MovieBLL.BLL.select();
List <MovieModel.MovieModel> aa = new List <MovieModel.MovieModel>();
foreach (DataRow item in dt.Rows)
{
MovieModel.MovieModel a = new MovieModel.MovieModel();
a.MovieID = int.Parse(item["MovieID"].ToString());
a.MovieNAME = item["MovieNAME"].ToString();
a.MovieADDtime = int.Parse(item["MovieADDtime"].ToString());
a.MovieLength = item["MovieLength"].ToString();
a.MoviePath = item["MoviePath"].ToString();
a.MoviePrice = item["MoviePrice"].ToString();
a.MovieStarring = item["MovieStarring"].ToString();
a.MovieTypeID = int.Parse(item["MovieTypeID"].ToString());
a.MovieImg = item["MovieImg"].ToString();
aa.Add(a);
}
string json = JsonConvert.SerializeObject(aa);
context.Response.Write(json);
}
//注册
public static bool insertMovies(MovieModel.MovieModel aa)
{
return(MovieDAL.DAL.insertMovies(aa));
}
//通过传入值修改电影信息
public static bool updateMovies(MovieModel.MovieModel aa)
{
return(MovieDAL.DAL.updatemovies(aa));
}
