/// <summary> /// ��ij�û����ʼ�ȡ������DataGrid /// </summary> protected void BindGrid() { Team team = new Team(); DataTable datatable = new DataTable(); switch (DisplayType) { case "0": datatable = Tools.ConvertDataReaderToDataTable(team.GetStaffInTeam(Int32.Parse(ClassID))); this.btnAdd.Visible = false; this.cmdDelete.Visible = true; this.btnLeader.Visible = true; break; case "1": datatable = Tools.ConvertDataReaderToDataTable(team.GetStaffNotInTeam(Int32.Parse(ClassID))); this.btnAdd.Visible = true; this.cmdDelete.Visible = false; this.btnLeader.Visible = false; this.dgMemberList.Columns.Remove(this.dgMemberList .Columns[3]); break; case "2": datatable = Tools.ConvertDataReaderToDataTable(team.GetStaffSubscriptionTeam(Int32.Parse(ClassID))); this.btnAdd.Visible = false; this.cmdDelete.Visible = false; this.btnLeader.Visible = false; this.dgMemberList.Columns.Remove(this.dgMemberList .Columns[3]); break; default: break; } if (ViewState["sortfield"] != null) datatable.DefaultView.Sort = ViewState["sortfield"] + " " + ViewState["sortdirect"]; dgMemberList.DataSource = datatable.DefaultView; dgMemberList.DataBind(); if (datatable.Rows.Count !=0) { this.cmdDelete.Attributes ["onclick"]="javascript:return confirm('��ȷ��Ҫѡ�е���Ա��������?');"; this.btnLeader.Attributes ["onclick"]="javascript:return confirm('��ȷ��Ҫѡ�е���Ա����Ϊ�鳤��?');"; this.btnAdd.Attributes ["onclick"] ="javascript:return confirm('��ȷ��Ҫ����ó�Ա��?');"; } team = null; datatable = null; }
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(); } }
private void cmdDelete_Click(object sender, System.EventArgs e) { Team team = new Team(); bool sqlFlag = true; string sql = ""; 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; } } } //ѡ��Ϊ�� if( sql==String.Empty) { Response.Write("<script language=javascript>alert('��ѡ����Ա!');window.location='MemberListView.aspx?TeamID="+ClassID+"';</script>"); } else { if(this.cbRemind.Checked==true) sms_all(0); if(team.DeleteStaffFromTeam(sql,Int32.Parse(ClassID))) { Response.Write("<script language=javascript>alert('��Ա����ɹ�!');window.location='MemberListView.aspx?TeamID="+ClassID+"';</script>"); } else { Server.Transfer("../Error.aspx"); } } team=null; }