protected void DataBinds(int ID)
{
LabMS.BLL.CourseOutLine couOutLin = new LabMS.BLL.CourseOutLine();
LabMS.Model.CourseOutLine couOutLinModel = new LabMS.Model.CourseOutLine();
couOutLinModel = couOutLin.GetModel(ID);
try
{
tb_Submitter.Text = couOutLinModel.COutLine_Submiter;
tb_Time.Text = string.Format("{0:d}", couOutLinModel.COutLine_SubmitTime);
tb_CourseName.Text = couOutLinModel.COutLine_Course;
tb_CourseCode.Text = couOutLinModel.COutLine_CourseCode;
tb_KeyWord.Text = couOutLinModel.COutLine_KeyWord;
tb_Content.Text = couOutLinModel.COutLine_Content.Replace("\r\n", "<br/>");
tb_CourseID.Text = couOutLinModel.COutLine_CourseID.ToString();
AttachID.Value = couOutLinModel.COutLine_Attach.ToString();
if (couOutLinModel.COutLine_Attach == null)
{
a1.Visible = false;
AttachmentName.Visible = false;
IsDelCB.Checked = true;
fp_Attachment.Attributes.Add("style", "display:block");
}
else
{
AttachmentName.Text = GetAttachName(int.Parse(couOutLinModel.COutLine_Attach.ToString()));
}
}
catch
{
ERRLbl.Text = "系统异常，参数不合法！";
ERRLbl.Visible = true;
ModifyBtn.Visible = false;
}
}
protected void Modify_Click(object sender, EventArgs e)
{
#region 验证
if (tb_KeyWord.Text.Equals(""))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "关键字不能为空!");
return;
}
if (tb_Content.Text.Equals(""))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "大纲内容不能为空!");
return;
}
#endregion
LabMS.BLL.CourseOutLine OutLine = new LabMS.BLL.CourseOutLine();
LabMS.Model.CourseOutLine model = new LabMS.Model.CourseOutLine();
model.COutLine_Submiter = tb_Submitter.Text;
model.COutLine_SubmitTime = DateTime.Parse(tb_Time.Text.Trim());
model.COutLine_KeyWord = tb_KeyWord.Text.Trim();
model.COutLine_CourseID = Convert.ToInt32(tb_CourseID.Text.Trim());
model.COutLine_Course = tb_CourseName.Text;
model.COutLine_CourseCode = tb_CourseCode.Text;
model.COutLine_Content = tb_Content.Text;
if (IsDelCB.Checked)
{
int AttachIDTemp=UpLoadFile();
if (AttachIDTemp == 0 || AttachIDTemp == -1)
{
return;
}
else
{
model.COutLine_Attach = AttachIDTemp;
}
}
else
{
model.COutLine_Attach = int.Parse(AttachID.Value);
}
model.ID = int.Parse(CouOutLinID.Value);
OutLine.Update(model);
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "script", "<script type='text/javascript'>alert('更新成功！');window.location.href='CourseOutLinePreview.aspx"+model.ID+"';</script>");
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.CourseOutLine GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,COutLine_SubmitTime,COutLine_Submiter,COutLine_CourseID,COutLine_Course,COutLine_CourseCode,COutLine_KeyWord,COutLine_Content,COutLine_Attach from CourseOutLine ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
LabMS.Model.CourseOutLine model=new LabMS.Model.CourseOutLine();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["ID"].ToString()!="")
{
model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if(ds.Tables[0].Rows[0]["COutLine_SubmitTime"].ToString()!="")
{
model.COutLine_SubmitTime=DateTime.Parse(ds.Tables[0].Rows[0]["COutLine_SubmitTime"].ToString());
}
model.COutLine_Submiter=ds.Tables[0].Rows[0]["COutLine_Submiter"].ToString();
if(ds.Tables[0].Rows[0]["COutLine_CourseID"].ToString()!="")
{
model.COutLine_CourseID=int.Parse(ds.Tables[0].Rows[0]["COutLine_CourseID"].ToString());
}
model.COutLine_Course=ds.Tables[0].Rows[0]["COutLine_Course"].ToString();
model.COutLine_CourseCode=ds.Tables[0].Rows[0]["COutLine_CourseCode"].ToString();
model.COutLine_KeyWord=ds.Tables[0].Rows[0]["COutLine_KeyWord"].ToString();
model.COutLine_Content=ds.Tables[0].Rows[0]["COutLine_Content"].ToString();
if(ds.Tables[0].Rows[0]["COutLine_Attach"].ToString()!="")
{
model.COutLine_Attach=int.Parse(ds.Tables[0].Rows[0]["COutLine_Attach"].ToString());
}
return model;
}
else
{
return null;
}
}
protected void Save_Click(object sender, EventArgs e)
{
LabMS.BLL.CourseOutLine OutLine = new LabMS.BLL.CourseOutLine();
List<LabMS.Model.CourseOutLine> outlinelist = new List<LabMS.Model.CourseOutLine>();
LabMS.Model.CourseOutLine model = new LabMS.Model.CourseOutLine();
#region ��֤
int TempID=0;
if (!int.TryParse(tb_CourseID.Text, out TempID))
{
if (TempID <= 0)
{
Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('ϵͳ�쳣');window.location.href='../ClassPlan/ProjectCourseList.aspx';</script>");
}
}
int CourseID = TempID;
if (tb_CourseID.Text.Equals(""))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "�γ����Ʋ���Ϊ��!");
return;
}
if (tb_KeyWord.Text.Equals(""))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "�ؼ��ֲ���Ϊ��!");
return;
}
if (tb_Content.Text.Equals(""))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "������ݲ���Ϊ��!");
return;
}
string strWhere = " COutLine_CourseID=" + CourseID;
outlinelist = OutLine.GetModelList(strWhere);
if (outlinelist.Count != 0)
{
LabMS.Common.JShelper.JSAlert(Page, "err", "��ѡ�γ��Ѵ��ڴ��!");
return;
}
if (string.IsNullOrEmpty(tb_Submitter.Text))
{
LabMS.Common.JShelper.JSAlert(Page, "error", "�����Ϊ�գ�����ϵ����Ա");
return;
}
#endregion
model.COutLine_Submiter = tb_Submitter.Text;
model.COutLine_SubmitTime = DateTime.Now;
model.COutLine_KeyWord = tb_KeyWord.Text.Trim();
model.COutLine_CourseID = CourseID;
model.COutLine_Course = tb_CourseName.Text;
model.COutLine_CourseCode = tb_CourseCode.Text;
model.COutLine_Content = tb_Content.Text;
int AttachIDTemp = UpLoadFile();
if (AttachIDTemp > 0)
{
model.COutLine_Attach = UpLoadFile();
}
try
{
OutLine.Add(model);
}
catch
{
LabMS.Common.JShelper.JSAlert(Page, "AddFailed", "���ʧ��!");
return;
}
LabMS.Common.JShelper.JSAlertAndRedirect(Page, "AddSuccess", "��ӳɹ�!", "../../ClassPlan/ProjectCourseList.aspx");
}