private void btn_OK_Click(object sender, System.EventArgs e) { UDS.Components.MyLinkman mylinkman = new UDS.Components.MyLinkman(); UDS.Components.CustomLinkman clinkman = new UDS.Components.CustomLinkman(); clinkman.Name = tbx_Name.Text; clinkman.Age = tbx_Age.Text; clinkman.Gender = (ddl_Gender.Items[ddl_Gender.SelectedIndex].Value == "1")?true:false; clinkman.UnitAddress = tbx_UnitAddress.Text; clinkman.UnitTelephone = tbx_UnitTelephone.Text; clinkman.UnitZip = tbx_UnitZip.Text; clinkman.FamilyAddress = tbx_FamilyAddress.Text; clinkman.FamilyTelephone = tbx_FamilyTelephone.Text; clinkman.FamilyZip = tbx_FamilyZip.Text; clinkman.Email = tbx_Email.Text; clinkman.Mobile = tbx_Mobile.Text; clinkman.Memo = tbx_Memo.Text; for (int i = 0; i < dlt_Type.Items.Count; i++) { if (((CheckBox)dlt_Type.Items[i].Controls[1]).Checked == true) { clinkman.Type += dlt_Type.DataKeys[i].ToString() + ","; } } mylinkman.AddCustomLinkman(clinkman, userid); Response.Write("<script>location.href='ListView.aspx?type=3'</script>"); }
private void BindTypeList() { UDS.Components.MyLinkman mylinkman = new UDS.Components.MyLinkman(); dlt_Type.DataSource = mylinkman.GetCustomLinkmanType(); dlt_Type.DataKeyField = "ID"; dlt_Type.DataBind(); }
private void GridCustomLinkmanByType(int type) { UDS.Components.MyLinkman linkman = new UDS.Components.MyLinkman(); SqlDataReader dr_linkman = linkman.GetCustomLinkmanByType(type, userid); DataTable dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); dgrd_CustomLinkman.DataSource = dt_linkman.DefaultView; dgrd_CustomLinkman.DataBind(); }
//bound to customlinkmantype private void BindTypeList() { UDS.Components.MyLinkman mylinkman = new UDS.Components.MyLinkman(); ddl_CustomLinkmanType.DataSource = mylinkman.GetCustomLinkmanType(); ddl_CustomLinkmanType.DataValueField = "ID"; ddl_CustomLinkmanType.DataTextField = "type"; ddl_CustomLinkmanType.DataBind(); ddl_CustomLinkmanType.Items.Insert(0, new ListItem("全部", "all")); }
//bound to customlinkmantype private void BindTypeList() { UDS.Components.MyLinkman mylinkman = new UDS.Components.MyLinkman(); ddl_CustomLinkmanType.DataSource = mylinkman.GetCustomLinkmanType(); ddl_CustomLinkmanType.DataValueField = "ID"; ddl_CustomLinkmanType.DataTextField = "type"; ddl_CustomLinkmanType.DataBind(); ddl_CustomLinkmanType.Items.Insert(0,new ListItem("ȫ��","all")); }
private void BindCutomTypeList() { UDS.Components.MyLinkman mylinkman = new UDS.Components.MyLinkman(); ddl_CustomCatalog.DataSource = mylinkman.GetCustomLinkmanType(); ddl_CustomCatalog.DataTextField = "Type"; ddl_CustomCatalog.DataValueField = "ID"; ddl_CustomCatalog.DataBind(); ddl_CustomCatalog.Items.Insert(0, new ListItem("无限制", "0")); }
private void BindCutomTypeList() { UDS.Components.MyLinkman mylinkman = new UDS.Components.MyLinkman(); ddl_CustomCatalog.DataSource = mylinkman.GetCustomLinkmanType(); ddl_CustomCatalog.DataTextField = "Type"; ddl_CustomCatalog.DataValueField = "ID"; ddl_CustomCatalog.DataBind(); ddl_CustomCatalog.Items.Insert(0,new ListItem("������","0")); }
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 BindData() { UDS.Components.MyLinkman mlinkman = new UDS.Components.MyLinkman(); SqlDataReader dr_mlinkman = mlinkman.GetCustomLinkman(id); BindTypeList(); try { while (dr_mlinkman.Read()) { tbx_Name.Text = dr_mlinkman["Name"].ToString(); tbx_Age.Text = dr_mlinkman["Age"].ToString(); tbx_UnitAddress.Text = dr_mlinkman["UnitAddress"].ToString(); tbx_UnitTelephone.Text = dr_mlinkman["UnitTelephone"].ToString(); tbx_UnitZip.Text = dr_mlinkman["UnitZip"].ToString(); tbx_FamilyAddress.Text = dr_mlinkman["FamilyAddress"].ToString(); tbx_FamilyTelephone.Text = dr_mlinkman["FamilyTelephone"].ToString(); tbx_FamilyZip.Text = dr_mlinkman["FamilyZip"].ToString(); tbx_Mobile.Text = dr_mlinkman["Mobile"].ToString(); tbx_Email.Text = dr_mlinkman["Email"].ToString(); tbx_Memo.Text = dr_mlinkman["Memo"].ToString(); if (Convert.ToBoolean(dr_mlinkman["Gender"]) == true) { ddl_Gender.SelectedIndex = 0; } else { ddl_Gender.SelectedIndex = 1; } SqlDataReader dr_type = mlinkman.GetCustomLinkmanType(id); try { while (dr_type.Read()) { foreach (DataListItem dli in dlt_Type.Items) { if (((CheckBox)dli.FindControl("Checkbox1")).Text == dr_type["Type"].ToString()) ((CheckBox)dli.FindControl("Checkbox1")).Checked = true; } } } finally { dr_type.Close(); } } } finally { dr_mlinkman.Close(); } }
private void btn_AddList_Click(object sender, System.EventArgs e) { string selectedstring = ""; int type = 0; //取得选中的id值 if (dgrd_List.Visible == true) { type = 1; foreach (DataGridItem dgi in dgrd_List.Items) //找到checkbox control { for (int i = 0; i < dgi.Cells[0].Controls.Count; i++) { if ((dgi.Cells[0].Controls[i].GetType().ToString() == "System.Web.UI.WebControls.CheckBox") && ((CheckBox)dgi.Cells[0].Controls[i]).Checked == true) { selectedstring += dgrd_List.DataKeys[dgi.ItemIndex] + ","; } } } } else if (dgrd_Linkman.Visible == true) { type = 2; foreach (DataGridItem dgi in dgrd_Linkman.Items) //找到checkbox control { for (int i = 0; i < dgi.Cells[0].Controls.Count; i++) { if ((dgi.Cells[0].Controls[i].GetType().ToString() == "System.Web.UI.WebControls.CheckBox") && ((CheckBox)dgi.Cells[0].Controls[i]).Checked == true) { selectedstring += dgrd_Linkman.DataKeys[dgi.ItemIndex] + ","; } } } } if (selectedstring.IndexOf(",") != -1) { selectedstring = selectedstring.Substring(0, selectedstring.Length - 1); string[] arrids = selectedstring.Split(','); for (int i = 0; i < arrids.Length; i++) { UDS.Components.MyLinkman mlinkman = new UDS.Components.MyLinkman(); mlinkman.AddLinkmanToList(type, Int32.Parse(arrids[i]), userid); } } Response.Write("<script>location.href='ListView.aspx?type=" + type + "';</script>"); }
private void dgrd_Linkman_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { UDS.Components.MyLinkman mlinkman = new UDS.Components.MyLinkman(); if (e.Item.ItemIndex != -1) { if (mlinkman.HaveInList(2, userid, Int32.Parse(((DataGrid)sender).DataKeys[e.Item.ItemIndex].ToString()))) { for (int i = 0; i < e.Item.Cells[0].Controls.Count; i++) { if (e.Item.Cells[0].Controls[i].GetType().ToString() == "System.Web.UI.WebControls.CheckBox") { ((CheckBox)(e.Item.Cells[0].Controls[i])).Enabled = false; } } } } }
private void BindData() { UDS.Components.MyLinkman mlinkman = new UDS.Components.MyLinkman(); SqlDataReader dr_mlinkman = mlinkman.GetCustomLinkman(id); BindTypeList(); while (dr_mlinkman.Read()) { tbx_Name.Text = dr_mlinkman["Name"].ToString(); tbx_Age.Text = dr_mlinkman["Age"].ToString(); tbx_UnitAddress.Text = dr_mlinkman["UnitAddress"].ToString(); tbx_UnitTelephone.Text = dr_mlinkman["UnitTelephone"].ToString(); tbx_UnitZip.Text = dr_mlinkman["UnitZip"].ToString(); tbx_FamilyAddress.Text = dr_mlinkman["FamilyAddress"].ToString(); tbx_FamilyTelephone.Text = dr_mlinkman["FamilyTelephone"].ToString(); tbx_FamilyZip.Text = dr_mlinkman["FamilyZip"].ToString(); tbx_Mobile.Text = dr_mlinkman["Mobile"].ToString(); tbx_Email.Text = dr_mlinkman["Email"].ToString(); tbx_Memo.Text = dr_mlinkman["Memo"].ToString(); if (Convert.ToBoolean(dr_mlinkman["Gender"]) == true) { ddl_Gender.SelectedIndex = 0; } else { ddl_Gender.SelectedIndex = 1; } SqlDataReader dr_type = mlinkman.GetCustomLinkmanType(id); while (dr_type.Read()) { foreach (DataListItem dli in dlt_Type.Items) { if (((CheckBox)dli.FindControl("Checkbox1")).Text == dr_type["Type"].ToString()) { ((CheckBox)dli.FindControl("Checkbox1")).Checked = true; } } } dr_type.Close(); } dr_mlinkman.Close(); }
private void btn_OK_Click(object sender, System.EventArgs e) { UDS.Components.MyLinkman mlinkman = new UDS.Components.MyLinkman(); UDS.Components.CustomLinkman clinkman = new UDS.Components.CustomLinkman(); clinkman.Name = tbx_Name.Text; clinkman.Age = tbx_Age.Text; clinkman.Gender = (ddl_Gender.Items[ddl_Gender.SelectedIndex].Value == "1")?true:false; clinkman.UnitAddress = tbx_UnitAddress.Text; clinkman.UnitTelephone = tbx_UnitTelephone.Text; clinkman.UnitZip = tbx_UnitZip.Text; clinkman.FamilyAddress = tbx_FamilyAddress.Text; clinkman.FamilyTelephone = tbx_FamilyTelephone.Text; clinkman.FamilyZip = tbx_FamilyZip.Text; clinkman.Email = tbx_Email.Text; clinkman.Mobile = tbx_Mobile.Text; clinkman.Memo = tbx_Memo.Text; clinkman.ID = id; for (int i = 0; i < dlt_Type.Items.Count; i++) { if (((CheckBox)dlt_Type.Items[i].Controls[1]).Checked == true) { clinkman.Type += dlt_Type.DataKeys[i].ToString() + ","; } } mlinkman.UpdateCustomLinkman(clinkman); mlinkman.UpdateCustomLinkmanType(clinkman); BindData(); if (id == 0) { Response.Write("<script>alert('添加成功!');</script>"); } else { Response.Write("<script>alert('修改成功!');</script>"); } }
private void btn_AddList_Click(object sender, System.EventArgs e) { string selectedstring = ""; int type = 0; //ȡ��ѡ�е�idֵ if(dgrd_List.Visible==true) { type = 1; foreach(DataGridItem dgi in dgrd_List.Items)//�ҵ�checkbox control { for(int i=0;i<dgi.Cells[0].Controls.Count;i++) { if((dgi.Cells[0].Controls[i].GetType().ToString()=="System.Web.UI.WebControls.CheckBox")&&((CheckBox)dgi.Cells[0].Controls[i]).Checked==true) { selectedstring += dgrd_List.DataKeys[dgi.ItemIndex] + ","; } } } } else if(dgrd_Linkman.Visible==true) { type = 2; foreach(DataGridItem dgi in dgrd_Linkman.Items)//�ҵ�checkbox control { for(int i=0;i<dgi.Cells[0].Controls.Count;i++) { if((dgi.Cells[0].Controls[i].GetType().ToString()=="System.Web.UI.WebControls.CheckBox")&&((CheckBox)dgi.Cells[0].Controls[i]).Checked==true) { selectedstring += dgrd_Linkman.DataKeys[dgi.ItemIndex] + ","; } } } } if(selectedstring.IndexOf(",")!=-1) { selectedstring = selectedstring.Substring(0,selectedstring.Length-1); string[] arrids = selectedstring.Split(','); for(int i=0;i<arrids.Length;i++) { UDS.Components.MyLinkman mlinkman = new UDS.Components.MyLinkman(); mlinkman.AddLinkmanToList(type,Int32.Parse(arrids[i]),userid); } } Response.Write("<script>location.href='ListView.aspx?type="+type+"';</script>"); }
private void btn_Del_Click(object sender, System.EventArgs e) { string selectedstring = ""; int type = 0; UDS.Components.MyLinkman mlinkman = new UDS.Components.MyLinkman(); if(dgrd_StaffLinkman.Visible==true) { type = 1; //�õ�ѡ�е�checkbox��id foreach(DataGridItem dgi in dgrd_StaffLinkman.Items)//�ҵ�checkbox control { for(int i=0;i<dgi.Cells[0].Controls.Count;i++) { if((dgi.Cells[0].Controls[i].GetType().ToString()=="System.Web.UI.WebControls.CheckBox")&&((CheckBox)dgi.Cells[0].Controls[i]).Checked==true) { selectedstring += dgrd_StaffLinkman.DataKeys[dgi.ItemIndex] + ","; } } } } else if(dgrd_ClientLinkman.Visible==true) { type = 2; foreach(DataGridItem dgi in dgrd_ClientLinkman.Items)//�ҵ�checkbox control { for(int i=0;i<dgi.Cells[0].Controls.Count;i++) { if((dgi.Cells[0].Controls[i].GetType().ToString()=="System.Web.UI.WebControls.CheckBox")&&((CheckBox)dgi.Cells[0].Controls[i]).Checked==true) { selectedstring += dgrd_ClientLinkman.DataKeys[dgi.ItemIndex] + ","; } } } } else if(dgrd_CustomLinkman.Visible==true) { type = 3; foreach(DataGridItem dgi in dgrd_CustomLinkman.Items)//�ҵ�checkbox control { for(int i=0;i<dgi.Cells[0].Controls.Count;i++) { if((dgi.Cells[0].Controls[i].GetType().ToString()=="System.Web.UI.WebControls.CheckBox")&&((CheckBox)dgi.Cells[0].Controls[i]).Checked==true) { selectedstring += dgrd_CustomLinkman.DataKeys[dgi.ItemIndex] + ","; } } } } if(selectedstring.IndexOf(",")!=-1) { selectedstring = selectedstring.Substring(0,selectedstring.Length-1); string[] arrselected = selectedstring.Split(','); for(int i=0;i<arrselected.Length;i++) { if(arrselected[i].Trim()!="") { mlinkman.DelLinkmanFromList(type,Int32.Parse(arrselected[i])); } } GridBind(type); } }
private void btn_OK_Click(object sender, System.EventArgs e) { UDS.Components.MyLinkman mylinkman = new UDS.Components.MyLinkman(); UDS.Components.CustomLinkman clinkman = new UDS.Components.CustomLinkman(); clinkman.Name = tbx_Name.Text; clinkman.Age = tbx_Age.Text; clinkman.Gender = (ddl_Gender.Items[ddl_Gender.SelectedIndex].Value=="1")?true:false; clinkman.UnitAddress = tbx_UnitAddress.Text; clinkman.UnitTelephone = tbx_UnitTelephone.Text; clinkman.UnitZip = tbx_UnitZip.Text; clinkman.FamilyAddress = tbx_FamilyAddress.Text; clinkman.FamilyTelephone = tbx_FamilyTelephone.Text; clinkman.FamilyZip = tbx_FamilyZip.Text; clinkman.Email = tbx_Email.Text; clinkman.Mobile = tbx_Mobile.Text; clinkman.Memo = tbx_Memo.Text; for(int i = 0;i<dlt_Type.Items.Count;i++) { if(((CheckBox)dlt_Type.Items[i].Controls[1]).Checked==true) { clinkman.Type += dlt_Type.DataKeys[i].ToString() + ","; } } mylinkman.AddCustomLinkman(clinkman,userid); Response.Write("<script>location.href='ListView.aspx?type=3'</script>"); }
private void GridCustomLinkmanByType(int type) { UDS.Components.MyLinkman linkman = new UDS.Components.MyLinkman(); SqlDataReader dr_linkman = linkman.GetCustomLinkmanByType(type,userid); DataTable dt_linkman = UDS.Components.Tools.ConvertDataReaderToDataTable(dr_linkman); dgrd_CustomLinkman.DataSource = dt_linkman.DefaultView; dgrd_CustomLinkman.DataBind(); }
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_Del_Click(object sender, System.EventArgs e) { string selectedstring = ""; int type = 0; UDS.Components.MyLinkman mlinkman = new UDS.Components.MyLinkman(); if (dgrd_StaffLinkman.Visible == true) { type = 1; //得到选中的checkbox的id foreach (DataGridItem dgi in dgrd_StaffLinkman.Items) //找到checkbox control { for (int i = 0; i < dgi.Cells[0].Controls.Count; i++) { if ((dgi.Cells[0].Controls[i].GetType().ToString() == "System.Web.UI.WebControls.CheckBox") && ((CheckBox)dgi.Cells[0].Controls[i]).Checked == true) { selectedstring += dgrd_StaffLinkman.DataKeys[dgi.ItemIndex] + ","; } } } } else if (dgrd_ClientLinkman.Visible == true) { type = 2; foreach (DataGridItem dgi in dgrd_ClientLinkman.Items) //找到checkbox control { for (int i = 0; i < dgi.Cells[0].Controls.Count; i++) { if ((dgi.Cells[0].Controls[i].GetType().ToString() == "System.Web.UI.WebControls.CheckBox") && ((CheckBox)dgi.Cells[0].Controls[i]).Checked == true) { selectedstring += dgrd_ClientLinkman.DataKeys[dgi.ItemIndex] + ","; } } } } else if (dgrd_CustomLinkman.Visible == true) { type = 3; foreach (DataGridItem dgi in dgrd_CustomLinkman.Items) //找到checkbox control { for (int i = 0; i < dgi.Cells[0].Controls.Count; i++) { if ((dgi.Cells[0].Controls[i].GetType().ToString() == "System.Web.UI.WebControls.CheckBox") && ((CheckBox)dgi.Cells[0].Controls[i]).Checked == true) { selectedstring += dgrd_CustomLinkman.DataKeys[dgi.ItemIndex] + ","; } } } } if (selectedstring.IndexOf(",") != -1) { selectedstring = selectedstring.Substring(0, selectedstring.Length - 1); string[] arrselected = selectedstring.Split(','); for (int i = 0; i < arrselected.Length; i++) { if (arrselected[i].Trim() != "") { mlinkman.DelLinkmanFromList(type, Int32.Parse(arrselected[i])); } } GridBind(type); } }
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(); } }
//bound to linkmantype private void BindTypeList() { UDS.Components.MyLinkman mylinkman = new UDS.Components.MyLinkman(); dlt_Type.DataSource = mylinkman.GetCustomLinkmanType(); dlt_Type.DataKeyField = "ID"; dlt_Type.DataBind(); }
private void dgrd_List_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e) { UDS.Components.MyLinkman mlinkman = new UDS.Components.MyLinkman(); if(e.Item.ItemIndex!=-1) { if(mlinkman.HaveInList(1,userid,Int32.Parse(((DataGrid)sender).DataKeys[e.Item.ItemIndex].ToString()))) { for(int i=0;i<e.Item.Cells[0].Controls.Count;i++) { if(e.Item.Cells[0].Controls[i].GetType().ToString()=="System.Web.UI.WebControls.CheckBox") { ((CheckBox)(e.Item.Cells[0].Controls[i])).Enabled = false; } } } } }
private void btn_OK_Click(object sender, System.EventArgs e) { UDS.Components.MyLinkman mlinkman = new UDS.Components.MyLinkman(); UDS.Components.CustomLinkman clinkman = new UDS.Components.CustomLinkman(); clinkman.Name = tbx_Name.Text; clinkman.Age = tbx_Age.Text; clinkman.Gender = (ddl_Gender.Items[ddl_Gender.SelectedIndex].Value=="1")?true:false; clinkman.UnitAddress = tbx_UnitAddress.Text; clinkman.UnitTelephone = tbx_UnitTelephone.Text; clinkman.UnitZip = tbx_UnitZip.Text; clinkman.FamilyAddress = tbx_FamilyAddress.Text; clinkman.FamilyTelephone = tbx_FamilyTelephone.Text; clinkman.FamilyZip = tbx_FamilyZip.Text; clinkman.Email = tbx_Email.Text; clinkman.Mobile = tbx_Mobile.Text; clinkman.Memo = tbx_Memo.Text; clinkman.ID = id; for(int i = 0;i<dlt_Type.Items.Count;i++) { if(((CheckBox)dlt_Type.Items[i].Controls[1]).Checked==true) { clinkman.Type += dlt_Type.DataKeys[i].ToString() + ","; } } mlinkman.UpdateCustomLinkman(clinkman); mlinkman.UpdateCustomLinkmanType(clinkman); BindData(); if(id==0) Response.Write("<script>alert('��ӳɹ�!');</script>"); else Response.Write("<script>alert('�ijɹ�!');</script>"); }
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; } }