/// <summary> /// �����Ŀ /// </summary> private void AddProject() { ProjectClass prj = new ProjectClass(); HttpCookie UserCookie = Request.Cookies["Username"]; String Username = UserCookie.Value.ToString(); if(DateTime.Parse(this.txtStartDate.Text.ToString())>DateTime.Parse(this.txtEndDate.Text.ToString())) { Response.Write("<script language=javascript>alert('��ʼʱ�䲻�ܴ��ڽ���ʱ��!');</script>"); } else { try { prj.Add(Int32.Parse(ClassID),this.txtClassName.Value.ToString(),this.txtBrief.Value.ToString(), Username,Int32.Parse(this.Status.SelectedIndex.ToString()),Int32.Parse(this.txtScale.Value.ToString()), DateTime.Parse(this.txtStartDate.Text.ToString()),DateTime.Parse(this.txtEndDate.Text.ToString())); prj = null; Response.Write("<script language=javascript>alert('��ӳɹ�!');parent.LeftFrame.location='ProjectTreeView.aspx?classID="+ClassID+"';</script>"); } catch(Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } } }
private void Page_Load(object sender, System.EventArgs e) { FromID = (Request.QueryString["FromID"] != null)?Request.QueryString["FromID"].ToString():""; if (!Page.IsPostBack) { Action = (Request.QueryString["Action"] != null)?Request.QueryString["Action"].ToString():""; if (Action == "1") { ToID = (Request.QueryString["ToID"] != null)?Request.QueryString["ToID"].ToString():""; UDS.Components.ProjectClass prj = new UDS.Components.ProjectClass(); try { prj.Remove(Int32.Parse(FromID), Int32.Parse(ToID)); Response.StatusCode = 200; Response.Write("OK"); } catch (Exception eX) { Response.StatusCode = 400; Response.StatusDescription = eX.Message; Response.Write(eX.Message); } finally { prj = null; } Response.End(); } InitRootNodeDataTable(); InitTreeRootNode(TreeView1.Nodes); } }
// ����ȱʡֵ public void ShowAvailable() { ProjectClass pjt = new ProjectClass (); UserCookie = Request.Cookies["Username"]; string Username = UserCookie.Value.ToString(); int classID = Int32.Parse(ClassID); int cstRightToApproveDocument = 2; int cstRightToViewDocument = 10; int cstRightToBuildNode = 5; int cstDisplayMember = 6; int cstTeamRight = 7; int cstComposeMail = 11; int cstDeliveryDoc = 11; int cstProjectMove = 12; int cstProjectCopy = 12; int cstDeleteDocument = 3; this.lblManageDirectory.Visible = pjt.GetAccessPermission(classID,Username,cstRightToBuildNode); this.lblDeliveryDoc.Visible = pjt.GetAccessPermission(classID,Username,cstDeliveryDoc); this.lblShowMember.Visible = pjt.GetAccessPermission(classID,Username,cstDisplayMember); this.lblManagePermission.Visible= pjt.GetAccessPermission(classID,Username,cstTeamRight); this.lnkbtnDelete.Visible = pjt.GetAccessPermission(classID,Username,cstDeleteDocument); this.lblRemove .Visible = pjt.GetAccessPermission(classID,Username,cstProjectMove); this.lblCopy .Visible = pjt.GetAccessPermission(classID,Username,cstProjectMove); pjt = null; }
/// <summary> /// ������post���� /// </summary> private DocBody ProcessFormPost() { ProjectClass pjt = new ProjectClass (); int cstRightToApproveDocument = 2; //����֤ if(Request.IsAuthenticated) { // ���������ݲ��� DocBody docbody = new DocBody(); docbody.DocTitle = this.txtTitle.Value; docbody.DocContent = this.txtContent.Value; docbody.DocAddedBy = Username; docbody.DocClassID = Int32.Parse(ClassID); docbody.DocAddedDate = DateTime.Now.ToString(); docbody.DocApprover = (pjt.GetAccessPermission(Int32.Parse(ClassID),Username,cstRightToApproveDocument))?Username:""; docbody.DocApproveDate = (pjt.GetAccessPermission(Int32.Parse(ClassID),Username,cstRightToApproveDocument))?DateTime.Now.ToString():""; docbody.DocApproved = (docbody.DocApprover =="")?0:1; docbody.DocAttribute = 0; docbody.DocType = 0; return docbody; } else { return null; } }
/// <summary> /// ��ʾ���� /// </summary> private void PopulateData() { #region ��ʼ������ DataTable dataTable = new DataTable(); SqlDataReader dataReader = null; ProjectClass pjt = new ProjectClass (); MailClass mail = new MailClass(); DocumentClass doc = new DocumentClass(); #endregion #region ��ȡ��Ŀ��Ϣ dataReader = pjt.GetClassInfo(classID); try { if (dataReader.Read()) { this.lblClassName.Text = dataReader[0].ToString(); this.lblParentClassName.Text = dataReader[2].ToString(); this.lblBuildDate.Text = dataReader[3].ToString(); this.lblEndDate.Text = dataReader[4].ToString(); this.lblFinishedScale.Text = dataReader[8].ToString(); this.lblDescription.Text = dataReader[7].ToString(); } } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ��ȡ����Ŀ��Ϣ dataReader = pjt.GetSubClassInfo(classID); try { while (dataReader.Read()) { this.lblSubClass.Text += "<a href='Switch.aspx?Action=1&ClassID=" + dataReader[0].ToString() + "'>" + dataReader[1].ToString() + "</a> "; } if (this.lblSubClass.Text == "") this.lblSubClass.Text = "��"; } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ��ȡ��Ŀ��Ա��Ϣ dataReader = pjt.GetMemberInClass(classID); try { while (dataReader.Read()) { this.lblMember.Text += "<a href='Mail/Compose.aspx?Action=3" + "&ClassID=" + classID.ToString() + "&Username="******"Staff_Name"].ToString() + "&Name=" + Server.UrlEncode(dataReader["RealName"].ToString()) + "'>" + dataReader["RealName"].ToString() + "</a> "; } if (this.lblMember.Text == "") this.lblMember.Text = "��"; } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ��ȡ��Ŀ�ϼ���������Ϣ dataReader = pjt.GetParentLeader(classID); try { if (dataReader.Read()) { this.lblParentLeader.Text += "<a href='Mail/Compose.aspx?Action=3" + "&ClassID=" + classID.ToString() + "&Username="******"Staff_Name"].ToString() + "&Name=" + Server.UrlEncode(dataReader["RealName"].ToString()) + "'>" + dataReader["RealName"].ToString() + "</a> "; } if (this.lblParentLeader.Text == "") this.lblParentLeader.Text = "��"; } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ��ȡ��Ŀ��������Ϣ dataReader = pjt.GetLeader(classID); try { while (dataReader.Read()) { this.lblLeader.Text += "<a href='Mail/Compose.aspx?Action=3" + "&ClassID=" + classID.ToString() + "&Username="******"Staff_Name"].ToString() + "&Name=" + Server.UrlEncode(dataReader["RealName"].ToString()) + "'>" + dataReader["RealName"].ToString() + "</a> "; } if (this.lblLeader.Text == "") this.lblLeader.Text = "��"; } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } //dataReader = null; finally { dataReader.Close(); } #endregion }
/// <summary> /// ����ʱ���� /// </summary> private void PopulateReviseData() { SqlDataReader dataReader = null; ProjectClass prj = new ProjectClass(); try { dataReader = prj.GetProjectDetail(Int32.Parse(ClassID)); dataReader.Read(); this.txtClassName.Value = dataReader[0].ToString(); this.txtBrief.Value = dataReader[7].ToString(); this.txtScale .Value = dataReader[6].ToString(); this.txtStartDate.Text = dataReader.IsDBNull(3) ? "" : DateTime.Parse(dataReader[3].ToString()).ToString("yyyy-MM-dd"); this.txtEndDate.Text = dataReader.IsDBNull(4) ? "" : DateTime.Parse(dataReader[4].ToString()).ToString("yyyy-MM-dd"); this.Status.SelectedIndex = Int32.Parse(dataReader[5].ToString()); prj = null; dataReader = null; } catch(Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } }
private void Page_Load(object sender, System.EventArgs e) { ClassID = (Request.QueryString["ClassID"]!=null)?Request.QueryString["ClassID"].ToString():""; Action = (Request.QueryString["Action"]!=null)?Request.QueryString["Action"].ToString():""; if(!Page.IsPostBack) { PopulateRadioList(); if(Action=="1") { this.lblCreate.BackColor = Color.FromName("#1ED2CA"); this.btnRevise.Visible = false; this.btnDelete.Visible = false; } if(Action=="2") { UDS.Components .ProjectClass prj = new ProjectClass(); this.lblDelete.BackColor = Color.FromName("#1ED2CA"); this.btnRevise .Visible = false; this.btnDelete.Visible = true; this.btnSubmit .Visible = false; PopulateReviseData(); if(ClassID!="1") { if(prj.IsExistSubClass(Int32.Parse(ClassID))) this.btnDelete.Attributes["onClick"] = "javascript:alert('����Ŀ�������ӽڵ㣬����ɾ��!!');return false;"; else this.btnDelete.Attributes["onClick"] = "javascript:return confirm('��ȷ����?');"; } else { this.btnDelete.Attributes["onClick"] = "javascript:alert('���ڵ㲻�ܱ�ɾ��!');return false;"; } } if(Action=="3") { this.lblRevise.BackColor = Color.FromName("#1ED2CA"); this.btnSubmit.Visible = false; this.btnDelete .Visible = false; PopulateReviseData(); } } }
public void MailIncoming(string MailID,string ClassID) { if(MailID!=""&&ClassID!="") { SqlDataReader dataReader = null; try { String Username = Server.UrlDecode(Request.Cookies["UserName"].Value); MailClass mailclass = new MailClass(); ProjectClass pjt = new ProjectClass(); DocBody docbody = new DocBody(); DocumentClass doc = new DocumentClass(); dataReader = mailclass.GetMailCompleteInfoDbreader(MailID); if (dataReader.Read()) { int cstRightToApproveDocument = 2; docbody.DocTitle = dataReader["MailSubject"].ToString(); docbody.DocContent = dataReader["MailBody"].ToString(); ; docbody.DocAddedBy = dataReader["MailSender"].ToString(); ; docbody.DocClassID = Int32.Parse(ClassID); docbody.DocAddedDate = DateTime.Now.ToString(); docbody.DocApprover = (pjt.GetAccessPermission(Int32.Parse(ClassID), Username, cstRightToApproveDocument)) ? Username : ""; docbody.DocApproveDate = (pjt.GetAccessPermission(Int32.Parse(ClassID), Username, cstRightToApproveDocument)) ? DateTime.Now.ToString() : ""; docbody.DocApproved = (docbody.DocApprover == "") ? 0 : 1; docbody.DocAttribute = 0; docbody.DocType = 0; } dataReader.Close(); string DocID = doc.AddDocBody(docbody); dataReader = mailclass.GetMailAttInfoDbreader(MailID); while (dataReader.Read()) { DocAttachFile docatt = new DocAttachFile(); docatt.FileAttribute = 0; docatt.FileSize = Int32.Parse(dataReader["FileSize"].ToString()); docatt.FileName = dataReader["FileName"].ToString(); docatt.FileAuthor = Username; docatt.FileCatlog = "�ĵ�"; docatt.FileVisualPath = "Mail" + dataReader["FileVisualPath"].ToString(); docatt.FileAddedDate = DateTime.Now.ToString(); docatt.DocID = Int32.Parse(DocID); doc.AddAttach(docatt, Int32.Parse(DocID)); } // dataReader = null; if (dataReader != null) { dataReader.Close(); } pjt = null; docbody = null; Response.Write("<script language=javascript>alert('�鵵�ɹ�!');</script>"); } catch (Exception oe) { UDS.Components.Error.Log(oe.ToString()); Server.Transfer("../Error.aspx"); } finally { if (dataReader != null) { dataReader.Close(); } } } }
private void PopulateData(TaskClass tsk) { string ClassName = "",Type=""; switch (tsk.Type) { case 1: Type="����"; break; case 2: Type="�İ�"; break; case 3: Type="����"; break; case 4: Type="�绰"; break; case 5: Type="�߷�"; break; case 6: Type="���"; break; case 7: Type="����"; break; case 8: Type="����"; break; } this.lblSubject .Text = tsk.Subject ; this.lblDetail .Text = tsk.Detail ; this.lblStartTime .Text = (DateTime.Parse(tsk.StartTime).ToShortTimeString()=="0:00")?DateTime.Parse(tsk.StartTime).ToShortDateString()+" 8:00":tsk.StartTime; this.lblEndTime .Text = (DateTime.Parse(tsk.EndTime).ToShortTimeString()=="0:00")?DateTime.Parse(tsk.EndTime).ToShortDateString()+" 18:00":tsk.EndTime; this.lblArrangedBy .Text = UDS.Components .Staff.GetRealNameByUsername(tsk.ArrangedBy) ; this.lblCooperator .Text = UDS.Components .Staff.GetRealNameStrByUsernameStr(tsk.CooperatorList,0) ; this.lblType.Text = Type; this.lblAttribute.Text = tsk.Attribute.ToString()=="1"?"��ռ����":"��ʱ����"; if(tsk.ProjectID!=0) { ProjectClass prj = new ProjectClass(); SqlDataReader dataReader = prj.GetProjectDetail(tsk.ProjectID); try { if (dataReader.Read()) ClassName = dataReader["ClassName"].ToString(); } finally { dataReader.Close(); } prj = null; } this.lblProjectID .Text = (tsk.ProjectID ==0)?"��":"<a href='#' onclick=javascript:window.close();window.dialogArguments.location='../UnitiveDocument/Project.aspx?classID="+tsk.ProjectID .ToString()+"'>"+ClassName+"</a>"; }
private void Page_Load(object sender, System.EventArgs e) { FromID = (Request.QueryString["FromID"]!=null)?Request.QueryString["FromID"].ToString():""; if(!Page.IsPostBack) { Action = (Request.QueryString["Action"]!=null)?Request.QueryString["Action"].ToString():""; if(Action=="1") { ToID = (Request.QueryString["ToID"]!=null)?Request.QueryString["ToID"].ToString():""; UDS.Components.ProjectClass prj = new UDS.Components.ProjectClass(); try { prj.Remove(Int32.Parse(FromID), Int32.Parse(ToID)); Response.StatusCode = 200; Response.Write("OK"); } catch (Exception eX) { Response.StatusCode = 400; Response.StatusDescription = eX.Message; Response.Write(eX.Message); } finally { prj = null; } Response.End(); } InitRootNodeDataTable(); InitTreeRootNode(TreeView1.Nodes); } }
private void Page_Load(object sender, System.EventArgs e) { FromID = (Request.QueryString["FromID"]!=null)?Request.QueryString["FromID"].ToString():""; if(!Page.IsPostBack) { Action = (Request.QueryString["Action"]!=null)?Request.QueryString["Action"].ToString():""; if(Action=="1") { ToID = (Request.QueryString["ToID"]!=null)?Request.QueryString["ToID"].ToString():""; UDS.Components.ProjectClass prj = new UDS.Components.ProjectClass(); prj.Remove(Int32.Parse(FromID),Int32.Parse(ToID)); prj = null; Response.End(); } InitRootNodeDataTable(); InitTreeRootNode(TreeView1.Nodes); //InitTree(TreeView1.Nodes,"0"); } }
/// <summary> /// �ĵ��������������ĵ�������������� /// </summary> private void DocProcess(MailMainBody mailbody,ArrayList upattlist) { string DocID = ""; int cstRightToApproveDocument = 2; ProjectClass pjt = new ProjectClass(); DocBody docbody = new DocBody(); docbody.DocTitle = mailbody.MailSubject; docbody.DocContent = mailbody.MailBody; docbody.DocAddedBy = mailbody.MailSender; docbody.DocClassID = mailbody.MailClassID; docbody.DocAddedDate = DateTime.Now.ToString(); docbody.DocApprover = (pjt.GetAccessPermission(Int32.Parse(ClassID),Username,cstRightToApproveDocument))?Username:""; docbody.DocApproveDate = (pjt.GetAccessPermission(Int32.Parse(ClassID),Username,cstRightToApproveDocument))?DateTime.Now.ToString():""; docbody.DocApproved = (docbody.DocApprover =="")?0:1; docbody.DocAttribute = 0; docbody.DocType = 0; DocumentClass doc = new DocumentClass(); // ����ĵ�,������ID DocID = doc.AddDocBody(docbody); foreach(UDS.Components.MailAttachFile att in upattlist) { try { DocAttachFile docatt = new DocAttachFile(); // Mail Attach File ��ת��ΪDoc Attach File docatt.FileAttribute = 0; docatt.FileSize = att.FileSize; docatt.FileName = att.FileName; docatt.FileAuthor = Username; docatt.FileCatlog = "�ĵ�"; docatt.FileVisualPath = "Mail"+att.FileVisualPath; docatt.FileAddedDate = DateTime.Now.ToString(); docatt.DocID = Int32.Parse(DocID); // ת������ // �������ݿ�� doc.AddAttach(docatt,Int32.Parse(DocID)); } catch(Exception ioex) { UDS.Components.Error.Log(ioex.ToString()); Server.Transfer("../../Error.aspx"); } } }
public void MailIncoming(string MailID,string ClassID) { SqlDataReader dataReader = null; if(MailID!=""&&ClassID!="") { try { throw new Exception("�������"); String Username = Request.Cookies["Username"].Value.ToString(); MailClass mailclass = new MailClass(); ProjectClass pjt = new ProjectClass(); DocBody docbody = new DocBody(); DocumentClass doc = new DocumentClass(); dataReader = mailclass.GetMailCompleteInfoDbreader(MailID); if (dataReader.Read()) { int cstRightToApproveDocument = 2; docbody.DocTitle = dataReader["MailSubject"].ToString(); docbody.DocContent = dataReader["MailBody"].ToString(); ; docbody.DocAddedBy = dataReader["MailSender"].ToString(); ; docbody.DocClassID = Int32.Parse(ClassID); docbody.DocAddedDate = DateTime.Now.ToString(); docbody.DocApprover = (pjt.GetAccessPermission(Int32.Parse(ClassID), Username, cstRightToApproveDocument)) ? Username : ""; docbody.DocApproveDate = (pjt.GetAccessPermission(Int32.Parse(ClassID), Username, cstRightToApproveDocument)) ? DateTime.Now.ToString() : ""; docbody.DocApproved = (docbody.DocApprover == "") ? 0 : 1; docbody.DocAttribute = 0; docbody.DocType = 0; } dataReader.Close(); string DocID = doc.AddDocBody(docbody); dataReader = mailclass.GetMailAttInfoDbreader(MailID); while (dataReader.Read()) { DocAttachFile docatt = new DocAttachFile(); docatt.FileAttribute = 0; docatt.FileSize = Int32.Parse(dataReader["FileSize"].ToString()); docatt.FileName = dataReader["FileName"].ToString(); docatt.FileAuthor = Username; docatt.FileCatlog = "�ĵ�"; docatt.FileVisualPath = "Mail" + dataReader["FileVisualPath"].ToString(); docatt.FileAddedDate = DateTime.Now.ToString(); docatt.DocID = Int32.Parse(DocID); doc.AddAttach(docatt, Int32.Parse(DocID)); } dataReader = null; pjt = null; docbody = null; } catch (Exception oe) { throw new Exception(oe.Message); } finally { if(null != dataReader) if (!dataReader.IsClosed) { dataReader.Close(); } } } }
/// <summary> /// ��ʾ���� /// </summary> private void PopulateData() { #region ��ʼ������ SqlDataReader dataReader = null; //try //{ DataTable dataTable = new DataTable(); ProjectClass pjt = new ProjectClass(); MailClass mail = new MailClass(); DocumentClass doc = new DocumentClass(); #endregion #region ��ȡ��Ŀ��Ϣ dataReader = pjt.GetClassInfo(classID); try { if (dataReader.Read()) { this.lblClassName.Text = dataReader[0].ToString(); // this.lblParentClassName.Text = dataReader[2].ToString(); // this.lblBuildDate.Text = dataReader[3].ToString(); // this.lblEndDate.Text = dataReader[4].ToString(); // this.lblFinishedScale.Text = dataReader[8].ToString(); // this.lblDescription.Text = dataReader[7].ToString(); } } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ��ȡ��Ŀ��Ա��Ϣ dataReader = pjt.GetMemberInClass(classID); int i = 0; try { while (dataReader.Read()) { if (i < 3) this.lblMember.Text += "<a href='Mail/Compose.aspx?Action=3" + "&ClassID=" + classID.ToString() + "&Username="******"Staff_Name"].ToString() + "&Name=" + Server.UrlEncode(dataReader["RealName"].ToString()) + "'>" + dataReader["RealName"].ToString() + "</a> "; i++; } if (i >= 3) this.lblMember.Text += ".."; if (this.lblMember.Text == "") this.lblMember.Text = ""; } catch (Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } dataReader = null; #endregion #region ����Ȩ����ʾ��ع��ܱ��� // ����ȱʡֵ int cstRightToApproveDocument = 2; int cstRightToViewDocument = 10; int cstRightToBuildNode = 5; int cstDisplayMember = 6; int cstTeamRight = 7; int cstComposeMail = 11; int cstDeliveryDoc = 11; int cstProjectMove = 12; this.lblManageProject.Visible = pjt.GetAccessPermission(classID, Username, cstRightToBuildNode); // this.imgManageProject.Visible = this.lblManageProject.Visible; this.lblManageDirectory.Visible = pjt.GetAccessPermission(classID, Username, cstRightToBuildNode); // this.imgManageDirectory.Visible = this.lblManageDirectory.Visible; this.lblComposeMail.Visible = pjt.GetAccessPermission(classID, Username, cstComposeMail); // this.imgComposeMail.Visible = this.lblComposeMail.Visible; this.lblDeliveryDoc.Visible = pjt.GetAccessPermission(classID, Username, cstDeliveryDoc); // this.imgDeliveryDoc.Visible = this.lblDeliveryDoc.Visible; this.lblShowMember.Visible = pjt.GetAccessPermission(classID, Username, cstDisplayMember); // this.imgShowMember.Visible = this.lblShowMember.Visible; this.lblManagePermission.Visible = pjt.GetAccessPermission(classID, Username, cstTeamRight); // this.imgManagePermission.Visible = this.lblManagePermission.Visible; this.lblRemove.Visible = pjt.GetAccessPermission(classID, Username, cstProjectMove); // this.imgRemove.Visible = this.lblRemove.Visible; // this.tr1.Visible = pjt.GetAccessPermission(classID,Username,cstRightToViewDocument); // this.tr3.Visible = pjt.GetAccessPermission(classID,Username,cstRightToApproveDocument); this.line1.Visible = pjt.GetAccessPermission(classID, Username, cstRightToViewDocument); //this.IMG1.Visible = this.line1.Visible; this.dgDocList.Visible = this.line1.Visible; // this.imgSubscribe.Visible = this.line1.Visible; this.lblSubscribe.Visible = this.line1.Visible; this.line2.Visible = pjt.GetAccessPermission(classID, Username, cstRightToApproveDocument); //this.IMG3.Visible = this.line2.Visible; this.dgAppDocList.Visible = this.line2.Visible; #endregion #region ����Ȩ��ȡ���ʼ����� /// <summary> /// ��ij�û���ȡ���ʼ����� /// </summary> dataTable = mail.GetClassMails(classID, Server.UrlDecode(Request.Cookies["UserName"].Value)); dgMailList.DataSource = dataTable.DefaultView; dgMailList.DataBind(); mail = null; #endregion #region ����Ȩ��ȡ���ĵ����� /// <summary> /// ��ij�û����ĵ�����ȡ�� /// </summary> if (pjt.GetAccessPermission(classID, Username, cstRightToViewDocument) || bSubscription) { dataTable = doc.GetClassDocs(classID); dgDocList.DataSource = dataTable.DefaultView; dgDocList.DataBind(); dataTable = null; } else { // IMG1.Visible = false; // IMG4.Visible = false; dgDocList.Visible = false; } #endregion #region ����Ȩ��ȡ��ij��Ŀ�������ĵ����� /// <summary> /// ��ij��Ŀ�������ĵ�����ȡ�� /// </summary> if (pjt.GetAccessPermission(classID, Username, cstRightToApproveDocument)) { dataTable = doc.GetApproveClassDocs(classID); dgAppDocList.DataSource = dataTable.DefaultView; dgAppDocList.DataBind(); dataTable = null; doc = null; } else { //IMG3.Visible = false; dgAppDocList.Visible = false; lblApp.Visible = false; } #endregion //} //finally //{ dataReader.Close(); } }
/// <summary> /// ɾ����Ŀ /// </summary> private void DeleteProject() { ProjectClass prj = new ProjectClass(); HttpCookie UserCookie = Request.Cookies["Username"]; String Username = UserCookie.Value.ToString(); try { prj.Delete(Int32.Parse(ClassID)); prj = null; Response.Write("<script language=javascript>alert('ɾ���ɹ�!');parent.location.reload();</script>"); } catch(Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } }
/// <summary> /// ������Ŀ /// </summary> private void SubscribeProject() { ProjectClass prj = new ProjectClass(); try { prj.Subscribe(Username,classID); prj = null; Response.Write("<script language=javascript>alert('���ijɹ�!');</script>"); } catch(Exception ex) { UDS.Components.Error.Log(ex.ToString()); Server.Transfer("../Error.aspx"); } }
private void sms_all(int ii) { string sql = "";//����ѡ��ij�ԱID���� bool sqlFlag = true; foreach(DataGridItem dgi in this.dgMemberList.Items) { CheckBox cb=(CheckBox)(dgi.Cells[0].Controls[1]); if (cb.Checked==true) { int i = dgi.ItemIndex; string id = dgMemberList.DataKeys[i].ToString(); if (sqlFlag) { sql+=""+id; sqlFlag=false; } else { sql+=" ,"; sql+=id; } } } SqlDataReader dr_this;//��ѡ����Ա UDS.Components.Staff sta=new UDS.Components.Staff(); dr_this=sta.GetStaffInfo(sql); SqlDataReader dr_allTeam;//������Ա Team steam=new Team(); dr_allTeam=steam.GetStaffInTeam(Convert.ToInt32(ClassID)); SqlDataReader dr_allTeamMaster;//�����鳤 ProjectClass prj=new ProjectClass(); dr_allTeamMaster=prj.GetLeader(Convert.ToInt32(ClassID)); SqlDataReader dataReader;//��Ŀ��Ϣ dataReader = prj.GetClassInfo(Convert.ToInt32(ClassID)); string Team_name="";//��Ŀ���� try { if (dataReader.Read()) { Team_name = dataReader[0].ToString() + ","; } dataReader.Close(); dataReader = null; string Staff_name = "";//��ѡ����Ա���� while (dr_this.Read()) { Staff_name += dr_this["RealName"].ToString() + ","; } dr_this.Close(); dr_this = null; string name_teamMaster = "";//�����鳤������ while (dr_allTeamMaster.Read()) { name_teamMaster += dr_allTeamMaster["RealName"].ToString() + ","; } dr_allTeamMaster.Close(); dr_allTeamMaster = null; SMS sm = new SMS(); //����������� while (dr_allTeam.Read())//iΪ0��ʾ������,iΪ1��ʾ������,iΪ2��ʾ��Ϊ�鳤 { if (ii == 0) sm.SendMsg(Username, dr_allTeam["Staff_name"].ToString(), Team_name + " ��Ŀ��Ա��:" + Staff_name + "�Ѿ����뱾��Ŀ,�ش�֪ͨ.", 1, DateTime.Now, "", 0, 0); else if (ii == 1) sm.SendMsg(Username, dr_allTeam["Staff_name"].ToString(), "Ա��:" + Staff_name + "�Ѿ�������Ŀ:" + Team_name + ",�ش�֪ͨ.", 1, DateTime.Now, "", 0, 0); else if (ii == 2) sm.SendMsg(Username, dr_allTeam["Staff_name"].ToString(), Team_name + " ��Ŀ��Ա��:" + Staff_name + "�Ѿ����" + name_teamMaster + ",��Ϊ��Ŀ�鳤,�ش�֪ͨ.", 1, DateTime.Now, "", 0, 0); } sm = null; dr_allTeam.Close(); dr_allTeam = null; } finally { dr_allTeam.Close(); dr_allTeamMaster.Close(); dr_this.Close(); dataReader.Close(); } }