/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { ItemBuyFormRule rule = new ItemBuyFormRule(); gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag")); gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { ItemBuyFollowRule rule = new ItemBuyFollowRule(); gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.Show(); string sql = "SELECT FormNo,ShopID,ReqDate,MakeDate,TotalQty FROM Buy_ItemBuyForm WHERE 1=1"; sql += " AND FormNo NOT IN (SELECT BuyFormNo FROM Buy_ItemBuyFollow"; if (saveNoLoadCheckDayNum != 0) { sql += " WHERE FormDate BETWEEN " + SysString.ToDBString(DateTime.Now.AddDays(0 - saveNoLoadCheckDayNum).ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(DateTime.Now.ToString("yyyy-MM-dd")); } sql += ") "; if (ChkMakeDate.Checked) { sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtBuyDateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtBuyDateE.DateTime.ToString("yyyy-MM-dd")); } sql += " AND SubmitFlag=1 ORDER BY FormNo DESC "; DataTable dt = SysUtils.Fill(sql); gridView2.GridControl.DataSource = dt; gridView2.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { FlowerTypeContolRule rule = new FlowerTypeContolRule(); gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid数据 /// </summary> private void BindGrid() { VendorRule rule = new VendorRule(); gridView1.GridControl.DataSource = rule.RShow(conditionstr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { string sql = string.Empty;// " AND ItemTypeID=" + SysString.ToDBString((int)EnumItemType.面料); string itemtypestr = "0"; for (int i = 0; i < HTItemTypeIDA.Length; i++) { itemtypestr += ","; itemtypestr += HTItemTypeIDA[i]; } sql = " AND ItemTypeID IN(" + itemtypestr + ")"; if (ItemClassArray != "-1" && ItemClassArray != "") { sql += " AND ItemClassID IN(" + ItemClassArray + ")"; } ItemRule rule = new ItemRule(); DataTable dt = rule.RShowColor(sql + HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag")); for (int i = 0; i < dt.Rows.Count; i++) { if (list.Contains(SysConvert.ToString(dt.Rows[i]["ID"]))) { dt.Rows[i]["SelectFlag"] = 1; } } gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { SaleOrderRule rule = new SaleOrderRule(); DataTable dt = rule.RShow2(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("FormStatusName", "'' FormStatusName").Replace("FaHuoStatusName", "'' FaHuoStatusName")); //SaleOrderStatusProc.ProcColorStatusName(dt); ProFaHuoStatusName(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() { SaleOrderTFabricCompSiteRule rule = new SaleOrderTFabricCompSiteRule(); gridView1.GridControl.DataSource = rule.RShowView(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag")); gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { IOFormRule rule = new IOFormRule(); HTDataConditionStr += "GROUP BY FormNo,"; HTDataConditionStr += "FormDate,ItemCode,DtsOrderFormNo,"; HTDataConditionStr += "WHNM,FormNM,ColorNum,ColorName,MWidth,"; HTDataConditionStr += "MWeight,SinglePrice,ID,ItemName,ItemStd,ItemModel"; DataTable dt = rule.RShowDtsTotal(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("Amount", "SUM(Amount) Amount").Replace("Qty", "SUM(Qty) Qty")); //if (m_DZFlag == 1) //{ // SetDZGridView(dt); //} //if (m_InvoiceFlag == 1) //{ // SetInvoiceGridView(dt); //} for (int i = 0; i < dt.Rows.Count; i++) { if (list.Contains(SysConvert.ToString(dt.Rows[i]["ID"]))) { dt.Rows[i]["SelectFlag"] = 1; } } //SetWHQty(dt); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { //IOFormRule rule = new IOFormRule(); string ConditionAttn = " AND HeadType=" + this.FormListAID; ConditionAttn += " AND SubType in(Select ID FROM Enum_FormList WHERE IsShow=1 )"; //ConditionAttn += " AND WHID in(Select WHID FROM WH_WH WHERE isnull(IsJK,0)=0 )";//2012-2-23caoxg //gridView2.GridControl.DataSource = rule.RShow(ConditionAttn + HTDataConditionStr, ProcessGrid.GetQueryField(gridView2)); //gridView2.GridControl.Show(); IOFormDtsRule rule = new IOFormDtsRule(); //gridView2.GridControl.DataSource = rule.RShow(ConditionAttn + HTDataConditionStr, ProcessGrid.GetQueryField(gridView2)); DataTable dt = rule.RShow(ConditionAttn + HTDataConditionStr, ProcessGrid.GetQueryField(gridView2).Replace("MakeOPName", "''MakeOPName")); ProductMakeOP(dt); gridView2.GridControl.DataSource = dt; gridView2.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> private void BindGridDts() { IOFormDtsRule rule = new IOFormDtsRule(); gridView2.GridControl.DataSource = rule.RShow(HTDataID, ProcessGrid.GetQueryField(gridView2)); gridView2.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { ProductionNoticeRule rule = new ProductionNoticeRule(); gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { CustomRule rule = new CustomRule(); gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.Show(); }
/// <summary> /// 绑定疵点明细 /// </summary> private void BindGrid() { CheckOrderISNFaultRule rule = new CheckOrderISNFaultRule(); gridView1.GridControl.DataSource = rule.RShow(" AND MainID=" + ISNID, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { SampleRule rule = new SampleRule(); gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.Show(); ProcessGrid.SetGridEdit(gridView1, new string[] { "EventStatus" }, true); }
/// <summary> /// 绑定Grid1 /// </summary> public void BindGrid1() { GBJCDtsRule rule = new GBJCDtsRule(); DataTable dtt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.Show(); }
/// <summary> /// 绑定卡片 /// </summary> void BindGridCard() { ItemGBRule rule = new ItemGBRule(); DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("VendorName", "'' VendorName")); cardView1.GridControl.DataSource = dt; cardView1.GridControl.Show(); }
void work_DoWork(object sender, DoWorkEventArgs e) { StorgeAlarmRule rule = new StorgeAlarmRule(); GridView1Table = rule.RShowStorge(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("YCFlag", "0 AS YCFlag")); //IOFormRule rule = new IOFormRule(); //GridView1Table = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { StorgeAlarmRule rule = new StorgeAlarmRule(); DataTable dt = rule.RShowStorge(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("YCFlag", "0 AS YCFlag")); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { PackBoxRule rule = new PackBoxRule(); DataTable dt = rule.RUShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { IOFormDtsISNRule rule = new IOFormDtsISNRule(); gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag")); gridView1.GridControl.Show(); ProcessGrid.SetGridEdit(HTDataList, new string[] { "SelectFlag" }, true); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { GoodsPostRule rule = new GoodsPostRule(); DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SendDes", "'' SendDes")); SetGrid(dt); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { IOFormRule rule = new IOFormRule(); DataTable dt = rule.RShowDtsPack(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SQty", "0.00 SQty")); SetGridView(dt); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { QSRule rule = new QSRule(); DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag")); setDt(dt); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { if (SysConvert.ToString(drpQWHID.EditValue) == "") { this.ShowMessage("请选择仓库"); return; } string FormDateS = "2014-01-01"; string FormDateE = "2222-01-01"; if (chkFormDate.Checked) { FormDateS = txtFormDateS.DateTime.ToString("yyyy-MM-dd"); FormDateE = txtFormDateE.DateTime.ToString("yyyy-MM-dd"); } string sql = string.Empty; sql = "SELECT ID FROM WH_StorgeJS WHERE JSDateS=" + SysString.ToDBString(FormDateS) + " AND JSDateE=" + SysString.ToDBString(FormDateE); sql += " AND JSFlag=1"; DataTable dtJS = SysUtils.Fill(sql); //string sql = "EXEC USP3_WH_InOutStorgeRpt " + SysString.ToDBString(FormDateS) + "," + SysString.ToDBString(FormDateE) + "," + SysString.ToDBString(HTDataConditionStr); //DataTable dt = SysUtils.Fill(sql); //gridView1.GridControl.DataSource = dt; //gridView1.GridControl.Show(); DataTable dt; if (dtJS.Rows.Count != 0)//同样的日期范围有结算数据,直接访问结算数据 { StorgeJSDtsRule rule = new StorgeJSDtsRule(); string conditionStr = " AND MainID=" + SysString.ToDBString(dtJS.Rows[0]["ID"].ToString()); if (!Common.CheckLookUpEditBlank(drpQWHID)) { conditionStr += " AND WHID=" + SysString.ToDBString(SysConvert.ToString(drpQWHID.EditValue)); } conditionStr += GetConditionStr(); dt = rule.RShow(conditionStr, ProcessGrid.GetQueryField(gridView1)); lblQueryDesc.Text = "好快,你查询的可是仓库结算数据哦!!!"; Application.DoEvents(); } else { lblQueryDesc.Text = "数据量较大,查询较慢,请耐心等待。"; Application.DoEvents(); int timeout = SystemConfiguration.DBTimeOut; SystemConfiguration.DBTimeOut = 100000; sql = "EXEC USP3_WH_InOutStorgeRpt " + SysString.ToDBString(SysConvert.ToString(drpQWHID.EditValue)) + "," + SysString.ToDBString(FormDateS) + "," + SysString.ToDBString(FormDateE) + "," + SysString.ToDBString(HTDataConditionStr); dt = SysUtils.Fill(sql); SystemConfiguration.DBTimeOut = timeout; } gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid3 /// </summary> public void BindGrid3() { GBJCDtsRule rule = new GBJCDtsRule(); string ConditionStr = HTDataConditionStr; ConditionStr += " AND GHTime IS NULL AND SubmitFlag=1"; gridView3.GridControl.DataSource = rule.RShow(ConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView3.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { CheckOperationDtsRule rule = new CheckOperationDtsRule(); DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("DZFlagStr", "'' DZFlagStr").Replace("DZRemark", "'' DZRemark").Replace("NoDZQty", "0.00 NoDZQty").Replace("InvoiceFlagStr", "'' InvoiceFlagStr").Replace("InvoiceRemark", "'' InvoiceRemark")); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { ItemTestFormRule rule = new ItemTestFormRule(); DataTable dt = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("UseFlag", "0 UseFlag").Replace("TestItemName", "'' TestItemName")); AddUseFlag(dt); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
private void BindGrid() { if (HTFormStatus != FormStatus.新增 && HTFormStatus != FormStatus.修改) { IOFormRule rule = new IOFormRule(); gridView2.GridControl.DataSource = rule.RShowDts(GetCondition(), ProcessGrid.GetQueryField(gridView2)); gridView2.GridControl.Show(); } }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { SampleSaleRule rule = new SampleSaleRule(); gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.Show(); //ProcessGrid.SetGridEdit(gridView1, new string[] { "FinishedFlag" }, true); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { FabricProcessRule rule = new FabricProcessRule(); DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("OrderStepName", "'' OrderStepName")); ProcDt(dt); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }