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