protected void SearchVendorID2_Click(object sender, EventArgs e) { using (SqlConnection Conn = new SqlConnection(strConnectString)) { if (SearchVendorID2.Text.Length > 0) { string strsql = "select DISTINCT vendor_id,vendor_name from bas_vendor_master "; string strwhere = " where vendor_id like '%" + SearchVendorID2TB.Text + "%' or vendor_name like '%" + SearchVendorID2TB.Text + "%'"; DataTable DT = new DataTable(); SqlDataAdapter myAdapter = new SqlDataAdapter(strsql + strwhere, Conn); myAdapter.Fill(DT); if (DT.Rows.Count > 0) { VendorGV.DataSource = DT; VendorGV.DataBind(); } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('搜尋不到資料');</script>"); } } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('請輸入資料');</script>"); } } ModalPopupExtender1.Show(); }
protected void SearchVendorID2_Click(object sender, EventArgs e) { using (SqlConnection Conn = new SqlConnection(strConnectString)) { if (SearchVendorID2.Text.Length > 0) { string strsql = "select DISTINCT vendor_id,vendor_name from bas_vendor_master "; string strwhere = " where vendor_id like '%" + SearchVendorID2TB.Text + "%' or vendor_name like '%" + SearchVendorID2TB.Text + "%'"; DataTable DT = new DataTable(); SqlDataAdapter myAdapter = new SqlDataAdapter(strsql + strwhere, Conn); myAdapter.Fill(DT); if (DT.Rows.Count > 0) { VendorGV.DataSource = DT; VendorGV.DataBind(); } else { F_ErrorShow("搜尋不到資料"); } } else { F_ErrorShow("請輸入資料"); } } ModalPopupExtender1.Show(); }
protected void SearchVendorIDBT_Click(object sender, ImageClickEventArgs e) { //Label4.Text = "客戶名稱或代號:"; SearchVendorID2TB.Text = ""; if (VendorGV.Rows.Count > 0) { MessageLB.Text = ""; VendorGV.DataSource = null; VendorGV.DataBind(); UpdatePanel1.Update(); } UpdatePanel3.Update(); ModalPopupExtender1.Show(); }
protected void SearchVendorID2_Click(object sender, EventArgs e) { MessageLB.Text = ""; if (VendorGV.Rows.Count > 0) { VendorGV.DataSource = null; VendorGV.DataBind(); //UpdatePanel1.Update(); } using (SqlConnection Conn = new SqlConnection(strConnectString)) { if (SearchVendorID2TB.Text.Length > 0) { string strsql; strsql = string.Format("select distinct cus_id,cus_name_brief,cus_name from view_bas_cus_master where cus_id like '%{0}%' or cus_name_brief like '%{0}%' or cus_name like '%{0}%' ", SearchVendorID2TB.Text.ToUpper()); DataTable DT = new DataTable(); SqlDataAdapter myAdapter = new SqlDataAdapter(strsql, Conn); myAdapter.Fill(DT); if (DT.Rows.Count > 0) { VendorGV.DataSource = DT; VendorGV.DataBind(); } else { //Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('搜尋不到資料');</script>"); MessageLB.Text = "搜尋不到資料"; } } else { //Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('請輸入資料');</script>"); MessageLB.Text = "請輸入資料"; } } ModalPopupExtender1.Show(); }