private void GridBind(int type) { UDS.Components.MyLinkman linkman = new UDS.Components.MyLinkman(); SqlDataReader dr_linkman = linkman.GetMyLinkman(type, userid); DataTable dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); dt_linkman.TableName = "Linkman"; DataSet ds = new DataSet(); ds.Tables.Add(dt_linkman); switch (type) { case 1: dgrd_StaffLinkman.Visible = true; dgrd_ClientLinkman.Visible = false; dgrd_CustomLinkman.Visible = false; td_Staff.Attributes["background"] = "../../images/maillistbutton2.gif"; td_Client.Attributes["background"] = "../../images/maillistbutton1.gif"; td_Custom.Attributes["background"] = "../../images/maillistbutton1.gif"; dgrd_StaffLinkman.DataSource = dt_linkman.DefaultView; dgrd_StaffLinkman.DataKeyField = "Staff_ID"; dgrd_StaffLinkman.DataBind(); break; case 2: dgrd_StaffLinkman.Visible = false; dgrd_ClientLinkman.Visible = true; dgrd_CustomLinkman.Visible = false; td_Staff.Attributes["background"] = "../../images/maillistbutton1.gif"; td_Client.Attributes["background"] = "../../images/maillistbutton2.gif"; td_Custom.Attributes["background"] = "../../images/maillistbutton1.gif"; dgrd_ClientLinkman.DataSource = dt_linkman.DefaultView; dgrd_ClientLinkman.DataKeyField = "ID"; dgrd_ClientLinkman.DataBind(); break; case 3: dgrd_StaffLinkman.Visible = false; dgrd_ClientLinkman.Visible = false; dgrd_CustomLinkman.Visible = true; td_Staff.Attributes["background"] = "../../images/maillistbutton1.gif"; td_Client.Attributes["background"] = "../../images/maillistbutton1.gif"; td_Custom.Attributes["background"] = "../../images/maillistbutton2.gif"; dgrd_CustomLinkman.DataSource = dt_linkman.DefaultView; dgrd_CustomLinkman.DataKeyField = "ID"; dgrd_CustomLinkman.DataBind(); break; } }
private void GridBind(int type) { UDS.Components.MyLinkman linkman = new UDS.Components.MyLinkman(); SqlDataReader dr_linkman = linkman.GetMyLinkman(type,userid); DataTable dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); dt_linkman.TableName = "Linkman"; DataSet ds = new DataSet(); ds.Tables.Add(dt_linkman); switch(type) { case 1: dgrd_StaffLinkman.Visible = true; dgrd_ClientLinkman.Visible = false; dgrd_CustomLinkman.Visible = false; td_Staff.Attributes["background"]= "../../images/maillistbutton2.gif"; td_Client.Attributes["background"]= "../../images/maillistbutton1.gif"; td_Custom.Attributes["background"]= "../../images/maillistbutton1.gif"; dgrd_StaffLinkman.DataSource = dt_linkman.DefaultView; dgrd_StaffLinkman.DataKeyField = "Staff_ID"; dgrd_StaffLinkman.DataBind(); break; case 2: dgrd_StaffLinkman.Visible = false; dgrd_ClientLinkman.Visible = true; dgrd_CustomLinkman.Visible = false; td_Staff.Attributes["background"]= "../../images/maillistbutton1.gif"; td_Client.Attributes["background"]= "../../images/maillistbutton2.gif"; td_Custom.Attributes["background"]= "../../images/maillistbutton1.gif"; dgrd_ClientLinkman.DataSource = dt_linkman.DefaultView; dgrd_ClientLinkman.DataKeyField = "ID"; dgrd_ClientLinkman.DataBind(); break; case 3: dgrd_StaffLinkman.Visible = false; dgrd_ClientLinkman.Visible = false; dgrd_CustomLinkman.Visible = true; td_Staff.Attributes["background"]= "../../images/maillistbutton1.gif"; td_Client.Attributes["background"]= "../../images/maillistbutton1.gif"; td_Custom.Attributes["background"]= "../../images/maillistbutton2.gif"; dgrd_CustomLinkman.DataSource = dt_linkman.DefaultView; dgrd_CustomLinkman.DataKeyField = "ID"; dgrd_CustomLinkman.DataBind(); break; } }
private void btn_OK_Click(object sender, System.EventArgs e) { UDS.Components.MyLinkman linkman = new UDS.Components.MyLinkman(); SqlDataReader dr_linkman; DataTable dt_linkman = new DataTable(); string filter = ""; switch (ddl_SearchType.SelectedValue) { case "staff": dr_linkman = linkman.GetMyLinkman(1, Int32.Parse(Request.Cookies["UserID"].Value)); if (tbx_StaffName.Text.Trim() != "") { filter = (filter == "")?("RealName LIKE '*" + tbx_StaffName.Text.Trim() + "*'"):filter + " and RealName LIKE '*" + tbx_StaffName.Text.Trim() + "*'"; } if (tbx_StaffMobile.Text.Trim() != "") { filter = (filter == "")?("Mobile LIKE '*" + tbx_StaffMobile.Text.Trim() + "*'"):filter + " and Mobile LIKE '*" + tbx_StaffMobile.Text.Trim() + "*'"; } if (ddl_StaffGender.SelectedValue != "0") { if (ddl_StaffGender.SelectedValue == "male") { if (filter == "") { filter = "Sex=True"; } else { filter += " and Sex=True"; } } else { if (filter == "") { filter = "Sex=False"; } else { filter += " and Sex=False"; } } } if (tbx_StaffEmail.Text.Trim() != "") { filter = (filter == "")?("Email LIKE '*" + tbx_StaffEmail.Text.Trim() + "'"):filter + " and Email LIKE '*" + tbx_StaffEmail.Text.Trim() + "*'"; } if (ddl_StaffPosition.SelectedValue != "0") { filter = (filter == "")?("Position_ID=" + ddl_StaffPosition.SelectedValue):filter + " and Position_ID=" + ddl_StaffPosition.SelectedValue; } dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); try { dt_linkman.DefaultView.RowFilter = filter; dgrd_Staff.DataSource = dt_linkman.DefaultView; dgrd_Staff.DataBind(); } catch (Exception ex) { Response.Write(filter + " " + ex.Message); } dgrd_Staff.Visible = true; dgrd_Linkman.Visible = false; dgrd_Custom.Visible = false; break; case "linkman": dr_linkman = linkman.GetMyLinkman(2, Int32.Parse(Request.Cookies["UserID"].Value)); if (tbx_LinkmanName.Text.Trim() != "") { filter = (filter == "")?("Name LIKE '*" + tbx_LinkmanName.Text.Trim() + "*'"):filter + " and Name LIKE '*" + tbx_LinkmanName.Text.Trim() + "*'"; } if (tbx_Telephone.Text.Trim() != "") { filter = (filter == "")?("Telephone LIKE '*" + tbx_Telephone.Text.Trim() + "*'"):filter + " and Telephone LIKE '*" + tbx_Telephone.Text.Trim() + "*'"; } if (ddl_LinkmanGender.SelectedValue != "0") { if (ddl_LinkmanGender.SelectedValue == "male") { if (filter == "") { filter = "Gender=True"; } else { filter += " and Gender=True"; } } else { if (filter == "") { filter = "Gender=False"; } else { filter += " and Gender=False"; } } } if (tbx_LinkmanEmail.Text.Trim() != "") { filter = (filter == "")?("Email LIKE '*" + tbx_LinkmanEmail.Text.Trim() + "*'"):filter + " and Email LIKE '*" + tbx_LinkmanEmail.Text.Trim() + "*'"; } if (tbx_LinkmanUnit.Text.Trim() != "") { filter = (filter == "")?("UnitName LIKE '*" + tbx_LinkmanUnit.Text.Trim() + "*'"):filter + " AND UnitName LIKE '*" + tbx_LinkmanUnit.Text.Trim() + "*'"; } if (tbx_LinkmanPosition.Text.Trim() != "") { filter = (filter == "")?("Position LIKE '*" + tbx_LinkmanPosition.Text.Trim() + "*'"):filter + " AND Position LIKE '*" + tbx_LinkmanPosition.Text.Trim() + "*'"; } if (tbx_LinkmanMobile.Text.Trim() != "") { filter = (filter == "")?("Mobile LIKE '*" + tbx_LinkmanMobile.Text.Trim() + "*'"):filter + " AND Mobile LIKE '*" + tbx_LinkmanMobile.Text.Trim() + "*'"; } dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); try { dt_linkman.DefaultView.RowFilter = filter; dgrd_Linkman.DataSource = dt_linkman.DefaultView; dgrd_Linkman.DataBind(); } catch (Exception ex) { Response.Write(filter + " " + ex.Message); } dgrd_Staff.Visible = false; dgrd_Linkman.Visible = true; dgrd_Custom.Visible = false; break; case "custom": DataSet ds = new DataSet(); dr_linkman = linkman.GetMyLinkman(3, Int32.Parse(Request.Cookies["UserID"].Value)); if (tbx_CutomName.Text.Trim() != "") { filter = (filter == "")?("Name LIKE '*" + tbx_CutomName.Text.Trim() + "*'"):filter + " and Name LIKE '*" + tbx_CutomName.Text.Trim() + "*'"; } if (ddl_CustomGender.SelectedValue != "0") { if (ddl_CustomGender.SelectedValue == "male") { if (filter == "") { filter = "Gender=True"; } else { filter += " and Gender=True"; } } else { if (filter == "") { filter = "Gender=False"; } else { filter += " and Gender=False"; } } } if (tbx_CutomEmail.Text.Trim() != "") { filter = (filter == "")?("Email LIKE '*" + tbx_CutomEmail.Text.Trim() + "*'"):filter + " and Email LIKE '*" + tbx_CutomEmail.Text.Trim() + "*'"; } if (tbx_CutomMobile.Text.Trim() != "") { filter = (filter == "")?("Mobile LIKE '*" + tbx_CutomMobile.Text.Trim() + "*'"):filter + " AND Mobile LIKE '*" + tbx_CutomMobile.Text.Trim() + "*'"; } if (ddl_CustomCatalog.SelectedValue != "0") { SqlDataReader dr_linkmantype = linkman.GetLinkmanTypeRelation(); //DataTable dt_linkmantype = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkmantype); //得到满足分类的联系人id string ids = ""; while (dr_linkmantype.Read()) { if (Convert.ToInt32(dr_linkmantype["TypeID"]) == Int32.Parse(ddl_CustomCatalog.SelectedValue)) { ids += dr_linkmantype["CustomLinkmanID"].ToString() + ","; } } if (ids != "") { ids = ids.Substring(0, ids.Length - 1); } filter = (filter == "")?("ID IN (" + ids + ")"):(filter + " AND ID IN (" + ids + ")"); } dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); try { dt_linkman.DefaultView.RowFilter = filter; dgrd_Custom.DataSource = dt_linkman.DefaultView; dgrd_Custom.DataBind(); } catch (Exception ex) { Response.Write(filter + " " + ex.Message); } dgrd_Staff.Visible = false; dgrd_Linkman.Visible = false; dgrd_Custom.Visible = true; break; } }
private void btn_OK_Click(object sender, System.EventArgs e) { UDS.Components.MyLinkman linkman = new UDS.Components.MyLinkman(); SqlDataReader dr_linkman=null; DataTable dt_linkman = new DataTable(); string filter = ""; try { switch (ddl_SearchType.SelectedValue) { case "staff": dr_linkman = linkman.GetMyLinkman(1, Int32.Parse(Request.Cookies["UserID"].Value)); if (tbx_StaffName.Text.Trim() != "") { filter = (filter == "") ? ("RealName LIKE '*" + tbx_StaffName.Text.Trim() + "*'") : filter + " and RealName LIKE '*" + tbx_StaffName.Text.Trim() + "*'"; } if (tbx_StaffMobile.Text.Trim() != "") { filter = (filter == "") ? ("Mobile LIKE '*" + tbx_StaffMobile.Text.Trim() + "*'") : filter + " and Mobile LIKE '*" + tbx_StaffMobile.Text.Trim() + "*'"; } if (ddl_StaffGender.SelectedValue != "0") { if (ddl_StaffGender.SelectedValue == "male") { if (filter == "") filter = "Sex=True"; else filter += " and Sex=True"; } else { if (filter == "") filter = "Sex=False"; else filter += " and Sex=False"; } } if (tbx_StaffEmail.Text.Trim() != "") { filter = (filter == "") ? ("Email LIKE '*" + tbx_StaffEmail.Text.Trim() + "'") : filter + " and Email LIKE '*" + tbx_StaffEmail.Text.Trim() + "*'"; } if (ddl_StaffPosition.SelectedValue != "0") { filter = (filter == "") ? ("Position_ID=" + ddl_StaffPosition.SelectedValue) : filter + " and Position_ID=" + ddl_StaffPosition.SelectedValue; } dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); try { dt_linkman.DefaultView.RowFilter = filter; dgrd_Staff.DataSource = dt_linkman.DefaultView; dgrd_Staff.DataBind(); } catch (Exception ex) { Response.Write(filter + " " + ex.Message); } dgrd_Staff.Visible = true; dgrd_Linkman.Visible = false; dgrd_Custom.Visible = false; break; case "linkman": dr_linkman = linkman.GetMyLinkman(2, Int32.Parse(Request.Cookies["UserID"].Value)); if (tbx_LinkmanName.Text.Trim() != "") { filter = (filter == "") ? ("Name LIKE '*" + tbx_LinkmanName.Text.Trim() + "*'") : filter + " and Name LIKE '*" + tbx_LinkmanName.Text.Trim() + "*'"; } if (tbx_Telephone.Text.Trim() != "") { filter = (filter == "") ? ("Telephone LIKE '*" + tbx_Telephone.Text.Trim() + "*'") : filter + " and Telephone LIKE '*" + tbx_Telephone.Text.Trim() + "*'"; } if (ddl_LinkmanGender.SelectedValue != "0") { if (ddl_LinkmanGender.SelectedValue == "male") { if (filter == "") filter = "Gender=True"; else filter += " and Gender=True"; } else { if (filter == "") filter = "Gender=False"; else filter += " and Gender=False"; } } if (tbx_LinkmanEmail.Text.Trim() != "") { filter = (filter == "") ? ("Email LIKE '*" + tbx_LinkmanEmail.Text.Trim() + "*'") : filter + " and Email LIKE '*" + tbx_LinkmanEmail.Text.Trim() + "*'"; } if (tbx_LinkmanUnit.Text.Trim() != "") { filter = (filter == "") ? ("UnitName LIKE '*" + tbx_LinkmanUnit.Text.Trim() + "*'") : filter + " AND UnitName LIKE '*" + tbx_LinkmanUnit.Text.Trim() + "*'"; } if (tbx_LinkmanPosition.Text.Trim() != "") { filter = (filter == "") ? ("Position LIKE '*" + tbx_LinkmanPosition.Text.Trim() + "*'") : filter + " AND Position LIKE '*" + tbx_LinkmanPosition.Text.Trim() + "*'"; } if (tbx_LinkmanMobile.Text.Trim() != "") { filter = (filter == "") ? ("Mobile LIKE '*" + tbx_LinkmanMobile.Text.Trim() + "*'") : filter + " AND Mobile LIKE '*" + tbx_LinkmanMobile.Text.Trim() + "*'"; } dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); try { dt_linkman.DefaultView.RowFilter = filter; dgrd_Linkman.DataSource = dt_linkman.DefaultView; dgrd_Linkman.DataBind(); } catch (Exception ex) { Response.Write(filter + " " + ex.Message); } dgrd_Staff.Visible = false; dgrd_Linkman.Visible = true; dgrd_Custom.Visible = false; break; case "custom": DataSet ds = new DataSet(); dr_linkman = linkman.GetMyLinkman(3, Int32.Parse(Request.Cookies["UserID"].Value)); if (tbx_CutomName.Text.Trim() != "") { filter = (filter == "") ? ("Name LIKE '*" + tbx_CutomName.Text.Trim() + "*'") : filter + " and Name LIKE '*" + tbx_CutomName.Text.Trim() + "*'"; } if (ddl_CustomGender.SelectedValue != "0") { if (ddl_CustomGender.SelectedValue == "male") { if (filter == "") filter = "Gender=True"; else filter += " and Gender=True"; } else { if (filter == "") filter = "Gender=False"; else filter += " and Gender=False"; } } if (tbx_CutomEmail.Text.Trim() != "") { filter = (filter == "") ? ("Email LIKE '*" + tbx_CutomEmail.Text.Trim() + "*'") : filter + " and Email LIKE '*" + tbx_CutomEmail.Text.Trim() + "*'"; } if (tbx_CutomMobile.Text.Trim() != "") { filter = (filter == "") ? ("Mobile LIKE '*" + tbx_CutomMobile.Text.Trim() + "*'") : filter + " AND Mobile LIKE '*" + tbx_CutomMobile.Text.Trim() + "*'"; } if (ddl_CustomCatalog.SelectedValue != "0") { SqlDataReader dr_linkmantype = linkman.GetLinkmanTypeRelation(); //DataTable dt_linkmantype = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkmantype); //�õ�����������ϵ��id string ids = ""; while (dr_linkmantype.Read()) { if (Convert.ToInt32(dr_linkmantype["TypeID"]) == Int32.Parse(ddl_CustomCatalog.SelectedValue)) { ids += dr_linkmantype["CustomLinkmanID"].ToString() + ","; } } if (ids != "") ids = ids.Substring(0, ids.Length - 1); filter = (filter == "") ? ("ID IN (" + ids + ")") : (filter + " AND ID IN (" + ids + ")"); } dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); try { dt_linkman.DefaultView.RowFilter = filter; dgrd_Custom.DataSource = dt_linkman.DefaultView; dgrd_Custom.DataBind(); } catch (Exception ex) { Response.Write(filter + " " + ex.Message); } dgrd_Staff.Visible = false; dgrd_Linkman.Visible = false; dgrd_Custom.Visible = true; break; } } finally { dr_linkman.Close(); dr_linkman.Dispose(); } }