protected void Page_Load(object sender, System.EventArgs e)
{
myAPI = new API(Session["DBName"].ToString());
if(!IsPostBack){
if(Request.Params["leafID"]==null)
Response.Redirect("./welcome.aspx");
txtItemName.Text = Request.Params["leafName"];
txtItemImgName.Text = Request.Params["leafImg"];
if(Request.Params["leafImg"]!=""){
ItemImg.ImageUrl = "./LibraryMOD/Images/" + Request.Params["leafImg"];
ItemImg.Visible=true;
}
txtItemSDate.SetDateTimeValue(Request.Params["leafSDate"]);
txtItemEDate.SetDateTimeValue(Request.Params["leafEDate"]);
txtItemID.Text = Request.Params["leafID"];
string SelectCmd = "Select * from MediaListTemplate where ML_PID = " + Request.Params["leafID"];
SqlDataReader myDataReader = myAPI.Create_Rd(SelectCmd);
if(myDataReader.Read()){
txtVideoID.Text = myDataReader["ML_UID"].ToString();
txtVideoName.Text = myDataReader["ML_Title"].ToString();
txtVideoImgName.Text = myDataReader["ML_Note1"].ToString();
if(myDataReader["ML_Note1"].ToString()!=""){
VideoImg.ImageUrl = "./LibraryMOD/Images/" + myDataReader["ML_Note1"].ToString();
VideoImg.Visible = true;
}
if(myDataReader["ML_OrderYN"].ToString()=="1")
cbOrder.Checked=true;
else
cbOrder.Checked=false;
txtVideoTime.Text = myDataReader["ML_Note2"].ToString();
if(myDataReader["ML_MediaStart"].ToString()!="" && myDataReader["ML_MediaEnd"].ToString()!=""){
VideoTimeStart = myDataReader["ML_MediaStart"].ToString();
VideoTimeEnd = myDataReader["ML_MediaEnd"].ToString();
txtVideoTimeStartHour.Text = VideoTimeStart.Substring(0,VideoTimeStart.IndexOf("h"));
txtVideoTimeStartMin.Text = VideoTimeStart.Substring(VideoTimeStart.IndexOf("h")+1,VideoTimeStart.IndexOf("m")-VideoTimeStart.IndexOf("h")-1);
txtVideoTimeStartSec.Text = VideoTimeStart.Substring(VideoTimeStart.IndexOf("n")+1,VideoTimeStart.IndexOf("s")-VideoTimeStart.IndexOf("n")-1);
txtVideoTimeEndHour.Text = VideoTimeEnd.Substring(0,VideoTimeEnd.IndexOf("h"));
txtVideoTimeEndMin.Text = VideoTimeEnd.Substring(VideoTimeEnd.IndexOf("h")+1,VideoTimeEnd.IndexOf("m")-VideoTimeEnd.IndexOf("h")-1);
txtVideoTimeEndSec.Text = VideoTimeEnd.Substring(VideoTimeEnd.IndexOf("n")+1,VideoTimeEnd.IndexOf("s")-VideoTimeEnd.IndexOf("n")-1);
}
ChooseVideo.Text = myDataReader["ML_Content"].ToString();
txtDescription.Text = myDataReader["ML_Description"].ToString();
}
else
txtVideoID.Text="new";
btnUpdateItem.Attributes.Add("onclick", "JavaScript:parent.leftFrame_reload();");
btnDelItem.Attributes.Add("onclick", "JavaScript:parent.leftFrame_reload();");
btnUpdateVideo.Attributes.Add("onclick","JavaScript:parent.leftFrame_reload();");
string ShowArea = myAPI.SqlExeSca("SELECT [Cate_ShowArea] FROM [CategoryTemplate] WHERE [Cate_UID] = "+this.Request.Params["leafID"] );
this.rbShowArea1.SelectedIndex = 3-Int32.Parse(ShowArea);
this.txtSort1.Text = myAPI.SqlExeSca("select [Cate_SortNum] FROM [CategoryTemplate] WHERE [Cate_UID] = "+this.Request.Params["leafID"] );
}
}
