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(); }