private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!Page.IsPostBack)
{
string staffids = "";
boardid = (Request.QueryString["BoardID"] == null)?0:Convert.ToInt32(Request.QueryString["BoardID"]);
classid = (Request.QueryString["classID"] == null)?0:Int32.Parse(Request.QueryString["classID"]);
ViewState["boardid"] = boardid;
ViewState["classid"] = classid;
UDS.Components.Staff staff = new UDS.Components.Staff();
BBSClass bbs = new BBSClass();
SqlDataReader dr = null;
SqlDataReader dr1 = null;
DataTable dt = new DataTable();
try
{
dr = bbs.GetBoardMember();
dt = Tools.ConvertDataReaderToDataTable(dr);
dt.DefaultView.RowFilter = "board_id=" + boardid;
lbBoardMemberList.DataSource = dt.DefaultView;
lbBoardMemberList.DataValueField = "staff_id";
lbBoardMemberList.DataTextField = "realname";
lbBoardMemberList.DataBind();
for (int i = 0; i < lbBoardMemberList.Items.Count; i++)
{
staffids += lbBoardMemberList.Items[i].Value + ",";
}
if (staffids.Length != 0)
{
staffids = staffids.Substring(0, staffids.Length - 1);
}
dr1 = staff.GetRemainStaff(staffids);
lbRemainStaffsList.DataSource = dr1;
lbRemainStaffsList.DataValueField = "staff_id";
lbRemainStaffsList.DataTextField = "realname";
lbRemainStaffsList.DataBind();
dr1.Close();
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
}
else
{
classid = Int32.Parse(ViewState["classid"].ToString());
boardid = Int32.Parse(ViewState["boardid"].ToString());
}
HyperLink1.DataBind();
}
private void BindData()
{
string staffids = "";
UDS.Components.Staff staff = new UDS.Components.Staff();
//绑定该客户的联系人
UDS.Components.Database db = new UDS.Components.Database();
SqlDataReader dr_ClientLinkman = null;
SqlParameter[] prams =
{
db.MakeInParam("@clientid", SqlDbType.Int, 4, clientid)
};
db.RunProc("sp_CM_GetAllLinkmanFromClient", prams, out dr_ClientLinkman);
lbx_ClientLinkman.DataSource = dr_ClientLinkman;
lbx_ClientLinkman.DataTextField = "Name";
lbx_ClientLinkman.DataValueField = "id";
lbx_ClientLinkman.DataBind();
dr_ClientLinkman.Close();
//绑定协同人员候选列表
SqlDataReader dr_staff = null;
for (int i = 0; i < lbx_Cooperater.Items.Count; i++)
{
staffids += lbx_Cooperater.Items[i].Value + ",";
}
if (staffids.Length != 0)
{
staffids = staffids.Substring(0, staffids.Length - 1);
}
dr_staff = staff.GetRemainStaff(staffids);
lbx_Staff.DataSource = dr_staff;
lbx_Staff.DataTextField = "realname";
lbx_Staff.DataValueField = "staff_id";
lbx_Staff.DataBind();
dr_staff.Close();
ControlClientContactHistory1.MyClientID = clientid;
ControlClientContactHistory1.BindData();
}
private void BindData()
{
string staffids = "";
UDS.Components.Staff staff = new UDS.Components.Staff();
//�ÿͻ�����ϵ��
UDS.Components.Database db = new UDS.Components.Database();
SqlDataReader dr_ClientLinkman = null;
SqlParameter[] prams = {
db.MakeInParam("@clientid",SqlDbType.Int,4,clientid)
};
db.RunProc("sp_CM_GetAllLinkmanFromClient",prams,out dr_ClientLinkman);
lbx_ClientLinkman.DataSource = dr_ClientLinkman;
lbx_ClientLinkman.DataTextField = "Name";
lbx_ClientLinkman.DataValueField = "id";
lbx_ClientLinkman.DataBind();
dr_ClientLinkman.Close();
//��Эͬ��Ա��ѡ�б�
SqlDataReader dr_staff = null;
for(int i=0;i<lbx_Cooperater.Items.Count;i++)
{
staffids += lbx_Cooperater.Items[i].Value + ",";
}
if(staffids.Length!=0)
staffids = staffids.Substring(0,staffids.Length-1);
dr_staff = staff.GetRemainStaff(staffids);
lbx_Staff.DataSource = dr_staff;
lbx_Staff.DataTextField = "realname";
lbx_Staff.DataValueField = "staff_id";
lbx_Staff.DataBind();
dr_staff.Close();
ControlClientContactHistory1.MyClientID = clientid;
ControlClientContactHistory1.BindData();
}
private void Page_Load(object sender, System.EventArgs e)
{
// �ڴ˴������û������Գ�ʼ��ҳ��
if(!Page.IsPostBack)
{
string staffids = "";
boardid = (Request.QueryString["BoardID"]==null)?0:Convert.ToInt32(Request.QueryString["BoardID"]);
classid = (Request.QueryString["classID"]==null)?0:Int32.Parse(Request.QueryString["classID"]);
ViewState["boardid"] = boardid;
ViewState["classid"] = classid;
UDS.Components.Staff staff = new UDS.Components.Staff();
BBSClass bbs = new BBSClass();
SqlDataReader dr = null;
SqlDataReader dr1 = null;
DataTable dt = new DataTable();
try
{
dr = bbs.GetBoardMember();
dt = Tools.ConvertDataReaderToDataTable(dr);
dt.DefaultView.RowFilter = "board_id=" + boardid;
lbBoardMemberList.DataSource = dt.DefaultView;
lbBoardMemberList.DataValueField = "staff_id";
lbBoardMemberList.DataTextField = "realname";
lbBoardMemberList.DataBind();
for (int i = 0; i < lbBoardMemberList.Items.Count; i++)
{
staffids += lbBoardMemberList.Items[i].Value + ",";
}
if (staffids.Length != 0)
staffids = staffids.Substring(0, staffids.Length - 1);
dr1 = staff.GetRemainStaff(staffids);
lbRemainStaffsList.DataSource = dr1;
lbRemainStaffsList.DataValueField = "staff_id";
lbRemainStaffsList.DataTextField = "realname";
lbRemainStaffsList.DataBind();
dr1.Close();
}
catch (Exception ex)
{
UDS.Components.Error.Log(ex.ToString());
Server.Transfer("../../Error.aspx");
}
finally
{
if (dr1 != null)
{ dr1.Close(); }
if (dr != null)
{
dr.Close();
}
}
}
else
{
classid = Int32.Parse(ViewState["classid"].ToString());
boardid = Int32.Parse(ViewState["boardid"].ToString());
}
HyperLink1.DataBind();
}
