protected void DropDownListLocation_SelectedIndexChanged(object sender, EventArgs e) { BindStore(); ListBoxClaimMonth.Items.Clear(); GridViewResult.DataBind(); TextBoxClaimNumber.Text = ""; }
//private void BindStore() //{ // //DropDownListStore.DataSource = Store.GetStoreListByLocationId(Convert.ToInt32(DropDownListLocation.SelectedValue)); // DropDownListStore.DataSource = Store.GetStoreListByAccountId(Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId); // DropDownListStore.DataTextField = "Description"; // DropDownListStore.DataValueField = "StoreId"; // DropDownListStore.DataBind(); // DropDownListStore.Items.Insert(0, new ListItem("Please select", "0")); //} protected void DropDownListLocation_SelectedIndexChanged(object sender, EventArgs e) { //BindStore(); //ListBoxClaimMonth.Items.Clear(); //GridViewResult.DataBind(); //TextBoxClaimNumber.Text = ""; //ButtonSaveList.Visible = false; ListBoxClaimMonth.DataSource = StoreRep.Web.Code.Claim.GetClaimMonthByLocation(Convert.ToInt32(DropDownListLocation.SelectedValue), Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId); ListBoxClaimMonth.DataTextField = "FormattedClaimDate"; //ListBoxClaimMonth.DataValueField = "ClaimScheduleId"; ListBoxClaimMonth.DataBind(); ListBoxClaimMonth.Enabled = ListBoxClaimMonth.Items.Count > 0; GridViewResult.DataBind(); TextBoxClaimNumber.Text = ""; RadioButtonPaid.Checked = false; RadioButtonUnpaid.Checked = false; ButtonSaveList.Visible = false; ButtonFNBPreview.Visible = false; //ButtonSaveResend.Visible = false; if (ListBoxClaimMonth.Items.Count == 0) { ListBoxClaimMonth.Items.Clear(); } else { //ListBoxClaimMonth.Items.Insert(0, new ListItem("ALL", "0")); } }
protected void DropDownListStore_SelectedIndexChanged(object sender, EventArgs e) { if (Roles.IsUserInRole("RepClaim")) { BindRepStoreClaimMonth(); return; } ListBoxClaimMonth.DataSource = ClaimSku.GetClaimSkuMonthByStore(Convert.ToInt32(DropDownListStore.SelectedValue), Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId); ListBoxClaimMonth.DataTextField = "FormattedClaimDate"; //ListBoxClaimMonth.DataValueField = "ClaimSkuId"; ListBoxClaimMonth.DataBind(); ListBoxClaimMonth.Enabled = ListBoxClaimMonth.Items.Count > 0; GridViewResult.DataBind(); TextBoxClaimNumber.Text = ""; if (ListBoxClaimMonth.Items.Count == 0) { ListBoxClaimMonth.Items.Clear(); } else { ListBoxClaimMonth.Items.Insert(0, new ListItem("ALL", "0")); } }
protected void ListBoxClaimMonth_SelectedIndexChanged(object sender, EventArgs e) { string claimMonth = ""; for (int i = 0; i < ListBoxClaimMonth.Items.Count; i++) { if (ListBoxClaimMonth.Items[i].Selected == true) { if (ListBoxClaimMonth.Items[i].Text == "ALL") { for (int j = 0; j < ListBoxClaimMonth.Items.Count; j++) { claimMonth += ListBoxClaimMonth.Items[j].Text + ","; } } else { claimMonth += ListBoxClaimMonth.Items[i].Text + ","; } } } GridViewResult.DataSource = ClaimSku.GetClaimSkuListByClaimMonthAndStoreId(claimMonth, Convert.ToInt32(DropDownListStore.SelectedValue), Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId); GridViewResult.DataBind(); }
protected void ButtonSave_Click(object sender, EventArgs e) { try { LabelError.Text = ""; foreach (GridViewRow gridViewRow in GridViewResult.Rows) { //HiddenField hiddenFieldClaimId = (HiddenField)gridViewRow.Cells[0].FindControl("HiddenFieldClaimId"); HiddenField hiddenFieldStoreId = (HiddenField)gridViewRow.Cells[0].FindControl("HiddenFieldStoreId"); Label labelClaimNumber = (Label)gridViewRow.Cells[4].FindControl("LabelClaimNumber"); CheckBox checkBoxApproved = (CheckBox)gridViewRow.Cells[7].FindControl("CheckBoxApproved"); //StoreRep.Web.Code.Claim.UpdateClaimApprovalByClaimId(Convert.ToInt32(hiddenFieldClaimId.Value), (checkBoxApproved.Checked) ? 1 : 0, this.Master.LoggedOnAccount); StoreRep.Web.Code.Claim.UpdateClaimApprovalByStoredClaimNumber(Convert.ToInt32(hiddenFieldStoreId.Value), labelClaimNumber.Text, (checkBoxApproved.Checked) ? 1 : 0, this.Master.LoggedOnAccount); } LabelError.Text = "Save Successful."; PanelError.Visible = true; GridViewResult.DataSource = null; GridViewResult.DataBind(); } catch (System.Data.SqlClient.SqlException sqlEx) { LabelError.Text = ""; for (int i = 0; i < sqlEx.Errors.Count; i++) { LabelError.Text += (sqlEx.Errors[i].Message + "<br />"); } PanelError.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { Page.Form.DefaultFocus = TextBoxSearchValue.ClientID; Page.Form.DefaultButton = ButtonSearch.UniqueID; if (!IsPostBack) { //BindASTreeView(); string[] alphabet = "A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y;Z;All".Split(';'); RepeaterAlphabet.DataSource = alphabet; RepeaterAlphabet.DataBind(); string searchValue = (Request.QueryString["EmployeeId"] == null) ? "" : Request.QueryString["EmployeeId"]; if (searchValue.Length != 0) { GridViewResult.DataSource = EmployeeReportsTo.GetEmployeeReportsToListByFilter(searchValue, (CheckBoxUnassigned.Checked) ? 1 : 0, Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId); GridViewResult.DataBind(); } else { GridViewResult.DataSource = EmployeeReportsTo.GetEmployeeReportsToListByFilter("%", (CheckBoxUnassigned.Checked) ? 1 : 0, Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId); GridViewResult.DataBind(); } } PanelError.Visible = false; }
protected void ButtonSearchByClaimNumber_Click(object sender, EventArgs e) { LabelError.Text = ""; PanelError.Visible = false; GridViewResult.DataSource = null; GridViewResult.DataBind(); Account account = Account.GetAccountByUserName(Page.User.Identity.Name.ToString()); if (TextBoxSearchClaimNumber.Text.Length > 0) { GridViewResult.DataSource = StoreRep.Web.Code.Claim.GetClaimApprovalListByClaimNumber(TextBoxSearchClaimNumber.Text.Trim(), account.CompanyId, account.AccountId); GridViewResult.DataBind(); } TextBoxSearchClaimNumber.Text = ""; if (GridViewResult.Rows.Count == 0) { LabelError.Text = "No rows returned."; PanelError.Visible = true; } else { ButtonSave.Visible = true; } }
/// <summary> /// 查询 /// </summary> /// <param name="sender">控件对象</param> /// <param name="e">事件参数</param> private void BtnQuery_Click(object sender, EventArgs e) { try { GridViewResult.Stop(); this.Cursor = Cursors.WaitCursor; DateTime bdate = Convert.ToDateTime(sdtDate.Bdate.Value.ToString("yyyy-MM-dd 00:00:00")); DateTime edate = Convert.ToDateTime(sdtDate.Edate.Value.ToString("yyyy-MM-dd 23:59:59")); int queryWorkId = Convert.ToInt32(cmbWorker.SelectedValue); string currentUserName = (string)InvokeController("GetCurrentUserName"); DataTable dtReport = (DataTable)InvokeController("GetFinacialDispenseData", frmName, bdate, edate, queryWorkId); Dictionary <string, object> myDictionary = new Dictionary <string, object>(); myDictionary.Add("Title", cmbWorker.Text.Trim() + "发药人员工作量统计"); myDictionary.Add("DateRange", sdtDate.Bdate.Value.ToString("yyyy-MM-dd") + "至" + sdtDate.Edate.Value.ToString("yyyy-MM-dd")); myDictionary.Add("Printer", currentUserName); GridReport gridreport = new GridReport(); gridreport = ReportTool.GetReport((InvokeController("this") as AbstractController).LoginUserInfo.WorkId, 4019, 0, myDictionary, dtReport); GridViewResult.Report = gridreport.Report; GridViewResult.Start(); GridViewResult.Refresh(); } catch (Exception error) { MessageBox.Show(error.Message); } finally { this.Cursor = Cursors.Default; } }
/// <summary> /// 查询 /// </summary> /// <param name="sender">控件对象</param> /// <param name="e">事件参数</param> private void BtnQuery_Click(object sender, EventArgs e) { try { GridViewResult.Stop(); this.Cursor = Cursors.WaitCursor; DateTime bdate = dtTimer.Bdate.Value; DateTime edate = dtTimer.Edate.Value; int queryWorkId = Convert.ToInt32(cbbWork.SelectedValue); string queryTimeType = Convert.ToString(cbbTimeType.SelectedValue); string qyeryDocType = Convert.ToString(cbbDocType.SelectedValue); string currentUserName = (string)InvokeController("GetCurrentUserName"); DataTable dtReport = (DataTable)InvokeController("QueryInpatientWorkLoad", queryWorkId, bdate.ToString("yyyy-MM-dd 00:00:00"), edate.ToString("yyyy-MM-dd 23:59:59"), qyeryDocType, queryTimeType); Dictionary <string, object> myDictionary = new Dictionary <string, object>(); myDictionary.Add("Title", cbbWork.Text.Trim() + "住院医生工作量统计"); myDictionary.Add("DateRange", dtTimer.Bdate.Value.ToString("yyyy-MM-dd") + "至" + dtTimer.Edate.Value.ToString("yyyy-MM-dd")); myDictionary.Add("Printer", currentUserName); myDictionary.Add("DocType", "医生类型:" + cbbDocType.Text); myDictionary.Add("TimeType", "时间类型:" + cbbTimeType.Text); GridReport gridreport = new GridReport(); gridreport = ReportTool.GetReport((InvokeController("this") as AbstractController).LoginUserInfo.WorkId, 3011, 0, myDictionary, dtReport); GridViewResult.Report = gridreport.Report; GridViewResult.Start(); GridViewResult.Refresh(); } catch (Exception error) { MessageBox.Show(error.Message); } finally { this.Cursor = Cursors.Default; } }
protected void GridViewResult_RowCommand(object sender, GridViewCommandEventArgs e) { try { switch (e.CommandName.ToLower()) { case "delete": { Communication.DeleteCommunicationByCommunicationId(Convert.ToInt32(e.CommandArgument)); GridViewResult.DataSource = Communication.GetCommunicationListByFilter("%", Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).CompanyId); GridViewResult.DataBind(); break; } } } catch (System.Data.SqlClient.SqlException sqlEx) { //LabelError.Text = ""; //for (int i = 0; i < sqlEx.Errors.Count; i++) //{ // LabelError.Text += (sqlEx.Errors[i].Message + "<br />"); //} //PanelError.Visible = true; } }
protected void ButtonSearch_Click(object sender, EventArgs e) { GridViewResult.DataSource = ClaimSkuSubCategorySupplier.GetClaimSkuSubCategorySupplierListByClaimSupplierId(Convert.ToInt32(DropDownListSupplier.SelectedValue)); GridViewResult.DataBind(); ButtonSaveList.Visible = GridViewResult.Rows.Count > 0; }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { string filter = ""; filter = string.Format(" Make like '%{0}%' or Model like '%{0}%' or Year like '%{0}%' ", (TextBoxFilter.Text.Trim() == "Keyword filter") ? "" : TextBoxFilter.Text.Trim()); //Retrieve the table from the session object. dtb = get_data(); if (dtb != null) { try { GridViewResult.PageIndex = 0; GridViewResult.DataSource = dtb.Select(filter).CopyToDataTable(); } catch { GridViewResult.DataSource = null; } } else { GridViewResult.DataSource = null; } GridViewResult.DataBind(); }
protected void DropDownListSupplier_SelectedIndexChanged(object sender, EventArgs e) { GridViewResult.DataSource = null; GridViewResult.DataBind(); ButtonSaveList.Visible = false; }
protected void ListBoxClaimMonth_SelectedIndexChanged(object sender, EventArgs e) { for (int i = 0; i < ListBoxClaimMonth.Items.Count; i++) { if (ListBoxClaimMonth.Items[i].Selected == true) { if (ListBoxClaimMonth.Items[i].Text == "ALL") { for (int j = 0; j < ListBoxClaimMonth.Items.Count; j++) { claimMonth += ListBoxClaimMonth.Items[j].Text + ","; } } else { claimMonth += ListBoxClaimMonth.Items[i].Text + ","; } } } if (Roles.IsUserInRole("RepClaim")) { GridViewResult.DataSource = StoreRep.Web.Code.Claim.GetClaimListByClaimMonthAndStoreIdByRep(claimMonth, Convert.ToInt32(DropDownListStore.SelectedValue), Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId); GridViewResult.DataBind(); return; } GridViewResult.DataSource = StoreRep.Web.Code.Claim.GetClaimListByClaimMonthAndStoreId(claimMonth, Convert.ToInt32(DropDownListStore.SelectedValue), Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId); GridViewResult.DataBind(); }
protected void DropDownListSupplier_SelectedIndexChanged(object sender, EventArgs e) { LabelError.Text = ""; GridViewResult.DataSource = null; GridViewResult.DataBind(); BindFilter(); }
private void BindGridViewResultDefault() { string searchValue = "%"; GridViewResult.DataSource = InsightSupplier.GetInsightSupplierListByFilter(searchValue); GridViewResult.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Page.Form.DefaultFocus = TextBoxSearchValue.ClientID; Page.Form.DefaultButton = ButtonSearch.UniqueID; if (!IsPostBack) { PageLayout(); BindRoleList(); string[] alphabet = "A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y;Z;All".Split(';'); RepeaterAlphabet.DataSource = alphabet; RepeaterAlphabet.DataBind(); string searchValue = (Request.QueryString["EmployeeNumber"] == null) ? "" : Request.QueryString["EmployeeNumber"]; if (searchValue.Length != 0) { GridViewResult.DataSource = Employee.GetEmployeeListByFilterLimited(searchValue, DropDownListRole.SelectedItem.Text, Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId); GridViewResult.DataBind(); } else { //GridViewResult.DataSource = Employee.GetEmployeeListByFilter("%", DropDownListRole.SelectedItem.Text, Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId); //GridViewResult.DataBind(); } } PanelError.Visible = false; }
protected void Page_Load(object sender, EventArgs e) { this.supplierId = Common.GetEncryptedQueryStringValue("SupplierId", 0); Page.Form.DefaultFocus = TextBoxSearchValue.ClientID; Page.Form.DefaultButton = ButtonSearch.UniqueID; if (!IsPostBack) { if (ViewState["SupplierId"] != null) { this.supplierId = Convert.ToInt32(ViewState["SupplierId"].ToString()); } string[] alphabet = "A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y;Z;All".Split(';'); RepeaterAlphabet.DataSource = alphabet; RepeaterAlphabet.DataBind(); string searchValue = (Request.QueryString["Description"] == null) ? "" : Request.QueryString["Description"]; if (searchValue.Length != 0) { GridViewResult.DataSource = Product.GetProductListByFilter(searchValue, supplierId); GridViewResult.DataBind(); } } PanelError.Visible = false; }
protected void GridViewResult_PageIndexChanging(object sender, GridViewPageEventArgs e) { string filter = ""; filter = string.Format(" Make like '%{0}%' or Model like '%{0}%' or Year like '%{0}%' ", (TextBoxFilter.Text.Trim() == "Keyword filter") ? "" : TextBoxFilter.Text.Trim()); //Retrieve the table from the session object. dtb = get_data(); if (dtb != null) { GridViewResult.PageIndex = e.NewPageIndex; DataTable dt = dtb.Select(filter).CopyToDataTable(); if (Session["SortExpression"] != null) { string sort = Session["SortExpression"].ToString(); //if (sort.LastIndexOf("ASC") > -1) sort = sort.Replace("ASC", "DESC"); //else if (sort.LastIndexOf("DESC") > -1) sort = sort.Replace("DESC", "ASC"); dt.DefaultView.Sort = sort; } GridViewResult.DataSource = dt; GridViewResult.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["GeneralConnection"] != null) { cn = (GeneralConnection)Session["GeneralConnection"]; } else { cn = ConnectionHelper.GetConnection(); } if (!IsPostBack) { Session["SortExpression"] = null; lodding(); if (Session["list_result"] != null) { GridViewResult.DataSource = (DataTable)Session["list_result"]; GridViewResult.DataBind(); get_detail(); } } }
/// <summary> /// 查询 /// </summary> /// <param name="sender">控件对象</param> /// <param name="e">事件参数</param> private void BtnQuery_Click(object sender, EventArgs e) { try { GridViewResult.Stop(); this.Cursor = Cursors.WaitCursor; DateTime bdate = Convert.ToDateTime(sdtDate.Bdate.Value.ToString("yyyy-MM-dd 00:00:00")); DateTime edate = Convert.ToDateTime(sdtDate.Edate.Value.ToString("yyyy-MM-dd 23:59:59")); int queryWorkId = Convert.ToInt32(cmbWorker.SelectedValue); int queryTimeType = cmbTimeType.SelectedIndex;//0收费时间 1缴款时间 int rowGroupType = cmbRowGroupType.SelectedIndex; int colGroupType = cmbColGroupType.SelectedIndex; string currentUserName = (string)InvokeController("GetCurrentUserName"); DataTable dtReport = (DataTable)InvokeController("GetFinacialOPRevenueData", frmName, bdate, edate, queryWorkId, queryTimeType, rowGroupType, colGroupType); Dictionary <string, object> myDictionary = new Dictionary <string, object>(); myDictionary.Add("Title", cmbWorker.Text.Trim() + "门诊收入统计"); myDictionary.Add("DateRange", sdtDate.Bdate.Value.ToString("yyyy-MM-dd") + "至" + sdtDate.Edate.Value.ToString("yyyy-MM-dd")); myDictionary.Add("Printer", currentUserName); gridreport = ReportTool.GetReport((InvokeController("this") as AbstractController).LoginUserInfo.WorkId, 2006, 0, myDictionary, dtReport); gridreport.Report.Initialize += new _IGridppReportEvents_InitializeEventHandler(ReportInitialize); GridViewResult.Report = gridreport.Report; GridViewResult.Start(); GridViewResult.Refresh(); } catch (Exception error) { MessageBox.Show(error.Message); } finally { this.Cursor = Cursors.Default; } }
private void BindGridViewResult() { string claimMonth = ""; for (int i = 0; i < ListBoxClaimMonth.Items.Count; i++) { if (ListBoxClaimMonth.Items[i].Selected == true) { if (ListBoxClaimMonth.Items[i].Text == "ALL") { for (int j = 0; j < ListBoxClaimMonth.Items.Count; j++) { claimMonth += ListBoxClaimMonth.Items[j].Text + ","; } } else { claimMonth += ListBoxClaimMonth.Items[i].Text; } } } PanelErrorSpace.Visible = false; PanelSaveSpace.Visible = false; GridViewResult.DataSource = ClaimPayment.GetClaimPaymentListByClaimMonthAndLocationIdNonDairy(claimMonth, Convert.ToInt32(DropDownListLocation.SelectedValue), Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId, (RadioButtonPaid.Checked) ? 1 : 0); GridViewResult.DataBind(); ButtonSaveList.Visible = GridViewResult.Rows.Count > 0 && !RadioButtonPaid.Checked; ButtonFNBPreview.Visible = GridViewResult.Rows.Count > 0 && !RadioButtonPaid.Checked; }
private void LoggedOnUserSearch() { PanelPageHeaderControls.Visible = false; GridViewResult.DataSource = Employee.GetEmployeeByAccountId(Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId); GridViewResult.DataBind(); }
/// <summary> /// 血糖数据绑定 /// </summary> /// <param name="dtBloodGluRecord">血糖数据</param> public void BindBloodGluRecord(DataTable dtBloodGluRecord) { try { GridViewResult.Stop(); this.Cursor = Cursors.WaitCursor; Dictionary <string, object> myDictionary = new Dictionary <string, object>(); int rowindex = dgvPatInfo.CurrentCell.RowIndex; DataTable dt = (DataTable)dgvPatInfo.DataSource; myDictionary.Add("医院名称", (InvokeController("this") as AbstractController).LoginUserInfo.WorkName); myDictionary.Add("科室", dt.Rows[rowindex]["deptName"]); myDictionary.Add("姓名", dt.Rows[rowindex]["PatName"]); myDictionary.Add("性别", dt.Rows[rowindex]["PatSex"]); myDictionary.Add("年龄", GetAge(dt.Rows[rowindex]["Age"].ToString())); myDictionary.Add("床号", dt.Rows[rowindex]["BedNo"]); myDictionary.Add("住院号", dt.Rows[rowindex]["SerialNumber"]); gridreport = new GridReport(); gridreport = ReportTool.GetReport((InvokeController("this") as AbstractController).LoginUserInfo.WorkId, 3205, 0, myDictionary, dtBloodGluRecord); GridViewResult.Report = gridreport.Report; GridViewResult.Start(); GridViewResult.Refresh(); } catch (Exception error) { MessageBox.Show(error.Message); } finally { this.Cursor = Cursors.Default; } }
private void GridData() { SqlCommand sqlcmd; SqlDataAdapter da; DataTable dt = new DataTable(); String query; if (tbSearch.Text == "") { query = "select * from result"; } else { query = "select * from result where enrollment_no like '" + tbSearch.Text.ToString().Trim() + "%'"; } sqlcmd = new SqlCommand(query, Db.DbConnect()); da = new SqlDataAdapter(sqlcmd); dt.Clear(); da.Fill(dt); if (dt.Rows.Count > 0) { //Label1.Text = ""; GridViewResult.DataSource = dt; GridViewResult.DataBind(); } else { GridViewResult.DataBind(); //Label1.Text = "No Records Found"; } }
protected void ListBoxRoleName_SelectedIndexChanged(object sender, EventArgs e) { BindEmployee(); GridViewResult.DataSource = null; GridViewResult.DataBind(); ListBoxEmployee.Visible = ListBoxEmployee.Items.Count > 0; }
protected void btnSearch_Click(object sender, EventArgs e) { List <Book> theList = new List <Book>(); string sql = ""; string bookTitle = txtSearch.Text.ToString(); string bookAuthor = txtAuthor.Text.ToString(); string bookCategory = DropDownListCategory.Items[DropDownListCategory.SelectedIndex].ToString(); if (chkSearch.Checked == true && chkAuthor.Checked == true && ChkCategory.Checked == true) { theList = booksController.RetrieveByTitleAuthorCategory(txtSearch.Text, txtAuthor.Text, int.Parse(DropDownListCategory.SelectedValue.ToString())); //sql = "Select * from Book, Category where Book.CategoryID= Category.CategoryID and Title like '%" + bookTitle + "%' and Author like '%" + bookAuthor + "%' and Name = '" + bookCategory + "' "; } else if (chkSearch.Checked == true && chkAuthor.Checked == true) { theList = booksController.RetrieveByTitleAuthor(txtSearch.Text, txtAuthor.Text); //sql = "Select * from Book where Title like '%" + bookTitle + "%' and Author like '%" + bookAuthor + "%' "; } else if (chkSearch.Checked == true && ChkCategory.Checked == true) { theList = booksController.RetrieveByTitleCategory(txtSearch.Text, int.Parse(DropDownListCategory.SelectedValue.ToString())); //sql = "Select * from Book, Category where Book.CategoryID= Category.CategoryID and Title like '%" + bookTitle + "%' and Name = '" + bookCategory + "' "; } else if (chkAuthor.Checked == true && ChkCategory.Checked == true) { theList = booksController.RetrieveByAuthorCategory(txtAuthor.Text, int.Parse(DropDownListCategory.SelectedValue.ToString())); //sql = "Select * from Book, Category where Book.CategoryID= Category.CategoryID and Author like '%" + bookAuthor + "%' and Name = '" + bookCategory + "' "; } else if (chkSearch.Checked == true) { theList = booksController.RetrieveByTitle(txtSearch.Text); //sql = "Select * from Book where Title like '%" + bookTitle + "%' "; } else if (chkAuthor.Checked == true) { theList = booksController.RetrieveByAuthor(txtAuthor.Text); //sql = "Select * from Book where Author like '%" + bookAuthor + "%' "; } else if (ChkCategory.Checked == true) { theList = booksController.RetrieveByCategory(int.Parse(DropDownListCategory.SelectedValue.ToString())); //sql = "Select * from Book, Category where Book.CategoryID= Category.CategoryID and Name= '" + bookCategory + "' "; } else { theList = booksController.RetrieveAll(); } Session["TaskTable"] = theList; GridViewResult.DataSource = theList; GridViewResult.DataBind(); }
/// <summary> /// 查找病人列表 /// </summary> /// <param name="sender">sender</param> /// <param name="e">e</param> private void btnQuery_Click(object sender, EventArgs e) { InvokeController("GetPatInfoList", sdtDate.Bdate.Value, sdtDate.Edate.Value, radOutHosp.Checked, DeptId, frmName); GridViewResult.Stop(); GridViewResult.Report = null; GridViewResult.Stop(); GridViewResult.Report = null; }
protected void Page_Load(object sender, EventArgs e) { string name = Request.QueryString["Name"]; List <Book> theList = booksController.RetrieveByTitle(name); GridViewResult.DataSource = theList; GridViewResult.DataBind(); }
protected void ButtonSearch_Click(object sender, EventArgs e) { LabelError.Text = ""; string filter = DropDownListSupplier.SelectedValue == "All" ? "All" : DropDownListFilter.SelectedValue; GridViewResult.DataSource = Barcode.GetBarcodeListByFilter("%" + TextBoxSearchValue.Text + "%", DropDownListSupplier.SelectedValue, filter, companyId); GridViewResult.DataBind(); }