protected void gvMain_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='';");
JXC_REPORTTotal m = e.Row.DataItem as JXC_REPORTTotal;
// m.GuestProString = m.GuestProString.Replace("用户", "");
if (m.IsClose)
{
e.Row.BackColor = System.Drawing.Color.FromArgb(204, 255, 204);
}
if (m.allScore > 0)
{
e.Row.BackColor = System.Drawing.Color.Pink;
}
if (m.IsQuanDao)
{
var lblDays = e.Row.FindControl("lblDays") as Label;
lblDays.Font.Underline = true;
}
}
}
protected void gvMain_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='';");
JXC_REPORTTotal m = e.Row.DataItem as JXC_REPORTTotal;
// m.GuestProString = m.GuestProString.Replace("用户", "");
if (m.IsClose)
{
e.Row.BackColor = System.Drawing.Color.FromArgb(204, 255, 204);
}
if (m.IsQuanDao)
{
var lblDays = e.Row.FindControl("lblDays") as Label;
lblDays.Font.Underline = true;
}
if (m.YuGuDaoKuanDate != null && m.YuGuDaoKuanDate < DateTime.Now && m.Model != "模型8")
{
e.Row.BackColor = System.Drawing.Color.Khaki;
}
//在模型8中我们发现最近开票日之后的到款已完全到款，这时候预估到款=0，我们的DELAY判定需要修正一下，按如下：
//预估到款日这列的日期，如 < 今天的日期且预估到款金额 > 0，说明这个项目付款有DELAY，请帮我把整个这一行的背景设置成土黄色。按此修正
if (m.Model == "模型8" && m.YuGuDaoKuanDate != null && m.YuGuDaoKuanDate < DateTime.Now && m.YuGuDaoKuanTotal > 0)
{
e.Row.BackColor = System.Drawing.Color.Khaki;
}
}
}
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='';");
JXC_REPORTTotal m = e.Row.DataItem as JXC_REPORTTotal;
if (m != null && m.IsQuanDao)
{
var lblDays = e.Row.FindControl("lblDays") as Label;
lblDays.Font.Underline = true;
}
}
}
/// <summary>
/// 获得数据列表（比DataSet效率高，推荐使用）
/// </summary>
public List <Model.JXC.JXC_REPORTTotal> GetListArray_Total(string strWhere, string having)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CG_POOrder.PONo,CG_POOrder.PODate, CG_POOrder.GuestName, ");
strSql.Append(" sum(goodSellTotal) as goodSellTotal,sum(goodTotal)+sum(t_goodTotalChas) as goodTotal, ");
strSql.Append(" sum(maoli) as maoliTotal,FPTotal,AE,INSIDE,AEPer as AEPer,INSIDEPer as INSIDEPer");
strSql.Append(" from CG_POOrder ");
strSql.Append(" left join Sell_TuiSunCha_Report on CG_POOrder.PONo=Sell_TuiSunCha_Report.PONo ");
strSql.Append(" left join (select sum(ZhangQi) as zhangqi,PoNo,SUM(Total) as InvoTotal from TB_ToInvoice where TB_ToInvoice.state='通过' group by PoNo) as newtable1 on CG_POOrder.PONo=newtable1.PONo");
strSql.Append(" left join (select SUM(total) as SellFPTotal,PONo from Sell_OrderFP where Status='通过' group by PONo) as ntb2 on CG_POOrder.PONo=ntb2.PONo");
strSql.Append(" where ifzhui=0 and CG_POOrder.Status='通过'");
if (strWhere.Trim() != "")
{
strSql.Append(strWhere);
}
strSql.Append(" GROUP BY CG_POOrder.PONo,CG_POOrder.PODate ,CG_POOrder.GuestName ,AE,INSIDE,FPTotal,AEPer,INSIDEPer ");
if (having != "")
{
strSql.Append(having);
}
List <Model.JXC.JXC_REPORTTotal> list = new List <Model.JXC.JXC_REPORTTotal>();
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
using (SqlDataReader dataReader = objCommand.ExecuteReader())
{
while (dataReader.Read())
{
JXC_REPORTTotal model = new JXC_REPORTTotal();
object ojb;
model.PONo = dataReader["PONo"].ToString();
ojb = dataReader["PODate"];
if (ojb != null && ojb != DBNull.Value)
{
model.PODate = (DateTime)ojb;
}
model.GuestName = dataReader["GuestName"].ToString();
ojb = dataReader["goodSellTotal"];
if (ojb != null && ojb != DBNull.Value)
{
model.goodSellTotal = (decimal)ojb;
}
ojb = dataReader["goodTotal"];
if (ojb != null && ojb != DBNull.Value)
{
model.goodTotal = (decimal)ojb;
}
ojb = dataReader["maoliTotal"];
if (ojb != null && ojb != DBNull.Value)
{
model.maoliTotal = (decimal)ojb;
}
model.AE = dataReader["AE"].ToString();
model.INSIDE = dataReader["INSIDE"].ToString();
ojb = dataReader["AEPer"];
if (ojb != null && ojb != DBNull.Value)
{
model.AEPer = (decimal)ojb;
}
ojb = dataReader["INSIDEPer"];
if (ojb != null && ojb != DBNull.Value)
{
model.INSIDEPer = (decimal)ojb;
}
model.TrueLiRun = model.InvoiceTotal - model.goodTotal;
model.AETotal = model.AEPer * model.maoliTotal / 100;
model.InsidTotal = model.INSIDEPer * model.maoliTotal / 100;
list.Add(model);
}
}
}
return(list);
}
