private void BindGridView(string strFydh)
{
try
{
DataSet ds = FYDList.GetFYDDetail(strFydh);
decimal strSL = 0;
decimal strZL = 0;
if (ds != null)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
if (!string.IsNullOrEmpty(row["sl"].ToString()))
{
strSL += Convert.ToDecimal(row["sl"]);
}
if (!string.IsNullOrEmpty(row["zl"].ToString()))
{
strZL += Convert.ToDecimal(row["zl"].ToString());
}
}
}
this.lblSL.Text = Convert.ToInt32(strSL).ToString();
this.lblZL.Text = strZL.ToString("#0.0000");
this.grdFYDetail.DataSource = ds;
this.grdFYDetail.DataBind();
}
catch
{
this.PrintfError("数据访问错误！");
return;
}
}
private void BindGrid()
{
try
{
DataSet ds = FYDList.GetKHInfo(GetSqlWhere());
this.grvKHList.DataSource = ds;
this.grvKHList.DataBind();
}
catch
{
this.PrintfError("数据访问错误，请重试！");
return;
}
}
//设置分页控件显示
private void SetPageCountView()
{
try
{
string sqlWhere = GetSqlWhere();
int outCount;
int pageCount = FYDList.GetPageCount(sqlWhere, PageControl1.GetPageSize(), out outCount);
PageControl1.SetInitView(pageCount, outCount);
}
catch
{
this.PrintfError("数据访问错误，请重试！");
return;
}
}
//绑定GridView
private void BindGridView()
{
try
{
string sql = GetSqlWhere();
string sortEx = this.grvFYDList.Attributes["SortExpression"];
string sortDirect = this.grvFYDList.Attributes["SortDirection"];
string strSort = (!string.IsNullOrEmpty(sortEx)) ? sortEx + " " + sortDirect : "";
DataSet ds = FYDList.QueryFYQD(sql, strSort, PageControl1.GetPageSize(), PageControl1.GetCurrPage());
this.grvFYDList.DataSource = ds;
this.grvFYDList.DataBind();
}
catch (Exception ex)
{
String strEx = ex.Message;
this.PrintfError("数据访问错误，请重试！");
}
}
