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 dl_KB_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
KB_Catalog catalog = (KB_Catalog)e.Item.DataItem;
UC_GridView gv_KB = (UC_GridView)e.Item.FindControl("gv_KB");
gv_KB.PageIndex = 0;
BindKBGridView(gv_KB, catalog.ID);
}
}
protected void dl_Board_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
BBS_Board Board = (BBS_Board)e.Item.DataItem;
UC_GridView grd_BBS = (UC_GridView)e.Item.FindControl("grd_BBS");
grd_BBS.PageIndex = 0;
BindBBSGridView(grd_BBS, Board.ID);
}
}
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);
}
}
}
protected void gv_KB_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
int Catalog = 0;
int.TryParse(((GridView)sender).Attributes["CatalogID"], out Catalog);
if (Catalog > 0)
{
UC_GridView gv_KB = (UC_GridView)sender;
gv_KB.PageIndex = e.NewPageIndex;
BindKBGridView(gv_KB, Catalog);
}
}
protected void grd_BBS_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
int BoardID = 0;
int.TryParse(((GridView)sender).Attributes["BoardID"], out BoardID);
if (BoardID > 0)
{
UC_GridView grd_BBS = (UC_GridView)sender;
grd_BBS.PageIndex = e.NewPageIndex;
BindBBSGridView(grd_BBS, BoardID);
}
}
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 gv_Sell_DataBound(object sender, EventArgs e)
{
UC_GridView gv = (UC_GridView)sender;
foreach (GridViewRow row in gv.Rows)
{
//row.Cells[6].Text = row.Cells[6].Text.Replace(" 0:00:00", "");
for (int i = 0; i < row.Cells.Count; i++)
{
if (row.Cells[i].Text == "0")
{
row.Cells[i].Text = "";
}
}
}
gv.Width = new Unit(70 * gv.Rows[0].Cells.Count);
}
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();
}
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 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.##");
}
}
}
