/// <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(); }