protected void DataBinds() { if (QueryString != HF_QueryString || QueryString <= 0 || HF_QueryString <= 0) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>;alert('��ѯ�ַ��������ص��б�ҳ��');window.location.href='ProjectList.aspx;</script>"); return; } if (QueryString > 0) { LabMS.BLL.GuideBook GuideBook = new LabMS.BLL.GuideBook(); List<LabMS.Model.GuideBook> modellist = GuideBook.GetModelList("Guide_ProjectID=" + QueryString); if (modellist.Count != 0) { LabMS.Model.GuideBook model = modellist[0]; txb_Code.Text = model.Guide_BookCode; txb_BooKName.Text = model.Guide_BookName; txb_Editor.Text = model.Guide_Editor; if (model.Guide_PublishTime != null) { txb_PubTime.Text = model.Guide_PublishTime.Value.ToShortDateString(); } txb_Pub.Text = model.Guide_Press; txb_Award.Text = model.Guide_Award; txb_Content.Text = model.Guide_Content; } } }
protected void Submit_Click(object sender, EventArgs e) { if (QueryString != HF_QueryString || QueryString <= 0 && HF_QueryString <= 0) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('��ѯ�ַ�������');window.location.href='projectlist.aspx';</script>"); return; } if (string.IsNullOrEmpty(txb_Code.Text)) { LabMS.Common.JShelper.JSAlert(this, "Error", "ָ����ı�Ų���Ϊ��"); return; } if (string.IsNullOrEmpty(txb_BooKName.Text)) { LabMS.Common.JShelper.JSAlert(this, "Error", "ָ��������Ʋ���Ϊ��"); return; } if (string.IsNullOrEmpty(txb_Editor.Text)) { LabMS.Common.JShelper.JSAlert(this, "Error", "ָ����ı༭����Ϊ��"); return; } if (string.IsNullOrEmpty(txb_Pub.Text)) { LabMS.Common.JShelper.JSAlert(this, "Error", "ָ����ij����粻��Ϊ��"); return; } LabMS.BLL.GuideBook GuideBook = new LabMS.BLL.GuideBook(); LabMS.Model.GuideBook Book = new LabMS.Model.GuideBook(); Book.Guide_BookName = txb_BooKName.Text; Book.Guide_BookCode = txb_Code.Text; Book.Guide_Editor = txb_Editor.Text; Book.Guide_Award = txb_Award.Text; Book.Guide_Press = txb_Pub.Text; Book.Guide_Content = txb_Content.Text; string[] DateTimeList = { "yyyy/M/d tt hh:mm:ss", "yyyy/MM/dd tt hh:mm:ss", "yyyy/MM/dd HH:mm:ss", "yyyy/M/d HH:mm:ss", "yyyy/MM/dd", "yyyy-MM-dd hh:mm:ss", "yyyy-MM-dd", "yyyy-M-d" }; DateTime StarTime = DateTime.ParseExact(txb_PubTime.Text.Trim(), DateTimeList, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.AllowInnerWhite); Book.Guide_PublishTime = StarTime; Book.Guide_ProjectID = Convert.ToInt32(Request.QueryString["ID"].ToString()); if (fup_Attach.HasFile) { string savePath = HttpContext.Current.Request.MapPath(@"../Content/UpLoadFile/"); string Append = DateTime.Now.ToString("yyyyMMddhhmmss"); string FullPathFileName = savePath.Trim() + fup_Attach.FileName.Trim() + "_" + Append.Trim() + fup_Attach.FileName.Substring(fup_Attach.FileName.LastIndexOf(".")); bool save = true; int attachid = 0; if (fup_Attach.HasFile) { try { if (fup_Attach.PostedFile.ContentLength == 0) { LabMS.Common.JShelper.JSAlert(this, "�ļ��ϴ�ʧ��", "�ļ�����Ϊ��"); return; } fup_Attach.SaveAs(FullPathFileName); save = true; } catch { LabMS.Common.JShelper.JSAlert(this, "�ļ��ϴ�ʧ��", "�ļ��ϴ�ʧ��"); return; } } if (save) { LabMS.BLL.Attachment Attach = new LabMS.BLL.Attachment(); LabMS.Model.Attachment attach = new LabMS.Model.Attachment(); attach.Attach_Name = fup_Attach.FileName; attach.Attach_Address = "Content/UpLoadFile/" + fup_Attach.FileName + "_" + Append.Trim() + fup_Attach.FileName.Substring(fup_Attach.FileName.LastIndexOf(".")); attach.Attach_Type = "2"; attachid = Attach.Add(attach); if (attachid > 0) { Book.Guide_AttachID = attachid; } } } try { GuideBook.Add(Book); } catch (Exception ex) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>;alert('���ָ����ʧ�ܣ�');refreshParent();window.location.href='ProjectPreview.aspx?ID=" + Request.QueryString["ID"].Trim() + "'</script>"); return; } Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>;alert('���ʵ��ָ����ɹ���');refreshParent();window.location.href='ProjectPreview.aspx?ID=" + Request.QueryString["ID"].Trim() + "'</script>"); return; }
protected void DataBinds() { if (QueryString != HF_QueryString || QueryString <= 0 || HF_QueryString <= 0) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "script", "<script type='text/javascript'>alert('��ѯ�ַ�������');window.location.href='ProjectList.aspx';</script>"); return; } bool Ok=false; if (QueryString > 0) { try { LabMS.BLL.Project Project = new LabMS.BLL.Project(); LabMS.Model.Project projectmodel = Project.GetModel(QueryString); if (projectmodel != null) { LabMS.BLL.GuideBook GuideBook = new LabMS.BLL.GuideBook(); List<LabMS.Model.GuideBook> bookmodellist = GuideBook.GetModelList("Guide_ProjectID=" + QueryString.ToString()); if (bookmodellist.Count != 0) { LabMS.Model.GuideBook bookmodel = bookmodellist[0]; lb_Code.Text = bookmodel.Guide_BookCode; lb_Name.Text = bookmodel.Guide_BookName; lb_Editor.Text = bookmodel.Guide_Editor; lb_Press.Text = bookmodel.Guide_Editor; if (bookmodel.Guide_PublishTime != null) { lb_PublishTime.Text = bookmodel.Guide_PublishTime.Value.ToString("yyyy-MM"); } lb_Award.Text = bookmodel.Guide_Award; lt_Content.Text = bookmodel.Guide_Content; if (bookmodel.Guide_AttachID != null) { if (bookmodel.Guide_AttachID != 0) { LabMS.BLL.Attachment Attach = new LabMS.BLL.Attachment(); List<LabMS.Model.Attachment> lsModel = Attach.GetModelList("ID="+bookmodel.Guide_AttachID+" and Attach_Type= 2"); if (lsModel.Count != 0) { lk_DownLoad.Text = lsModel[0].Attach_Name; lk_DownLoad.CommandArgument = lsModel[0].ID.ToString() ; } else { lk_DownLoad.Visible = false; } } } } } } catch (Exception ex) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "script", "<script type='text/javascript'>alert('���ݿ��ȡ����');window.location.href='ProjectList.aspx';</script>"); return; } } }
/// <summary> /// -1 QueryID<0 0 Delete Error 1 Sucess /// </summary> /// <param name="QueryID"></param> /// <returns></returns> private int GuideBookDelete(int QueryID) { if (QueryID > 0) { try { LabMS.BLL.GuideBook GuideBook = new LabMS.BLL.GuideBook(); LabMS.Model.GuideBook GuideBookModel; List<LabMS.Model.GuideBook> ls = GuideBook.GetModelList("Guide_ProjectID=" + QueryID); if (ls.Count > 0) { GuideBookModel = ls[0]; if (GuideBookModel != null) { int? AttachID = GuideBookModel.Guide_AttachID; GuideBook.Delete(GuideBookModel.ID); if (AttachID.HasValue) { LabMS.BLL.Attachment Attachment = new LabMS.BLL.Attachment(); LabMS.Model.Attachment attachmodel = Attachment.GetModel(AttachID.Value); if (attachmodel != null) { Attachment.Delete(attachmodel.ID); } } return 1; } } } catch(Exception ex) { return 0; } } return -1; }
protected void Page_Load(object sender, EventArgs e) { strPagePrivilege.Add("SYXM"); strPageUserType.Add("mana"); if (!Page.IsPostBack) { if (Request.QueryString["ID"] != null) { if (IsNumber(Request.QueryString["ID"].ToString())) { LabMS.BLL.GuideBook GuideBook = new LabMS.BLL.GuideBook(); List<LabMS.Model.GuideBook> ls = GuideBook.GetModelList("Guide_ProjectID=" + querystring); if (ls.Count > 0) { btn_add.Visible = false; btn_edit.Visible = true; } else { btn_add.Visible = true; btn_edit.Visible = false; } DataBinds(); Gv_DataBinds(); } } else { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('��ѯ����������');window.location.href='';</script>"); } } }
protected bool GetGuideBook(object value) { if (value != null) { int ID = 0; if (int.TryParse(value.ToString(),out ID)) { if (ID > 0) { LabMS.BLL.GuideBook GuideBook = new LabMS.BLL.GuideBook(); List<LabMS.Model.GuideBook> ls = GuideBook.GetModelList("Guide_ProjectID =" +ID); if (ls.Count > 0) { return true; } } } } return false; }