/// <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;
}
