private void BindBBSGridView(UC_GridView grd_BBS, int BoardID) { string condition = "[Board] = " + BoardID + " AND SendTime BETWEEN DATEADD(Day,-15,GetDate()) AND GETDATE() ORDER by [SendTime] desc"; grd_BBS.BindGrid(BBS_ForumItemBLL.GetModelList(condition)); grd_BBS.Attributes["BoardID"] = BoardID.ToString(); }
protected void gv_ListDetail_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { int id = (int)gv_ListDetail.DataKeys[e.Row.RowIndex][0]; UC_GridView gv_Detail = (UC_GridView)e.Row.FindControl("gv_Detail"); if (gv_Detail != null) { IList <FNA_FeeWriteOffDetail> lists = new FNA_FeeWriteOffBLL(id).Items; //费用类型 int accounttile = 0; int.TryParse(tr_AccountTitle.SelectValue, out accounttile); if (ddl_FeeType.SelectedValue != "0" && !(accounttile > 1)) { IList <AC_AccountTitleInFeeType> titles = AC_AccountTitleInFeeTypeBLL.GetModelList("FeeType=" + ddl_FeeType.SelectedValue); int[] ids = new int[titles.Count]; for (int i = 0; i < titles.Count; i++) { ids[i] = titles[i].AccountTitle; } lists = lists.Where(p => ids.Contains(p.AccountTitle)).ToList(); } //费用科目 if (accounttile > 1) { DataTable dt = TreeTableBLL.GetAllChildByNodes("MCS_PUB.dbo.AC_AccountTitle", "ID", "SuperID", accounttile.ToString()); int[] ids = new int[dt.Rows.Count + 1]; for (int i = 0; i < dt.Rows.Count; i++) { ids[i] = (int)dt.Rows[i]["ID"]; } ids[ids.Length - 1] = accounttile; lists = lists.Where(p => ids.Contains(p.AccountTitle)).ToList(); } //核销金额判断 decimal _cost = 0; decimal.TryParse(tbx_WriteOffCost.Text, out _cost); if (_cost != 0) { if (ddl_WriteOffCostOP.SelectedValue == ">") { lists = lists.Where(p => p.WriteOffCost + p.AdjustCost > _cost).ToList(); } else if (ddl_WriteOffCostOP.SelectedValue == "<") { lists = lists.Where(p => p.WriteOffCost + p.AdjustCost < _cost).ToList(); } } gv_Detail.BindGrid(lists); } } }
protected void gv_List_Contract_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { int id = (int)gv_List_Contract.DataKeys[e.Row.RowIndex][0]; UC_GridView gv_Detail = (UC_GridView)e.Row.FindControl("gv_Detail"); if (gv_Detail != null) { gv_Detail.BindGrid(new CM_ContractBLL(id).Items); } } }
private void BindKBGridView(UC_GridView gv_KB, int Catalog) { DataTable dt = TreeTableBLL.GetAllChildByNodes("MCS_OA.dbo.KB_Catalog", "ID", "SuperID", Catalog.ToString()); string catalogs = Catalog.ToString(); foreach (DataRow dr in dt.Rows) { catalogs += "," + dr["ID"].ToString(); } string condition = "ID IN(Select TOP 3 ID FROM MCS_OA.dbo.KB_Article WHERE Catalog IN (" + catalogs + ") AND IsDelete = 'N' AND HasApproved = 'Y' ORDER BY ApproveTime DESC)"; gv_KB.BindGrid(KB_ArticleBLL.GetModelList(condition)); gv_KB.Attributes["CatalogID"] = Catalog.ToString(); }
protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e) { Label lb_SheetCode = (Label)e.Item.FindControl("lb_SheetCode"); lb_SheetCode.Text = string.Format("核销单号:{0}---费用明细 第{1}页,共{2}页", ViewState["SheetCode"], e.Item.ItemIndex + 1, ViewState["TotalPage"]); Literal _c = (Literal)e.Item.FindControl("lb_RepeaterNextPage"); if (_c != null && e.Item.ItemIndex % 2 == 0) { _c.Text = "<br/><div class='PageNext'></div><br/>"; } UC_GridView gv_List = (UC_GridView)e.Item.FindControl("gv_List"); if (gv_List != null) { IList <FNA_FeeWriteOffDetail> list = ((IList <FNA_FeeWriteOffDetail>)ViewState["Details"]).OrderBy(p => p.Client).ThenBy(p => p.AccountTitle).ThenBy(p => p.BeginMonth).ToList(); IList <FNA_FeeWriteOffDetail> l = new List <FNA_FeeWriteOffDetail>(); decimal subtotal = 0; if (ht_pageitem.Contains(e.Item.ItemIndex.ToString()) && (int)ht_pageitem[e.Item.ItemIndex.ToString()] > 0) { for (int i = 0; i < (int)ht_pageitem[e.Item.ItemIndex.ToString()]; i++) { if (list.Count > 0) { FNA_FeeWriteOffDetail m = list[0]; list.Remove(m); l.Add(m); subtotal += m.WriteOffCost + m.AdjustCost; } } for (int j = 0; j < PRINTPAGESIZE - (int)ht_pageitem[e.Item.ItemIndex.ToString()]; j++) { l.Add(new FNA_FeeWriteOffDetail()); } } gv_List.BindGrid(l); ViewState["Details"] = list; if ((int)ViewState["State"] == 3) { //核销完成,可见调整金额及原因 gv_List.Columns[gv_List.Columns.Count - 1].Visible = true; //扣减原因 gv_List.Columns[gv_List.Columns.Count - 2].Visible = true; //扣减方式 gv_List.Columns[gv_List.Columns.Count - 3].Visible = true; //扣减金额 gv_List.Columns[gv_List.Columns.Count - 4].Visible = true; //批复金额 gv_List.Columns[gv_List.Columns.Count - 5].Visible = true; //扣减原因 gv_List.Columns[gv_List.Columns.Count - 6].Visible = true; //扣减方式 gv_List.Columns[gv_List.Columns.Count - 7].Visible = true; //扣减金额 } if (ViewState["HasFeeApply"].ToString() == "N") { //当费用为无申请费用时,下列字段隐藏 gv_List.Columns[0].Visible = false; //发生客户 gv_List.Columns[1].Visible = false; //客户渠道 gv_List.Columns[6].Visible = false; //申请单备案号 } if (ViewState["IsEvectionWriteOff"].ToString() == "Y") { //当核销单关联至差旅行程报销时,下列字段隐藏 gv_List.Columns[5].Visible = false; //备注 } Label lb_SubTotalCostCN = (Label)e.Item.FindControl("lb_SubTotalCostCN"); if (lb_SubTotalCostCN != null) { lb_SubTotalCostCN.Text = MCSFramework.Common.Rmb.CmycurD(subtotal); } Label lb_SubTotalCost = (Label)e.Item.FindControl("lb_SubTotalCost"); if (lb_SubTotalCost != null) { lb_SubTotalCost.Text = subtotal.ToString("0.##"); } } }