protected void query_Click(object sender, EventArgs e)
{
Label2.Text = "";
Label2.Visible = false;
ProfitBudgetAdapter pba = new ProfitBudgetAdapter();
T_ProfitBudget item = new T_ProfitBudget();
sale_bill_no = this.txt_sale_bill_no.Text.Trim();
//判断是否提交过
DataSet ds = pba.getProfitBudgetSummaryByID(sale_bill_no);
if (ds.Tables[0].Rows.Count > 0)
{
Label2.Text = "该销售订单号已经提交过利润预算！";
Label2.Visible = true;
return;
}
item.SaleBillNo = sale_bill_no;
ds = pba.getSEOrderInfo(item);
if (ds.Tables[0].Rows.Count > 0)
{
finterid = Int32.Parse(ds.Tables[0].Rows[0][0].ToString());
show(ds);
}
}
protected void btn_query_Click(object sender, EventArgs e)
{
string queryStr = this.txt_sale_bill_no.Text.Trim();
ProfitBudgetAdapter pba = new ProfitBudgetAdapter();
if (String.IsNullOrEmpty(queryStr))
{
show(GridView2, pba.getProfitBudgetSummary());
}
else
{
show(GridView2, pba.getProfitBudgetSummaryByID(queryStr));
}
}
private void setData(string id)
{
if (string.IsNullOrEmpty(id))
{
return;
}
ProfitBudgetAdapter pba = new ProfitBudgetAdapter();
DataSet head = pba.getProfitBudgetSummaryByID(id);
lblt_sale_bill_no.Text = id;
lbl_extra_charges.Text = Decimal.Parse(head.Tables[0].Rows[0]["extra_charges"].ToString()).ToString("f2");
DataSet list = pba.getProfitBudgetList(id);
gridviewBind(list);
}