void BindListByKeyword() { string KeyWord = KeyTextBox.Text; DateTime BeginDate = DateTime.MinValue; DateTime EndDate = DateTime.MaxValue; ArticleQuery q = new ArticleQuery(); q.KeyWord = KeyWord; q.BeginDate = BeginDate; q.EndDate = EndDate; ArticlePager.PageSize = PageSize; ArticlePager.RecorderCount = ArticleHelper.QueryArtilceCountByAll(q); if (PageSize > 0) { PagerDiv.Visible = (ArticlePager.RecorderCount <= PageSize) ? false : true; } List <Article> list = ArticleHelper.QueryArtilcesByAll(q, ArticlePager.Begin, ArticlePager.Count, null); DetailGridView.DataSource = list; DetailGridView.DataBind(); MessageLabel.Text = "查询关键字“" + KeyTextBox.Text + "”的结果:"; }
protected override void Initialize() { TagsGroup ag = TagsHelper.GetTagsGroup(); DetailGridView.DataSource = ag.Items; DetailGridView.DataBind(); }
protected override void Initialize() { //获取到所拥有这个权限的用户ID string content = "Advice.Handle"; List <string> accountIDs = AdviceHelper.GetAllReceivers(AdviceTypeID, content); List <Account> account = new List <Account>(); foreach (string aID in accountIDs) { if (aID != "") { account.Add(AccountHelper.GetAccount(aID, new string[] { "LoginName", "DepartmentID" })); } } if (SearchTextBox.Text.Trim() != "" && SearchTextBox.Text != null) { List <Account> at = new List <Account>(); for (int i = 0; i < account.Count; i++) { if (account[i].LoginName == SearchTextBox.Text) { at.Add(account[i]); } } DetailGridView.DataSource = at; } else { DetailGridView.DataSource = account; } DetailGridView.DataBind(); UpdateAdviceTag(); }
protected override void Initialize() { string rawurl = Request.RawUrl; rawurl = We7Helper.RemoveParamFromUrl(rawurl, "keyword"); string qString = @"<label class=""hidden"" for=""user-search-input"">ËÑË÷{0}:</label> <input type=""text"" class=""search-input"" id=""KeyWord"" name=""KeyWord"" value="""" onKeyPress=""javascript:KeyPressSearch('{1}',event);"" /> <input type=""button"" value=""ËÑË÷"" class=""button"" id=""SearchButton"" onclick=""javascript:doSearch('{1}');"" />"; qString = string.Format(qString, "À¸Ä¿", rawurl); SearchSimpleLiteral.Text = qString; MyChannelList = new ArrayList(); List<Channel> allChannel = null; if (!string.IsNullOrEmpty(ChannelType) && ChannelType.ToString() == "link") { allChannel = ChannelHelper.GetAllLinkChannels(); } else if (!string.IsNullOrEmpty(ChannelType) && ChannelType.ToString() == "article") { allChannel = ChannelHelper.GetChannelByModelName(""); } else { Channel ch = ChannelHelper.GetChannel(ColumnID, null); string enumState = ""; if (ch != null) enumState = ch.EnumState; allChannel = ChannelHelper.GetChannelsByType(enumState); } if (allChannel != null) { GetSubChannels(We7Helper.EmptyGUID, "", allChannel); } MyChannelList = FilterByKeyword(); DetailGridView.DataSource = MyChannelList; DetailGridView.DataBind(); }
//Delete Requisition History protected void detailGridView_Delete(object sender, GridViewDeleteEventArgs e) { int reqId = Convert.ToInt32(DetailGridView.DataKeys[e.RowIndex].Values[0]); Session["sessionID"] = reqId; EmployeeController.DeleteReqHistory(reqId); DetailGridView.DataSource = EmployeeController.ViewRequisition(Profile.EmpNo); DetailGridView.DataBind(); }
public void SortDetailGrid(Object sender, GridViewSortEventArgs e) { // Create a DataView from the Credit Detail DataTable. DataView dv = new DataView((DataTable)Session["CreditDetailTable"]); dv.Sort = e.SortExpression; DetailGridView.DataSource = dv; DetailGridView.DataBind(); }
protected void DeleteButton_Click(object sender, EventArgs e) { Button b = (Button)sender; int reqId = Convert.ToInt32(b.CommandArgument); Session["sessionID"] = reqId; EmployeeController.DeleteReqHistory(reqId); DetailGridView.DataSource = EmployeeController.ViewRequisition(Profile.EmpNo); DetailGridView.DataBind(); }
protected void ClearGrids() { DateGridView.DataBind(); QuoteGridView.DataBind(); FilterShowingLabel.Text = ""; HeaderUpdatePanel.Update(); DetailGridView.DataBind(); QuoteDetailUpdatePanel.Update(); //UpdateButton.Visible = false; //UpdateUpdatePanel.Update(); }
protected override void Initialize() { ArticleQuery query = new ArticleQuery(); query.ChannelID = ColumnID; List <Article> data = ArticleHelper.QueryArtilcesByAll(query, 0, 100, null); DetailGridView.DataSource = data; DetailGridView.DataBind(); BuildRows(); }
void BindListByFilter() { ArticlePager.RecorderCount = ArticleHelper.QueryArticlesCountByTags(Tags); ArticlePager.PageSize = PageSize; string[] fields = new string[] { "ID", "Title", "OwnerID", "Description", "Permission" }; List <Article> list = ArticleHelper.QueryArticlesByTags(Tags, ArticlePager.Begin, ArticlePager.Count, fields); DetailGridView.DataSource = list; DetailGridView.DataBind(); MessageLabel.Text = "直接匹配标签“" + TagsLabel.Text + "”的结果:"; }
protected override void Initialize() { string query = null; if (SearchTextBox.Text.Length > 0) { query = SearchTextBox.Text.Trim(); } selectLabel.Text = string.Format("选择一个{0}:", InfoKey); Template[] tps = null; GeneralConfigInfo si = GeneralConfigs.GetConfig(); if (si.DefaultTemplateGroupFileName != null && si.DefaultTemplateGroupFileName.Length > 0) { tps = TemplateHelper.GetTemplates(query, si.DefaultTemplateGroupFileName.Replace(".xml", "")); } else { tps = TemplateHelper.GetTemplates(query); } object dat; if (Request["list"] == "sub") { List <Template> ts = new List <Template>(); foreach (Template tp in tps) { if (tp.IsSubTemplate) { ts.Add(tp); } } dat = ts; } else { List <Template> ts = new List <Template>(); foreach (Template tp in tps) { if (!tp.IsSubTemplate) { ts.Add(tp); } } dat = ts; } DetailGridView.DataSource = dat; DetailGridView.DataBind(); }
protected void QueryButton_Click(object sender, EventArgs e) { TagsGroup ag = TagsHelper.GetTagsGroup(); List <TagsGroup.Item> items = new List <TagsGroup.Item>(); foreach (TagsGroup.Item item in ag.Items) { if (item.Words.Contains(SearchTextBox.Text.Trim())) { items.Add(item); } } DetailGridView.DataSource = items; DetailGridView.DataBind(); // Initialize(); }
void ShowTempalteGroup() { NameTextBox.Text = Data.Name; DescriptionTextBox.Text = Data.Description; CreatedLabel.Text = Data.Created.ToString(); FileTextBox.Text = Data.FileName; DetailGridView.DataSource = Data.Items; DetailGridView.DataBind(); DetailLabel.Text = String.Format("共有{0}个模板。", Data.Items.Count); Template[] tps = TemplateHelper.GetTemplates(null, Path.GetFileNameWithoutExtension(FileName)); TempldatesGridView.DataSource = tps; TempldatesGridView.DataBind(); TempldatesLabel.Text = String.Format("共有{0}个模板文件。", tps.Length); }
protected void RefreshDetailGrid(DataTable DetailData) { DataView lineView = new DataView(); DetailGridView.DataSource = DetailData; DetailGridView.DataBind(); QuoteDetailUpdatePanel.Update(); Session[DetailTableName.Value] = DetailData; if (DetailData.Rows.Count > 0) { //UpdateButton.Visible = true; //UpdateUpdatePanel.Update(); } else { ShowPageMessage("No Quote Detail.", 2); MessageUpdatePanel.Update(); } }
public void SortDetailGrid(Object sender, GridViewSortEventArgs e) { try { // Create a DataView from the Quote Detail DataTable. string LineFilter; DataView dv = new DataView((DataTable)Session[DetailTableName.Value]); dv.Sort = e.SortExpression; DetailSortField.Value = e.SortExpression; //dv.RowFilter = LineFilter; DetailGridView.DataSource = dv; DetailGridView.DataBind(); DetailGridPanel.Height = new Unit(double.Parse(DetailGridHeightHidden.Value), UnitType.Pixel); DetailGridPanel.Width = new Unit(double.Parse(DetailGridWidthHidden.Value), UnitType.Pixel); } catch (Exception e2) { ShowPageMessage("Sort Error " + e2.Message + ", " + e2.ToString(), 2); } }
protected void Sort(string sortName) { string sortText = sortName; DataControl[] ds = TemplateHelper.SortDataControls(sortText); DetailGridView.DataSource = ds; DetailGridView.DataBind(); ModeDataList.DataSource = ds; ModeDataList.DataBind(); if (ds.Length == 0) { ShowMessage("没有符合条件的控件。"); } else { ShowMessage(String.Format("总共 {0} 个控件。", ds.Length)); } }
protected override void Initialize() { string rawurl = Request.RawUrl; rawurl = We7Helper.RemoveParamFromUrl(rawurl, "keyword"); string qString = @"<label class=""hidden"" for=""user-search-input"">ËÑË÷{0}:</label> <input type=""text"" class=""search-input"" id=""KeyWord"" name=""KeyWord"" value="""" onKeyPress=""javascript:KeyPressSearch('{1}',event);"" /> <input type=""button"" value=""ËÑË÷"" class=""button"" id=""SearchButton"" onclick=""javascript:doSearch('{1}');"" />"; qString = string.Format(qString, "Àà±ð", rawurl); SearchSimpleLiteral.Text = qString; rawurl = We7Helper.GetParamValueFromUrl(rawurl, "type"); CategoryList = new ArrayList(); if (rawurl == "dep") { NameLabel.Text = "Ñ¡ÔñÒ»¸ö²¿ÃÅ"; List <Common.PF.Department> allDepartments = null; allDepartments = AccountHelper.GetDepartments(siteID, We7Helper.EmptyGUID, "", new string[] { "ID", "Title", "Description", "State" }); foreach (Common.PF.Department d in allDepartments) { DrawTreeMenu(d, ""); } CategoryList = FilterByKeyword(); DetailGridView.DataSource = CategoryList; DetailGridView.Columns[2].Visible = false; } else { NameLabel.Text = "Ñ¡ÔñÒ»¸öÀà±ð"; List <Category> allCategory = null; allCategory = CategoryHelper.GetCategoryByParentID(We7Helper.EmptyGUID); foreach (Category c in allCategory) { DrawTreeMenu(c, ""); } CategoryList = FilterByKeyword(); DetailGridView.DataSource = CategoryList; } DetailGridView.DataBind(); }
protected override void Initialize() { string root; if (We7Helper.IsEmptyID(ColumnID)) { GoParentHyperLink.NavigateUrl = "iChannels.aspx"; root = ""; CurrentUrl = "/"; } else { Channel ch = ChannelHelper.GetChannel(ColumnID, new string[] { "ID", "Name", "Description", "ParentID", "FullPath", "FullUrl" }); CurrentPath = ch.Description; GoParentHyperLink.NavigateUrl = String.Format("iChannels.aspx?id={0}&oid={1}&type=quote", ch.ParentID, QuoteOwnerID); root = ch.FullPath; CurrentUrl = ch.FullUrl; } CurrentPath = "根栏目" + root.Replace("/", " / "); List <Channel> data = ChannelHelper.GetChannels(ColumnID); if (data == null || data.Count == 0) { //ShowMessage("没有数据。"); } else { //ShowMessage(String.Format("总共有 {0}个栏目。", data.Count)); foreach (Channel ch in data) { ch.TemplateText = TemplateHelper.GetTemplateName(ch.TemplateName); ch.FullPath = String.Concat(root, "/", ch.Name); } } DetailGridView.DataSource = data; DetailGridView.DataBind(); }
public void DetailGridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { //DataView dv = new DataView((DataTable)Session[DetailTableName.Value]); // Create a DataView from the Quote Detail DataTable. try { string LineFilter; DataView dv = new DataView((DataTable)Session[DetailTableName.Value]); dv.Sort = DetailSortField.Value; //dv.RowFilter = LineFilter; DetailGridView.DataSource = dv; DetailGridView.PageIndex = e.NewPageIndex; DetailGridView.DataBind(); DetailGridPanel.Height = Unit.Pixel(int.Parse(DetailGridHeightHidden.Value)); DetailGridPanel.Width = Unit.Pixel(int.Parse(DetailGridWidthHidden.Value)); QuoteDetailUpdatePanel.Update(); } catch (Exception e2) { ShowPageMessage("Paging Error " + DetailGridHeightHidden.Value.ToString() + " : " + e2.ToString(), 2); } }
protected override void Initialize() { string selectQuery = this.FieldDropDownList.SelectedItem.ToString(); string query = SearchTextBox.Text; DataControl[] ds = TemplateHelper.GetDataControls(query, selectQuery); DetailGridView.DataSource = ds; DetailGridView.DataBind(); ModeDataList.DataSource = ds; ModeDataList.DataBind(); if (ds.Length == 0) { ShowMessage("没有符合条件的控件。"); } else { ShowMessage(String.Format("总共 {0} 个控件。", ds.Length)); } }
protected void Page_Load(object sender, EventArgs e) { int empNo = Profile.EmpNo; if (!IsPostBack) { for (int i = 0; i < DetailGridView.Rows.Count; i++) { string check = DetailGridView.Rows[i].Cells[3].Text.ToString(); if (check.Equals("Approved")) { DetailGridView.Rows[i].Cells[1].Visible = false; } } string empName = EmployeeController.GetName(empNo); name.Text = empName; DetailGridView.Visible = true; requsition = new List <Requisition>(); reqhistory = new List <ReqHistory>(); DetailGridView.DataSource = EmployeeController.ViewRequisition(empNo); DetailGridView.DataBind(); } }
protected void GetDocument(string InvoiceNo, string SONo) { try { OrderIDHidden.Value = ""; Session["CreditDetailTable"] = null; ClearPageMessages(); // get the data. ds = SqlHelper.ExecuteDataset(connectionString, "pSOEGetCreditRGA", new SqlParameter("@PassedInvoice", InvoiceNo), new SqlParameter("@PassedOrder", SONo)); if (ds.Tables.Count >= 1) { if (ds.Tables.Count == 1) { // We only go one table back, something is wrong dt = ds.Tables[0]; if (dt.Rows[0]["ErrorType"].ToString().Trim() + dt.Rows[0]["ErrorCode"].ToString() == "E0081") { ShowPageMessage("Document is on file but is the wrong type", 2); CreditRGAScriptManager.SetFocus("InvoiceNoTextBox"); return; } if (dt.Rows[0]["ErrorType"].ToString().Trim() + dt.Rows[0]["ErrorCode"].ToString() == "E0001") { ShowPageMessage("Document not found. " + InvoiceNo + "," + SONo, 2); CreditRGAScriptManager.SetFocus("InvoiceNoTextBox"); return; } if (dt.Rows.Count > 0) { ShowPageMessage("GetCreditRGA processing error. " + InvoiceNo + "," + SONo, 2); return; } } else { dt = ds.Tables[1]; if (dt.Rows.Count == 0) { HeaderGridView.DataBind(); HeaderUpdatePanel.Update(); DetailGridView.DataBind(); DetailUpdatePanel.Update(); ShowPageMessage("Invoice/Order not found.", 2); CreditRGAScriptManager.SetFocus("InvoiceNoTextBox"); } else { DetailGridView.DataSource = dt; DetailGridView.DataBind(); Session["CreditDetailTable"] = dt; OrderIDHidden.Value = ds.Tables[2].Rows[0]["FoundID"].ToString().Trim(); ShipLocHidden.Value = ds.Tables[2].Rows[0]["ShipLoc"].ToString().Trim(); try { RGAReturnToDropDown.SelectedValue = ShipLocHidden.Value.ToString(); } catch { } ShowMakeButton(); DetailUpdatePanel.Update(); dt = ds.Tables[2]; HeaderGridView.DataSource = dt; HeaderGridView.DataBind(); HeaderUpdatePanel.Update(); } } } ScriptManager.RegisterClientScriptBlock(InvoiceNoTextBox, InvoiceNoTextBox.GetType(), "SizeUpdate", "SetHeight();", true); } catch (Exception e2) { ShowPageMessage("GetCreditRGA Error " + e2.Message + ", " + e2.ToString(), 2); } }
protected void GetQuotes(string CustNo, string FilterField, string FilterValue, string GridToFill) { try { // get the quote data. string FreshQOH = "0"; if (GridToFill == "Detail") { FreshQOH = "1"; } ds = SqlHelper.ExecuteDataset(connectionString, "pSOEGetQuotes", new SqlParameter("@Organization", CustNo), new SqlParameter("@QuoteFilterField", FilterField), new SqlParameter("@QuoteFilterValue", FilterValue), new SqlParameter("@FreshQOH", FreshQOH)); if (ds.Tables.Count >= 1) { dt = ds.Tables[1]; if (dt.Rows.Count == 0) { DateGridView.DataBind(); DetailGridView.DataBind(); QuoteGridView.DataBind(); FilterShowingLabel.Text = ""; } else { if (GridToFill == "Header") { DataTable dtDates = new DataTable(); dtDates.Columns.Add("QuoteDate", typeof(DateTime)); dtDates.Columns.Add("QuoteCount", typeof(int)); int DateCtr = 0; string Lastdate = ""; string Newdate = ""; string LastQuote = ""; string NewQuote = ""; DataRow daterow; CustNameLabel.Text = dt.Rows[0]["CustomerName"].ToString(); Session["MasterTable"] = dt; Lastdate = string.Format("{0:yyyy-MM-dd}", dt.Rows[0]["QuotationDate"]); DateToGet = string.Format("{0:MM/dd/yyyy}", dt.Rows[0]["QuotationDate"]); foreach (DataRow drow in dt.Rows) { Newdate = string.Format("{0:yyyy-MM-dd}", drow["QuotationDate"]); NewQuote = drow["SessionID"].ToString(); if (Newdate != Lastdate) { daterow = dtDates.NewRow(); daterow["QuoteDate"] = Lastdate; daterow["QuoteCount"] = DateCtr; dtDates.Rows.Add(daterow); Lastdate = Newdate; DateCtr = 0; } if (NewQuote != LastQuote) { DateCtr++; LastQuote = NewQuote; } } daterow = dtDates.NewRow(); daterow["QuoteDate"] = Newdate; daterow["QuoteCount"] = DateCtr; dtDates.Rows.Add(daterow); DateGridView.DataSource = dtDates; DateGridView.DataBind(); FillGridView(dt); DetailGridView.DataBind(); } if (GridToFill == "Detail") { DetailGridView.DataSource = dt; DetailGridView.DataBind(); } //QuoteUpdatePanel.Update(); //DataView dv = new DataView(dt, "SubItem = '" + ItemNo + "'", "", DataViewRowState.CurrentRows); //AltAvailLabel.Text = String.Format("{0:#,##0}", dv[0]["AltQOH"]); } } } catch (Exception e2) { ErrorLabel.Text = e2.Message + ", " + e2.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { DetailGridView.DataSource = GetDepartmentList(); DetailGridView.DataBind(); }