/// <summary> /// 首次加载 /// </summary> public void FirstLoad() { StringBuilder sb = new StringBuilder(); string Currency = StorageInBrowseBLL.GetMoreCurrencyIDByCountryCode(Country.SelectedValue).ToString(); int intDocType = QueryInStorageBLL.GetDocTypeIDByDocTypeName("RK"); sb.Append(" D.DocTypeID=" + intDocType); sb.Append(" And " + this.Flag.SelectedValue.ToString() + " and d.Provider=p.ID "); string columns = "d.*,p.[Name]"; string table = "InventoryDoc As D,ProviderInfo as p"; string key = "D.ID"; ViewState["SQLSTR"] = "select " + columns + " from " + table + " where " + sb.ToString() + " order by " + key + " desc"; Pager pSorting = Page.FindControl("Pager1") as Pager; pSorting.PageBind(0, 10, table, columns, sb.ToString(), key, "gvInfo"); }
public void getDocDetiles() { StringBuilder sb = new StringBuilder(); string Currency = StorageInBrowseBLL.GetMoreCurrencyIDByCountryCode(Country.SelectedValue).ToString(); int intDocType = QueryInStorageBLL.GetDocTypeIDByDocTypeName("RK"); sb.Append(" D.DocTypeID=" + intDocType); if (ddlCondition.SelectedValue == "ExpectNum") { if (txtCondition.Text.Trim() != "") { int expectNum = 0; try { expectNum = Convert.ToInt32(txtCondition.Text.Trim()); } catch { this.msg = Transforms.ReturnAlert(GetTran("006829", "期数输入错误!")); return; } sb.Append(" and D." + ddlCondition.SelectedValue + "=" + expectNum.ToString()); } } if (ddlCondition.SelectedIndex > 0 && ddlCondition.SelectedIndex <= 3) { if (txtCondition.Text.Trim() != "") { sb.Append(" and D." + ddlCondition.SelectedValue + " like '%" + txtCondition.Text.Trim() + "%'"); } } if (ddlCondition.SelectedValue == "TotalMoney") { if (txtCondition.Text.Trim() != "") { try { Convert.ToDouble(txtCondition.Text.Trim()); } catch { this.msg = Transforms.ReturnAlert(GetTran("002211", "输入错误!")); return; } sb.Append(" and D." + ddlCondition.SelectedValue + " " + DropDownList1.SelectedValue + " " + Convert.ToDouble(txtCondition.Text.Trim().Replace("'", ""))); } } if (ddlCondition.SelectedValue == "DocMakeTime") { if (txtCondition.Text.Trim() != "") { try { Convert.ToDateTime(this.TextBox1.Text.Trim().Replace("'", "")); } catch { this.msg = Transforms.ReturnAlert(GetTran("002211", "输入错误!")); return; } sb.Append(" and DATEADD(day, DATEDIFF(day,0,D." + ddlCondition.SelectedValue + "), 0)" + DropDownList1.SelectedValue + " ' " + this.TextBox1.Text.Trim() + "'"); } } sb.Append(" And " + Flag.SelectedValue.ToString() + " and d.Provider=p.ID "); string columns = "d.*,p.[Name]"; string table = "InventoryDoc As D,ProviderInfo as p"; string key = "D.ID"; ViewState["SQLSTR"] = "select " + columns + " from " + table + " where " + sb.ToString() + " order by " + key + " desc"; Pager pSorting = Page.FindControl("Pager1") as Pager; pSorting.PageBind(0, 10, table, columns, sb.ToString(), key, "gvInfo"); }