/// <summary>
///更新记录
/// </summary>
/// <param name="Courseware"></param>
/// <returns></returns>
public bool GetUpdate(M_Courseware courseware)
{
string sqlStr = "UPDATE [dbo].[ZL_Courseware] SET [Courseware] = @Courseware,[CoursNum] = @CoursNum,[Listen] = @Listen,[UpdateTime] = @UpdateTime,[FileUrl] = @FileUrl,[CourseID] = @CourseID,[Speaker]=@Speaker,[SJName]=@SJName,[Status]=@Status,[Description]=@Description,[Classification]=@Classification,[CoursType]=@CoursType,[CreationTime]=@CreationTime WHERE [ID] = @ID";
SqlParameter[] cmdParams = courseware.GetParameters();
return(SqlHelper.ExecuteSql(sqlStr, cmdParams));
}
/// <summary>
///添加记录
/// </summary>
/// <param name="Courseware"></param>
/// <returns></returns>
public int GetInsert(M_Courseware courseware)
{
string sqlStr = "INSERT INTO [dbo].[ZL_Courseware] ([Courseware],[CoursNum],[Listen],[UpdateTime],[FileUrl],[CourseID],[Speaker],[SJName],[Status],[Description],[Classification],[CoursType],[CreationTime]) VALUES (@Courseware,@CoursNum,@Listen,@UpdateTime,@FileUrl,@CourseID,@Speaker,@SJName,@Status,@Description,@Classification,@CoursType,@CreationTime);select @@IDENTITY";
SqlParameter[] cmdParams = courseware.GetParameters();
return(SqlHelper.ObjectToInt32(SqlHelper.ExecuteScalar(CommandType.Text, sqlStr, cmdParams)));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
int id = DataConverter.CLng(coureId.Value);
M_Courseware mc = bcourse.GetSelect(id);
mc.Courseware = this.txt_Courename.Text;
mc.Speaker = this.TextBox1.Text;
mc.SJName = this.TextBox2.Text;
mc.CoursNum = DataConverter.CLng(this.txt_Order.Text);
mc.CoursType = DataConverter.CLng(this.RadioButtonList1.SelectedValue);
mc.Status = DataConverter.CLng(this.RadioButtonList2.SelectedValue);
mc.Listen = DataConverter.CLng(this.rblHot.SelectedValue);
mc.Description = this.txtP_Content.Text;
mc.FileUrl = this.txtUrl.Text;
mc.UpdateTime = DateTime.Now;
mc.CreationTime = DateTime.Now;
if (mc != null && mc.ID > 0)
{
bool result = bcourse.GetUpdate(mc);
if (result)
{
function.WriteSuccessMsg("修改成功！");
}
else
{
function.WriteErrMsg("修改失败！");
}
}
}
protected void EBtnSubmit_Click(object sender, EventArgs e)
{
int id = DataConverter.CLng(coureId.Value);
M_Courseware mc = bcourw.GetSelect(id);
mc.Courseware = this.txt_Courename.Text;
mc.Speaker = this.TextBox1.Text;
mc.SJName = this.TextBox2.Text;
mc.CoursNum = DataConverter.CLng(this.txt_Order.Text);
mc.CoursType = DataConverter.CLng(this.RadioButtonList1.SelectedValue);
mc.Status = DataConverter.CLng(this.RadioButtonList2.SelectedValue);
mc.Listen = rblHot.Checked ? 1 : 0;
mc.Description = this.txtP_Content.Text;
mc.FileUrl = this.txtUrl.Text;
mc.UpdateTime = DateTime.Now;
mc.CourseID = DataConverter.CLng(cid.Value);
mc.CreationTime = DateTime.Now;
if (mc != null && mc.ID > 0)
{
bool result = bcourw.GetUpdate(mc);
if (result)
{
function.WriteSuccessMsg("修改成功！");
}
else
{
function.WriteErrMsg("修改失败！");
}
}
else
{
int ids = bcourw.GetInsert(mc);
if (ids > 0)
{
function.WriteSuccessMsg("添加成功！");
}
else
{
function.WriteErrMsg("添加失败!");
}
}
int Course = DataConverter.CLng(Request.QueryString["CourseID"]);
MyBind();
}
protected void Page_Load(object sender, EventArgs e)
{
liCoures.Text = "添加课件";
cid.Value = Course.ToString();
if (!string.IsNullOrEmpty(Request.QueryString["menu"]) && Request.QueryString["menu"] == "del")
{
int cids = DataConverter.CLng(Request.QueryString["id"]);
bcourw.DeleteByGroupID(cids);
}
if (!IsPostBack)
{
int id = DataConverter.CLng(Request.QueryString["ID"]);
coureId.Value = id.ToString();
M_Courseware mcs = bcourw.GetSelect(id);
if (mcs != null && mcs.ID > 0)
{
liCoures.Text = "添加课件";
this.txt_Courename.Text = mcs.Courseware;
this.TextBox1.Text = mcs.Speaker;
this.TextBox2.Text = mcs.SJName;
this.txt_Order.Text = (mcs.CoursNum).ToString();
this.RadioButtonList1.SelectedValue = mcs.CoursType.ToString();
this.RadioButtonList2.SelectedValue = mcs.Status.ToString();
this.rblHot.Checked = mcs.Listen == 1 ? true : false;
this.txtP_Content.Text = mcs.Description;
this.txtUrl.Text = mcs.FileUrl;
}
else
{
this.txt_Courename.Text = "";
this.TextBox1.Text = "";
this.TextBox2.Text = "";
this.txt_Order.Text = "";
this.RadioButtonList1.SelectedValue = "";
this.RadioButtonList2.SelectedValue = "";
this.rblHot.Checked = false;
this.txtP_Content.Text = "";
this.txtUrl.Text = "";
}
MyBind();
Call.SetBreadCrumb(Master, "<li>教育模块</li><li><a href='QuestionManage.aspx'>在线考试系统</a></li><li>课程管理</li><li><a href='AddCourseware.aspx?CourseID=" + Request.QueryString["CourseID"] + "'>" + liCoures.Text + "</a></li>");
}
}
private static M_Courseware GetInfoFromReader(SqlDataReader rdr)
{
M_Courseware info = new M_Courseware();
info.ID = DataConverter.CLng(rdr["ID"].ToString());
info.Courseware = rdr["Courseware"].ToString();
info.CoursNum = DataConverter.CLng(rdr["CoursNum"].ToString());
info.Listen = DataConverter.CLng(rdr["Listen"].ToString());
info.UpdateTime = DataConverter.CDate(rdr["UpdateTime"].ToString());
info.FileUrl = rdr["FileUrl"].ToString();
info.CourseID = DataConverter.CLng(rdr["CourseID"].ToString());
info.Speaker = rdr["Speaker"].ToString();
info.SJName = rdr["SJName"].ToString();
info.Status = DataConverter.CLng(rdr["Status"].ToString());
info.Description = rdr["Description"].ToString();
info.Classification = rdr["Classification"].ToString();
info.CoursType = DataConverter.CLng(rdr["CoursType"].ToString());
info.CreationTime = DataConverter.CDate(rdr["CreationTime"].ToString());
rdr.Close();
rdr.Dispose();
return(info);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int id = DataConverter.CLng(Request.QueryString["ID"]);
coureId.Value = id.ToString();
M_Courseware mcs = bcourse.GetSelect(id);
if (mcs != null && mcs.ID > 0)
{
this.txt_Courename.Text = mcs.Courseware;
this.TextBox1.Text = mcs.Speaker;
this.TextBox2.Text = mcs.SJName;
this.txt_Order.Text = (mcs.CoursNum).ToString();
this.RadioButtonList1.SelectedValue = mcs.CoursType.ToString();
this.RadioButtonList2.SelectedValue = mcs.Status.ToString();
this.rblHot.SelectedValue = mcs.Listen.ToString();
this.txtP_Content.Text = mcs.Description;
this.txtUrl.Text = mcs.FileUrl;
}
}
Call.SetBreadCrumb(Master, "<li>教育模块</li><li><a href='QuestionManage.aspx'>在线考试系统</a></li><li>修改试听文件</li>");
}