protected void gvList_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#EAF1FD',this.style.fontWeight='';"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor,this.style.fontWeight='';"); CashFlowReport model = e.Row.DataItem as CashFlowReport; if (model.DiffTotal != 0) { e.Row.BackColor = System.Drawing.Color.LightGoldenrodYellow; } if (model.IsZhuan) { var lastSupplierTotal = e.Row.FindControl("lblLastSupplierTotal") as Label; lastSupplierTotal.ForeColor = System.Drawing.Color.Red; } } }
private void Show() { string sql = ""; if (txtPoDateFrom.Text != "") { if (CommHelp.VerifesToDateTime(txtPoDateFrom.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('订单时间 格式错误!');</script>"); return; } sql += string.Format(" and PoDate>='{0} 00:00:00'", txtPoDateFrom.Text); } if (txtPoDateTo.Text != "") { if (CommHelp.VerifesToDateTime(txtPoDateTo.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('订单时间 格式错误!');</script>"); return; } sql += string.Format(" and PoDate<='{0} 23:59:59'", txtPoDateTo.Text); } if (txtGuestName.Text.Trim() != "") { sql += string.Format(" and GuestName like '%{0}%'", txtGuestName.Text.Trim()); } if (txtPONO.Text.Trim() != "") { if (CheckPoNO(txtPONO.Text) == false) { return; } sql += string.Format(" and CG_POOrder.PoNo like '%{0}%'", txtPONO.Text.Trim()); } if (txtPOName.Text.Trim() != "") { sql += string.Format(" and PoName like '%{0}%'", txtPOName.Text.Trim()); } if (ddlPOTyle.Text != "-1") { sql += " and CG_POOrder.POType=" + ddlPOTyle.Text; } if (ddlGuestTypeList.SelectedValue != "全部") { sql += string.Format(" and GuestType='{0}'", ddlGuestTypeList.SelectedValue); } if (ddlGuestProList.SelectedValue != "-2") { sql += string.Format(" and GuestPro={0}", ddlGuestProList.SelectedValue); } if (ddlModel.Text != "全部") { sql += string.Format(" and Model='{0}'", ddlModel.Text); } if (ddlSpecial.Text != "-1") { sql += string.Format(" and IsSpecial=" + ddlSpecial.Text); } if (ddlPoClose.Text != "-1") { sql += " and IsClose=" + ddlPoClose.Text; } if (ddlIsSelect.Text != "-1") { sql += " and IsSelected=" + ddlIsSelect.Text; } if (ddlJieIsSelected.Text != "-1") { sql += " and JieIsSelected=" + ddlJieIsSelected.Text; } if (ddlUser.Text == "-1")//显示所有用户 { } else { if (ViewState["showAll"] != null) { sql += string.Format(" and AE='{0}'", ddlUser.SelectedItem.Text); } else { sql += string.Format(" and AE='{0}'", ddlUser.SelectedItem.Text); } } if (txtPOTotal.Text != "") { if (CommHelp.VerifesToNum(txtPOTotal.Text) == false) { base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('差额 格式错误!');</script>"); return; } } List <CashFlowReport> cashFlowList = cashFlowService.GetYunYingListReport(sql, (ddlJinWei.Text == "1")); if (txtPOTotal.Text != "") { decimal diffTotal = Convert.ToDecimal(txtPOTotal.Text); if (ddlPrice.Text == ">=") { cashFlowList = cashFlowList.FindAll(t => t.DiffTotal >= diffTotal); } else if (ddlPrice.Text == "<") { cashFlowList = cashFlowList.FindAll(t => t.DiffTotal < diffTotal); } else if (ddlPrice.Text == ">") { cashFlowList = cashFlowList.FindAll(t => t.DiffTotal > diffTotal); } else if (ddlPrice.Text == "=") { cashFlowList = cashFlowList.FindAll(t => t.DiffTotal == diffTotal); } else if (ddlPrice.Text == "<=") { cashFlowList = cashFlowList.FindAll(t => t.DiffTotal <= diffTotal); } else if (ddlPrice.Text == "<>") { cashFlowList = cashFlowList.FindAll(t => t.DiffTotal != diffTotal); } } //if (ddlJinWei.Text == "1") //{ // cashFlowList = cashFlowList.FindAll(t => t.IsZhuan == true); //} CashFlowReport sumCashFlow = new CashFlowReport(); sumCashFlow.POTotal = cashFlowList.Sum(t => t.POTotal); sumCashFlow.NotRuTotal = cashFlowList.Sum(t => t.NotRuTotal); sumCashFlow.NotRuSellTotal = cashFlowList.Sum(t => t.NotRuSellTotal); sumCashFlow.SellOutTotal = cashFlowList.Sum(t => t.SellOutTotal); sumCashFlow.LastCaiTotal = cashFlowList.Sum(t => t.LastCaiTotal); sumCashFlow.SupplierTotal = cashFlowList.Sum(t => t.SupplierTotal); sumCashFlow.FPTotal = cashFlowList.Sum(t => t.FPTotal); sumCashFlow.InvoiceTotal = cashFlowList.Sum(t => t.InvoiceTotal); sumCashFlow.Profit = cashFlowList.Sum(t => t.Profit); sumCashFlow.GoodSellPriceTotal = cashFlowList.Sum(t => t.GoodSellPriceTotal); sumCashFlow.TrueNotKuCunTotal = cashFlowList.Sum(t => t.TrueNotKuCunTotal); sumCashFlow.YingFuKuCun = cashFlowList.Sum(t => t.YingFuKuCun); sumCashFlow.FaxPoTotal = cashFlowList.Sum(t => t.FaxPoTotal); sumCashFlow.LastSupplierTotal = cashFlowList.Sum(t => t.LastSupplierTotal); lblYuQiYingShouTotal.Text = string.Format("{0:n6}", sumCashFlow.YuQiYingShou); lblYingFuKuCunTotal.Text = string.Format("{0:n6}", sumCashFlow.YingFuKuCun); lblLastSupplierTotal.Text = string.Format("{0:n6}", sumCashFlow.LastSupplierTotal); lblAllPoTotal.Text = string.Format("{0:n6}", sumCashFlow.POTotal); lblFPTotal.Text = string.Format("{0:n6}", sumCashFlow.FPTotal); lblNoFpTotal.Text = string.Format("{0:n6}", sumCashFlow.NoFpTotal); lblInvoiceTotal.Text = string.Format("{0:n6}", sumCashFlow.InvoiceTotal); lblYingShouTotal.Text = string.Format("{0:n6}", sumCashFlow.YingShouTotal); lblLastCaiTotal.Text = string.Format("{0:n6}", sumCashFlow.LastCaiTotal); lblSupplierTotal.Text = string.Format("{0:n6}", sumCashFlow.SupplierTotal); lblYingFuTotal.Text = string.Format("{0:n6}", sumCashFlow.YingFuTotal); //计算库存总额 var kucunTotal = Convert.ToDecimal(DBHelp.ExeScalar("select isnull(sum(GoodNum*GoodAvgPrice),0) from TB_HouseGoods")); lblInvoiceTotal.Text = string.Format("{0:n6}", sumCashFlow.InvoiceTotal); var kcXuJianTotal = cashFlowService.GetKCXuJianTotal(); lblKCXuJianTotal.Text = string.Format("{0:n6}", kcXuJianTotal); lblKuCunTotal.Text = string.Format("{0:n6}", kucunTotal); var KCWeiZhiFuTotal = cashFlowService.GetNoInvoiceTotal();//库存未支付合计 lblKCWeiZhiFuTotal.Text = string.Format("{0:n6}", KCWeiZhiFuTotal); //运营总盘子=库存总金额+项目应收合计-项目应付合计+预付未到库合计+ KC预付未到库合计-库存未支付合计 lblSellTotal.Text = string.Format("{0:n6}", sumCashFlow.GoodSellPriceTotal); AspNetPager1.RecordCount = cashFlowList.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; this.gvList.DataSource = cashFlowList; this.gvList.DataBind(); }