public AddEditMainVideoForm(LessonModel lessonModel, MainVideoModel CmainVideoModel)
{
InitializeComponent();
currentLessonModel = lessonModel;
mainVideoModel = CmainVideoModel;
initData();
initView();
}
protected void Button1_Click(object sender, EventArgs e)
{
var model = new MainVideoModel();
model.VideoLink = TextBox_VideoLink.Text;
model.VideoSub1 = TextBox_VideoSub1.Text;
model.VideoSub2 = TextBox_VideoSub2.Text;
model.MainVideoBackground_PicId = Convert.ToInt32(HiddenField_VideoBack.Value);
Logic.UpdateMainVideo(model);
}
public MainVideoModel GetMainVideo()
{
MainVideoModel model = new MainVideoModel();
base.Connect();
////////MainVideoLink
DataTable dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'MainVideoLink'");
if (dt.Rows.Count != 0)
{
model.VideoLink = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.VideoLink = "";
}
////////MainVideoSub1
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'MainVideoSub1'");
if (dt.Rows.Count != 0)
{
model.VideoSub1 = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.VideoSub1 = "";
}
/////////MainVideoSub2
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'MainVideoSub2'");
if (dt.Rows.Count != 0)
{
model.VideoSub2 = dt.Rows[0]["ItemValue"].ToString();
}
else
{
model.VideoSub2 = "";
}
/////////MainVideoBackground
dt = base.Select("SELECT A.[PicId] , B.[PicAddress] From [tbl_PicUse] AS A INNER JOIN [tbl_PicUploader]AS B ON A.PicId=B.PicId WHERE A.PicUseAs LIKE N'MainVideoBackground'");
if (dt.Rows.Count != 0)
{
model.MainVideoBackground_PicId = Convert.ToInt32(dt.Rows[0]["PicId"]);
model.MainVideoBackground_Pic = dt.Rows[0]["PicAddress"].ToString();
}
else
{
model.MainVideoBackground_PicId = 0;
model.MainVideoBackground_Pic = "";
}
/////////
base.DC();
return(model);
}
protected void Button1_Click(object sender, EventArgs e)
{
var model = new MainVideoModel();
model.VideoLink = TextBox_VideoLink.Text;
model.VideoSub1 = TextBox_VideoSub1.Text;
model.VideoSub2 = TextBox_VideoSub2.Text;
model.MainVideoBackground_PicId = Convert.ToInt32(JsonConvert.DeserializeObject <List <UploaderModel> >(HiddenField_VideoBack.Value)[0].idOfImg);
model.MainVideoBackground_Pic = JsonConvert.DeserializeObject <List <UploaderModel> >(HiddenField_VideoBack.Value)[0].imgsrc;
Logic.UpdateMainVideo(model);
Response.Redirect("/Admin_MainVideo.aspx");
}
private void refreshVideoDetail()
{
String filePath = currentLessonModel.videoMainJsonFilePath;
String jsonString = FileHandle.readJsonFile(filePath);
currentMainVideoModel = (MainVideoModel)JSONHandle.getObjFromJson <MainVideoModel>(jsonString);
if (currentMainVideoModel == null)
{
currentMainVideoModel = new MainVideoModel();
}
else
{
mainVideoTItletextBox1.Text = currentMainVideoModel.videoTitle;
lessonIntroTextBox.Text = currentMainVideoModel.videoLessonIntro;
videoDetialLabel.Text = "第" + (currentLessonModel.orderNum + 1) + "课";
}
String zqfilePath = currentLessonModel.videoZhengJueJsonFilePath;
String zqjsonString = FileHandle.readJsonFile(zqfilePath);
List <ItemVideoModel> zqList = (List <ItemVideoModel>)JSONHandle.getObjFromJson <List <ItemVideoModel> >(zqjsonString);
if (zqList == null)
{
return;
}
foreach (ItemVideoModel m in zqList)
{
zhengQueVideoList.Add(m);
}
refreshZhengQueVideoListView();
String cwfilePath = currentLessonModel.videoCuoWuJsonFilePath;
String cwjsonString = FileHandle.readJsonFile(cwfilePath);
List <ItemVideoModel> cwList = (List <ItemVideoModel>)JSONHandle.getObjFromJson <List <ItemVideoModel> >(cwjsonString);
if (cwList == null)
{
return;
}
foreach (ItemVideoModel m in cwList)
{
zhengQueVideoList.Add(m);
}
refreshCuoWuVideoListView();
}
protected void Page_Load(object sender, EventArgs e)
{
Logic = new MainVideo_Logic();
model = Logic.GetMainVideo();
if (!IsPostBack)
{
TextBox_VideoLink.Text = model.VideoLink;
TextBox_VideoSub1.Text = model.VideoSub1;
TextBox_VideoSub2.Text = model.VideoSub2;
HiddenField_VideoBack.Value = JsonConvert.SerializeObject(new List <UploaderModel>()
{
new UploaderModel()
{
idOfImg = model.MainVideoBackground_PicId.ToString()
}
});
}
else
{
}
}
public IndexModel GetData()
{
DataTable dt;
base.Connect();
////Sliders
List <PicModel> Sliders = new List <PicModel>();
dt = base.Select("SELECT A.[PicId],[PicAddress],[PicThumbnailAddress] FROM [tbl_PicUploader] as A inner join [tbl_PicUse] as B on A.PicId=B.PicId where B.PicUseAs LIKE N'Slider'");
for (int i = 0; i < dt.Rows.Count; i++)
{
var Slider = new PicModel()
{
PicId = Convert.ToInt32(dt.Rows[i]["PicId"]),
Path = dt.Rows[i]["PicAddress"].ToString(),
ThumpnailPic = dt.Rows[i]["PicThumbnailAddress"].ToString()
};
Sliders.Add(Slider);
}
////////Portfolios
List <PortfolioModel> Portfolios = new List <PortfolioModel>();
dt = base.Select("SELECT top 4 [P_Id],[Subject],[BackGroundPicId],(SELECT [PicThumbnailAddress] FROM [tbl_PicUploader] where PicId=[BackGroundPicId]) as BackGroundPic,[LogoPicId],(SELECT [PicThumbnailAddress] FROM [tbl_PicUploader] where PicId=[LogoPicId]) as LogoPic ,[Discription],[SEO_KeyWord],[SEO_Discription],[Show_MainPage] FROM [tbl_Portfolio] where [Show_MainPage]=1 AND [Deleted]=0");
for (int i = 0; i < dt.Rows.Count; i++)
{
var Portfolio = new PortfolioModel()
{
Background_Id = Convert.ToInt32(dt.Rows[i]["BackGroundPicId"]),
Background_Path = dt.Rows[i]["BackGroundPic"].ToString(),
Discription = dt.Rows[i]["Discription"].ToString(),
Logo_Path = dt.Rows[i]["LogoPic"].ToString(),
Log_Id = Convert.ToInt32(dt.Rows[i]["LogoPicId"]),
PortfolioId = Convert.ToInt32(dt.Rows[i]["P_Id"]),
SEO_discription = dt.Rows[i]["SEO_Discription"].ToString(),
SEO_Keyword = dt.Rows[i]["SEO_KeyWord"].ToString(),
Subject = dt.Rows[i]["Subject"].ToString(),
Show = Convert.ToInt32(dt.Rows[i]["Show_MainPage"])
};
Portfolios.Add(Portfolio);
}
////////Clients
List <PicModel> Clients = new List <PicModel>();
dt = base.Select("SELECT top 7 A.[PicId],[PicAddress],[PicThumbnailAddress] FROM [tbl_PicUploader] as A inner join [tbl_PicUse] as B on A.PicId=B.PicId where B.PicUseAs LIKE N'OurClients'");
for (int i = 0; i < dt.Rows.Count; i++)
{
var C = new PicModel()
{
PicId = Convert.ToInt32(dt.Rows[i]["PicId"]),
Path = dt.Rows[i]["PicAddress"].ToString(),
ThumpnailPic = dt.Rows[i]["PicThumbnailAddress"].ToString()
};
Clients.Add(C);
}
////////MainVideo
MainVideoModel mainVideo = new MainVideoModel();
////////MainVideoLink
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'MainVideoLink'");
if (dt.Rows.Count != 0)
{
mainVideo.VideoLink = dt.Rows[0]["ItemValue"].ToString();
}
else
{
mainVideo.VideoLink = "";
}
////////MainVideoSub1
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'MainVideoSub1'");
if (dt.Rows.Count != 0)
{
mainVideo.VideoSub1 = dt.Rows[0]["ItemValue"].ToString();
}
else
{
mainVideo.VideoSub1 = "";
}
/////////MainVideoSub2
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'MainVideoSub2'");
if (dt.Rows.Count != 0)
{
mainVideo.VideoSub2 = dt.Rows[0]["ItemValue"].ToString();
}
else
{
mainVideo.VideoSub2 = "";
}
/////////MainVideoBackground
dt = base.Select("SELECT A.[PicId] , B.[PicAddress] From [tbl_PicUse] AS A INNER JOIN [tbl_PicUploader]AS B ON A.PicId=B.PicId WHERE A.PicUseAs LIKE N'MainVideoBackground'");
if (dt.Rows.Count != 0)
{
mainVideo.MainVideoBackground_PicId = Convert.ToInt32(dt.Rows[0]["PicId"]);
mainVideo.MainVideoBackground_Pic = dt.Rows[0]["PicAddress"].ToString();
}
else
{
mainVideo.MainVideoBackground_PicId = 0;
mainVideo.MainVideoBackground_Pic = "";
}
/////////
////////VideoLogo
dt = base.Select("SELECT A.[PicId],[PicAddress],[PicThumbnailAddress] FROM [tbl_PicUploader] as A inner join [tbl_PicUse] as B on A.PicId=B.PicId where B.PicUseAs LIke N'VideoLogo'");
if (dt.Rows.Count != 0)
{
mainVideo.MainVideoLogo_Pic = dt.Rows[0]["PicAddress"].ToString();
mainVideo.MainVideoBackground_PicId = Convert.ToInt32(dt.Rows[0]["PicId"]);
}
else
{
mainVideo.MainVideoLogo_Pic = "";
mainVideo.MainVideoBackground_PicId = 0;
}
base.DC();
var model = new IndexModel()
{
mainVideo = mainVideo,
Clients = Clients,
portfolios = Portfolios,
Sliders = Sliders
};
return(model);
}
public string UpdateMainVideo(MainVideoModel model)
{
string s = "";
List <ExcParameters> parss;
ExcParameters par;
base.Connect();
////////MainVideoLink
DataTable dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'MainVideoLink'");
parss = new List <ExcParameters>();
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "MainVideoLink"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.VideoLink
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
////////MainVideoSub1
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'MainVideoSub1'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "MainVideoSub1"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.VideoSub1
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////MainVideoSub2
dt = base.Select("SELECT [ItemValue] FROM [tbl_SiteProperties] WHERE ItemKey Like N'MainVideoSub2'");
par = new ExcParameters
{
_KEY = "@ItemKey",
_VALUE = "MainVideoSub2"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@ItemValue",
_VALUE = model.VideoSub2
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_SiteProperties]([ItemKey],[ItemValue]) VALUES( @ItemKey , @ItemValue )", parss);
}
else
{
s += base.Script("UPDATE [tbl_SiteProperties] SET [ItemValue] = @ItemValue WHERE [ItemKey] LIKE @ItemKey", parss);
}
/////////MainVideoBackground
dt = base.Select("SELECT A.[PicId] , B.[PicAddress] From [tbl_PicUse] AS A INNER JOIN [tbl_PicUploader]AS B ON A.PicId=B.PicId WHERE A.PicUseAs LIKE N'MainVideoBackground'");
par = new ExcParameters
{
_KEY = "@UseAs",
_VALUE = "MainVideoBackground"
};
parss.Add(par);
par = new ExcParameters
{
_KEY = "@PicId",
_VALUE = model.MainVideoBackground_PicId
};
parss.Add(par);
if (dt.Rows.Count == 0)
{
s += base.Script("INSERT INTO [tbl_PicUse]([PicId],[PicUseAs]) VALUES(@PicId ,@UseAs)", parss);
}
else
{
s += base.Script("UPDATE [tbl_PicUse] SET [PicId] = @PicId WHERE [PicUseAs] = @UseAs ", parss);
}
/////////
base.DC();
if (s == "1111")
{
return("Success");
}
else
{
return("Fail");
}
}