/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SaleOrderRule rule = new SaleOrderRule();
DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("FormStatusName", "'' FormStatusName").Replace("ReceiveAmount", "0.0 ReceiveAmount"));
SaleOrderStatusProc.ProcColorStatusName(dt);
ProcDataSourceQty(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
string sql = "SELECT COUNT( ID) FROM UV1_Sale_SaleOrderDts WHERE 1=1";
sql += HTDataConditionStr + " GROUP BY ID";
DataTable dtSO = SysUtils.Fill(sql);
if (dtSO.Rows.Count > 0)
{
lbCount.Text = "销售合同数：" + dtSO.Rows[0][0].ToString();
}
else
{
lbCount.Text = "销售合同数：0";
}
if (ProductParamSet.GetIntValueByID(5418) == (int)YesOrNo.Yes)//更新回签标志
{
sql = "UPDATE Sale_SaleOrder SET HQFlag=1 WHERE FormNo IN (SELECT ISNULL(FileProt2,'') FROM Data_WinListAttachFile WHERE FileProt1=" + SysString.ToDBString(this.Text) + ")";
SysUtils.ExecuteNonQuery(sql);
}
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SaleOrderRule rule = new SaleOrderRule();
DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("FormStatusName", "'' FormStatusName"));
SaleOrderStatusProc.ProcColorStatusName(dt);
ProcDataSourceQty(dt);
gridView1.GridControl.DataSource = dt;
gridView1.GridControl.Show();
string sql = "SELECT distinct ID FROM UV1_Sale_SaleOrderDts WHERE 1=1";
sql += HTDataConditionStr;
dt = SysUtils.Fill(sql);
lbCount.Text = "销售合同数：" + dt.Rows.Count.ToString();
}