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