线体 机种名称 POL投入 COG压着 FPC压着 外观检查 人数
早 中 晚 計 早 中 晚 計 早 中 晚 計 早 中 晚 計 早 中 晚 計
6 LS022Q8UX07K 4800 0 0 4800 4264 0 0 4264 4086 0 0 4086 4769 0 0 4769 0 0 0 0
6 合計 4800 0 0 4800 4264 0 0 4264 4086 0 0 4086 4769 0 0 4769 0 0 0 0
7 LS022Q8UX07K 3955 0 0 3955 4300 0 0 4300 4616 0 0 4616 4371 0 0 4371 0 0 0 0
7 合計 3955 0 0 3955 4300 0 0 4300 4616 0 0 4616 4371 0 0 4371 0 0 0 0
合計 11257 0 0 11257 11164 0 0 11164 11204 0 0 11204 11479 0 0 11479 0 0 0 0
以上是datalist显示表 怎样把合计那一行变成另外的颜色?
早 中 晚 計 早 中 晚 計 早 中 晚 計 早 中 晚 計 早 中 晚 計
6 LS022Q8UX07K 4800 0 0 4800 4264 0 0 4264 4086 0 0 4086 4769 0 0 4769 0 0 0 0
6 合計 4800 0 0 4800 4264 0 0 4264 4086 0 0 4086 4769 0 0 4769 0 0 0 0
7 LS022Q8UX07K 3955 0 0 3955 4300 0 0 4300 4616 0 0 4616 4371 0 0 4371 0 0 0 0
7 合計 3955 0 0 3955 4300 0 0 4300 4616 0 0 4616 4371 0 0 4371 0 0 0 0
合計 11257 0 0 11257 11164 0 0 11164 11204 0 0 11204 11479 0 0 11479 0 0 0 0
以上是datalist显示表 怎样把合计那一行变成另外的颜色?
GROUP BY Line,MODEL WITH ROLLUP
UPDATE #TP3 SET MODEL = '合計' WHERE MODEL IS NULL
UPDATE #TP3 SET MODEL = '合計' WHERE Line IS NULL AND MODEL IS NULL
在代码里就是 Sda.SelectCommand.CommandText = "QTY";
Sda.SelectCommand.CommandType = CommandType.StoredProcedure;
Sda.SelectCommand.Parameters.Add(new SqlParameter("@FDATE", SqlDbType.DateTime)).Value = quaryDate;
线体 机种名称 POL投入 COG压着 FPC压着 外观检查 人数
早 中 晚 計 早 中 晚 計 早 中 晚 計 早 中 晚 計 早 中 晚 計
6 LS022Q8UX07K 800 0 0 4800 4264 0 0 4264 4086 0 0 4086 4769 0 0 4769 6 合計 4800 0 0 4800 4264 0 0 4264 4086 0 0 4086 4769 0 0 4769
protected void DataList_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
DataRowView drv = e.Item.DataItem as DataRowView;
if (drv != null)
{
e.Item.BackColor = drv["机种名称"].ToString() == "合计" ? System.Drawing.Color.Red : System.Drawing.Color.White;
//e.Item.BackColor = drv["model"].ToString() == "合计" ? System.Drawing.Color.Red : System.Drawing.Color.White;
}
}
}
2 LS030B3UX02 0 10 0 10 0 10 0 10 0 10 0 10 0 11 0 11 0 20 0 20
2 合計 0 10 0 10 0 10 0 10 0 10 0 10 0 11 0 11 0 20 0 20
NULL 合計 10 10 0 20 10 10 0 20 10 10 0 20 11 11 0 22 20 20 0 40
2 LS030B3UX02 0 10 0 10 0 10 0 10 0 10 0 10 0 11 0 11 0 20 0 20
2 合計 0 10 0 10 0 10 0 10 0 10 0 10 0 11 0 11 0 20 0 20
NULL 合計 10 10 0 20 10 10 0 20 10 10 0 20 11 11 0 22 20 20 0 40
e.Item.BackColor = drv["机种名称"].ToString() == "合计" ? System.Drawing.Color.Red : System.Drawing.Color.White;
//e.Item.BackColor = drv["model"].ToString() == "合计" ? System.Drawing.Color.Red : System.Drawing.Color.White;
e.Item.BackColor = drv["model"].ToString() == "合计" ? System.Drawing.Color.Red : System.Drawing.Color.White; 我当时不知道 你的列叫什么名字 所以两个都写了,你使用 标红的 就应该可以的
{
dataListBound(txtDateStart.Text.Trim());
}
// 繫結資料庫
private void dataListBound(string quaryDate)
{
Sda.SelectCommand = new SqlCommand();
Sda.SelectCommand.Connection = conn;
Sda.SelectCommand.CommandText = "qq";
Sda.SelectCommand.CommandType = CommandType.StoredProcedure;
Sda.SelectCommand.Parameters.Add(new SqlParameter("@FDATE", SqlDbType.DateTime)).Value = quaryDate;
Sda.Fill(Ds, "qq");
DataTable newTb = new DataTable();
newTb = Ds.Tables["qq"].Clone(); for (int i = 0; i < newTb.Columns.Count; i++)
{
newTb.Columns[i].DataType = System.Type.GetType("System.String");
}
for (int i = 0; i < Ds.Tables["qq"].Rows.Count; i++)
{
DataRow newDatarow = newTb.NewRow(); for (int j = 0; j < Ds.Tables["qq"].Columns.Count; j++)
{
if (Ds.Tables["qq"].Columns[j].ColumnName.ToUpper() =="A001"||Ds.Tables["qq"].Columns[j].ColumnName.ToUpper() =="A002")
newDatarow[j] = Ds.Tables["qq"].Rows[i][j].ToString()+"%";
else
newDatarow[j] = Ds.Tables["qq"].Rows[i][j].ToString(); }
newTb.Rows.Add(newDatarow); }
if (Ds.Tables["qq"].Rows.Count > 0)
{ DataList1.DataSource = newTb.DefaultView;
DataList1.DataBind(); }
}
if (Ds.Tables["qq"].Rows.Count > 0)
{ DataList1.DataSource = newTb.DefaultView;
DataList1.DataBind(); } 之后,但是写法要换一下for(int i=0;i<DataList1.Items.Count;i++)
{
DataRowView drv = DataList1.Items[i].DataItem as DataRowView;
if (drv != null)
{
DataList1.Items[i].BackColor = drv["model"].ToString() == "合计" ? System.Drawing.Color.Red : System.Drawing.Color.White;
}}
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<asp:DataList ID="dlOne" runat="server" OnItemDataBound="dlOne_ItemDataBound">
<AlternatingItemTemplate>
Name:<%#Eval("Name")%> Money:<%#Eval("Money")%>
</AlternatingItemTemplate>
<ItemTemplate>
Name:<%#Eval("Name")%> Money:<%#Eval("Money")%>
</ItemTemplate>
</asp:DataList>
</form>
</body>
</html>
private DataTable getDateTable()
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Name", typeof(String)));
dt.Columns.Add(new DataColumn("Money", typeof(Int32)));
DataRow dr;
dr = dt.NewRow();
dr[0] = "岗位工资";
dr[1] = 100;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "养老";
dr[1] = 200;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr[0] = "午餐";
dr[1] = 300;
dt.Rows.Add(dr); return dt;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dlOne.DataSource = getDateTable();
dlOne.DataBind();
}
}
protected void dlOne_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
DataRowView drv = e.Item.DataItem as DataRowView;
if (drv != null)
{
e.Item.BackColor = drv["Name"].ToString() == "岗位工资" ? System.Drawing.Color.Red : System.Drawing.Color.White;
} }
}
什么意思?
BorderStyle="None" BorderWidth="1px" CellPadding="0" CellSpacing="0" EnableViewState="False"
GridLines="Vertical" ShowFooter="False" Width="980px" OnItemDataBound="DataList1_ItemDataBound"
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
DataRowView drv = e.Item.DataItem as DataRowView;
if (drv != null)
{
e.Item.BackColor = drv["Name"].ToString() == "岗位工资" ? System.Drawing.Color.Red : System.Drawing.Color.White;
} }
}
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
DataRowView drv = e.Item.DataItem as DataRowView;
if (drv != null)
{
e.Item.BackColor = drv["model"].ToString() == "合计" ? System.Drawing.Color.Red : System.Drawing.Color.White;
//e.Item.BackColor = drv["model"].ToString() == "合计" ? System.Drawing.Color.Red : System.Drawing.Color.White;
}
}我已经写了 还是出错怎么办???
什么意思?