repater列求和

repater：

sql里面求和

 

public void showList()
        {
            string fromdate = txtFromDate.Text;
            string todate = txtToDate.Text;
            string sales = ddlSales.SelectedValue;
            DataTable dt = B_Commission.getSales_volume(fromdate,todate,sales);
            rptList_stk.DataSource =dt;
            rptList_stk.DataBind();

            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    p_sub_total = p_sub_total + dr["amount"].getDbl();
                    P_sub_profit = P_sub_profit + dr["profit"].getDbl();
                }
            }

            lbl_Total.Text = MyNumber.showNum_TwoDecimal(p_sub_total);
            lbl_Total_profit.Text = MyNumber.showNum_TwoDecimal(P_sub_profit);
        }

if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
Model.MP_invoiceItem mp = ((Model.MP_invoiceItem)e.Item.DataItem);(使用model转化的时候)
tal = tal + Convert.ToDecimal(mp.amount);
}
if (e.Item.ItemType == ListItemType.Footer)
{
Label lbl = (Label)e.Item.FindControl("lbl_Total");
lbl.Text = tal.getString();
}

Model.MP_invoiceItem mp = ((Model.MP_invoiceItem)e.Item.DataItem);
Label lbl = (Label)e.Item.FindControl("lbl_Total");
lbl.Text = mp.amount.getString();
tal = tal + Convert.ToDecimal(mp["amount"]);

repeater增删改

获得linkbutton的CommandArgument的值
int spec_id = e.CommandArgument.getInt();

if (e.CommandName == "Edit")
            {
                textcommand = int.Parse(e.CommandArgument.ToString());
            }
            else if (e.CommandName == "Cancel")
            {
                textcommand = -1;
            }
            else if (e.CommandName == "Update")
            {
                //Update
                int spec_id = e.CommandArgument.getInt();
                string batch_code = ((TextBox)this.rptList.Items[e.Item.ItemIndex].FindControl("txtBatchCode")).Text.Trim();
                string step_code = ((TextBox)this.rptList.Items[e.Item.ItemIndex].FindControl("txtStepCode")).Text.Trim();
                int qty = ((TextBox)this.rptList.Items[e.Item.ItemIndex].FindControl("txtQty")).Text.Trim().getInt();
                string warranty = ((TextBox)this.rptList.Items[e.Item.ItemIndex].FindControl("txtWarranty")).Text.Trim();

                B_Item.updateItemSpac(batch_code, step_code, qty, warranty, spec_id);
                this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('更新ID：" +
                     e.CommandArgument + "；页面值：A," + batch_code + "----B," + step_code + "----C," + qty + "');", true);
                AppendRowForUpdate();
            }
            else if (e.CommandName == "Delete")
            {
                //Delete.  
                for (int i = 0; i < rptList.Items.Count; i++)
                {
                    CheckBox chk = (CheckBox)rptList.Items[i].FindControl("ckboxRemove");
                    if (chk.Checked)
                    {
                        int spec_id = e.CommandArgument.getInt();
                        B_Item.deleteItemSpac(spec_id);
                    }
                }
                this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "key", "alert('删除ID：" + e.CommandArgument + "');", true);
                AppendRowForUpdate();
            }

            ShowItemspec();
            AppendRowForUpdate();
        }
    }
}