/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SaleOrderRule rule = new SaleOrderRule();
gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1));
gridView1.GridControl.Show();
}
/// <summary>
/// 绑定Grid
/// </summary>
public override void BindGrid()
{
SaleOrderRule rule = new SaleOrderRule();
DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("FormStatusName", "'' FormStatusName").Replace("FaHuoStatusName", "'' FaHuoStatusName").Replace("NoFaPieceQty", "(ISNULL(PieceQty,0) - ISNULL(TotalRecPieceQty,0)) NoFaPieceQty").Replace("NoFaWeight", "(ISNULL(Weight,0) - ISNULL(TotalRecWeight,0)) NoFaWeight").Replace("NoFaQty", "(ISNULL(Qty,0)-ISNULL(TotalRecQty,0)) NoFaQty").Replace("NoFaYard", "(ISNULL(Yard,0)-ISNULL(TotalRecYard,0)) NoFaYard"));
//ProFaHuoStatusName(dt);
//SaleOrderStatusProc.ProcColorStatusName(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").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();
}
