private void sms_all(int ii)
{
string sql = ""; //所被选择的成员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 = ""; //项目名字
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;
}
/// <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.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>
/// 将某用户的取出邮件数据
/// </summary>
dataTable = mail.GetClassMails(classID, UserCookie.Value.ToString());
dgMailList.DataSource = dataTable.DefaultView;
dgMailList.DataBind();
mail = null;
#endregion
#region 根据权限取出文档数据
/// <summary>
/// 将某用户的文档数据取出
/// </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 根据权限取出某项目的审批文档数据
/// <summary>
/// 将某项目的审批文档数据取出
/// </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
}
/// <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;
#endregion
#region 注释
/*
#region 根据权限显示相关功能标题
* // 设置缺省值
* int cstRightToApproveDocument = 2;
* int cstRightToViewDocument = 10;
* int cstRightToBuildNode = 5;
* int cstDisplayMember = 6;
* int cstTeamRight = 7;
* int cstComposeMail = 11;
* int cstDeliveryDoc = 11;
* int cstProjectMove = 5;
* 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;
*
*
#endregion
*
#region 根据权限取出邮件数据
* /// <summary>
* /// 将某用户的取出邮件数据
* /// </summary>
*
* dataTable = mail.GetClassMails(classID,UserCookie.Value.ToString());
* dgMailList.DataSource = dataTable.DefaultView;
* dgMailList.DataBind();
*
* mail = null;
*
#endregion
*
#region 根据权限取出文档数据
* /// <summary>
* /// 将某用户的文档数据取出
* /// </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 根据权限取出某项目的审批文档数据
* /// <summary>
* /// 将某项目的审批文档数据取出
* /// </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
*/
#endregion
}
