private void lbtnCheck_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { try { if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改) { if (drpVendorID.Text.Trim() == "" && txtGoodsCode.Text.Trim() == "") { this.ShowMessage("请输入厂码或商品码后重新检测"); return; } CheckFlag = 1; string sql = "SELECT * FROM Data_Item WHERE VendorID=" + SysString.ToDBString(drpVendorID.Text.Trim()); sql += " AND GoodsCode=" + SysString.ToDBString(txtGoodsCode.Text.Trim()); DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count > 0) { frmLoadMLItem frm = new frmLoadMLItem(); frm.dt = dt; frm.ShowDialog(); if (frm.ID != 0) { this.NavigateWin("frmDevItemGrayEdit", frm.ID.ToString(), FormStatus.查询); } } else { this.ShowMessage("没有检测到相同厂码和商品码的产品,请放心添加"); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 校验是否存在出入库操作 /// </summary> /// <param name="entity"></param> /// <param name="state">状态:0非期初,1期初</param> /// <returns></returns> public bool CheckIOForm(Storge entity) { string sql = "SELECT * FROM UV1_WH_IOFormDts WHERE 1=1"; sql += " AND isnull(ColorNum,'')=" + SysString.ToDBString(entity.ColorNum); sql += " AND isnull(ColorName,'')=" + SysString.ToDBString(entity.ColorName); sql += " AND isnull(Batch,'')=" + SysString.ToDBString(entity.Batch); sql += " AND isnull(VendorBatch,'')=" + SysString.ToDBString(entity.VendorBatch); sql += " AND isnull(JarNum,'')=" + SysString.ToDBString(entity.JarNum); //sql += " AND isnull(SizeName,'')=" + SysString.ToDBString(entity.SizeName); sql += " AND isnull(ItemCode,'')=" + SysString.ToDBString(entity.ItemCode); //sql += " AND isnull(YarnStatus,'')=" + SysString.ToDBString(entity.YarnStatus); //sql += " AND isnull(WHID,'')=" + SysString.ToDBString(entity.WHID); DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count > 0) { return(true); } else { return(false); } }
private void SetGridViewPD(DataTable p_dt) { foreach (DataRow dr in p_dt.Rows) { string sectionid = SysConvert.ToString(dr["SectionID"]); string itemcode = SysConvert.ToString(dr["ItemCode"]); string colornum = SysConvert.ToString(dr["ColorNum"]); string colorname = SysConvert.ToString(dr["ColorName"]); string sql = "SELECT ID FROM UV1_WH_IOFormDts WHERE SubType IN (SELECT ID FROM Enum_FormList WHERE ISNULL(CheckFlag,0)=1) "; sql += " AND ItemCode=" + SysString.ToDBString(itemcode); sql += " AND ColorNum=" + SysString.ToDBString(colornum); sql += " AND ColorName=" + SysString.ToDBString(colorname); sql += " AND ISNULL(SubmitFlag,0)=1 "; DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count > 0) { dr["PD"] = "已盘库"; } else { dr["PD"] = "未盘库"; } } }
private void PrepareArray(ChartStyle style, bool excludeUnknowns, List <StatsItem> vals = null) { if (style != ChartStyle.ClusterBar) { vals = new List <StatsItem>(); int num = fListStats.Items.Count; for (int i = 0; i < num; i++) { ListViewItem item = fListStats.Items[i]; string s = item.Text; double lab = (s == "?") ? 0.0f : SysUtils.ParseFloat(s, 0.0f, true); if (lab != 0.0d || !excludeUnknowns) { int val = int.Parse(item.SubItems[1].Text); vals.Add(new StatsItem(item.Text, val)); } } } fGraph.PrepareArray(fChartTitle, fChartXTitle, fChartYTitle, style, excludeUnknowns, vals); }
/// <summary> /// 显示数据 /// </summary> /// <param name="p_condition"></param> public DataTable RShow(string p_condition, string p_FieldName) { try { if (p_FieldName == string.Empty) { p_FieldName = "*"; } string sql = "SELECT " + p_FieldName + " FROM UV1_Finance_CostRecord WHERE 1=1"; sql += p_condition; sql += " ORDER BY FormNo DESC "; return(SysUtils.Fill(sql)); } catch (BaseException) { throw; } catch (Exception E) { throw new Exception(E.Message); } }
// <summary> /// 处理状态名称 /// </summary> /// <param name="p_time"></param> /// <param name="p_ProcFlag"></param> /// <param name="p_Day"></param> /// <returns></returns> public static string GetGridCellStatusName(DateTime p_time1, DateTime p_time2) { string sql = "Select * from Data_DeviationDts WHERE MainID=" + SysConvert.ToInt32(dt.Rows[0]["DeviationID"]); sql += " ORDER BY Seq Desc"; DataTable dtA = SysUtils.Fill(sql); for (int i = 0; i < dtA.Rows.Count; i++) { if (i == 0 && p_time1.AddDays(SysConvert.ToInt32(dtA.Rows[i]["Num"])) <= p_time2) { return(ColorStatusName[dtA.Rows.Count - 1]); } else if (i == dtA.Rows.Count - 1 && p_time1.AddDays(SysConvert.ToInt32(dtA.Rows[i]["Num"])) >= p_time2) { return(ColorStatusName[1 - 1]); } //else if (p_time1 == p_time2 && SysConvert.ToInt32(dtA.Rows[i]["Num"]) == 0) //{ // return GetGridRowBackColor(dtA.Rows.Count - i); //} else if (p_time1 == p_time2) { return(""); } else if (p_time1 < p_time2 && i != 0 && i != dtA.Rows.Count - 1 && p_time1.AddDays(SysConvert.ToInt32(dtA.Rows[i - 1]["Num"])) > p_time2 && p_time1.AddDays(SysConvert.ToInt32(dtA.Rows[i]["Num"])) <= p_time2) { return(ColorStatusName[dtA.Rows.Count - i - 1]); } else if (p_time1 > p_time2 && i != 0 && i != dtA.Rows.Count - 1 && p_time1.AddDays(SysConvert.ToInt32(dtA.Rows[i]["Num"])) >= p_time2 && p_time1.AddDays(SysConvert.ToInt32(dtA.Rows[i + 1]["Num"])) < p_time2) { return(ColorStatusName[dtA.Rows.Count - i - 1]); } } return(ColorStatusName[0]); }
private void gridViewRowChanged2(object sender) { try { BaseFocusLabel.Focus(); ColumnView view = sender as ColumnView; if (view.FocusedRowHandle >= 0) { if (!SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5810)))//加工模块扣料使用码单模式 { int ID = SysConvert.ToInt32(view.GetRowCellValue(view.FocusedRowHandle, "ID")); string sql = string.Empty; sql = "SELECT ID,SubSeq,0 SelectFlag,BoxNo,Qty,'' ItemModel,'' JarNum FROM WO_FabricWHOutFormDtsPack WHERE DID= " + SysString.ToDBString(ID); DataTable dt = SysUtils.Fill(sql); BindUCFabView(dt); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { try { if (SysConvert.ToString(drpQVendorID.EditValue) == "") { this.ShowMessage("请选择往来单位查询"); return; } decimal TotalQC = 0.0m; decimal TotalInvoiceQC = 0.0m; decimal QCAmount = 0.0m; //期初金额 decimal SQSaleAmount = 0.0m; //销售金额 decimal SQRecAmount = 0.0m; //收款金额 decimal SQInvoiceAmount = 0.0m; decimal SQHKAmount = 0.0m; //期初货款处理 string sql = "Select SUM(BAmount) QCAmount "; sql += " from Finance_BVendorAmount where 1=1"; sql += HTDataConditionStr; DataTable dt3 = SysUtils.Fill(sql); if (dt3.Rows.Count != 0) { QCAmount = SysConvert.ToDecimal(dt3.Rows[0]["QCAmount"]); } sql = "Select SUM(DZAmount) Amount";//对账金额 sql += " from UV1_WH_IOFOrmDts where 1=1"; if (FormListAID == 1) { sql += " AND ISNULL(BuyFlag,0)=1"; } if (FormListAID == 2) { sql += " AND ISNULL(ColorFlag,0)=1"; } if (FormListAID == 3) { sql += " AND ISNULL(SaleFlag,0)=1"; } sql += " AND ISNULL(SubmitFlag,0)=1"; //已提交 sql += " AND ISNULL(DZFlag,0)=1"; //只查询对过帐的数据 sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND formdate <" + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")); } DataTable dt1 = SysUtils.Fill(sql); if (dt1.Rows.Count != 0) { SQSaleAmount = SysConvert.ToDecimal(dt1.Rows[0]["Amount"]); } sql = " Select SUM(TotalAmount) InvoiceAmount"; sql += " from Finance_InvoiceOperation where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND MakeDate< " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")); } dt1 = SysUtils.Fill(sql); if (dt1.Rows.Count != 0) { SQInvoiceAmount = SysConvert.ToDecimal(dt1.Rows[0]["InvoiceAmount"]); } sql = "Select Sum(ExAmount) RecAmount"; sql += " from Finance_RecPay where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND ExDate< " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")); } DataTable dt2 = SysUtils.Fill(sql); if (dt2.Rows.Count != 0) { SQRecAmount = SysConvert.ToDecimal(dt2.Rows[0]["RecAmount"]); } ///货款处理信息 sql = " Select SUM(Amount) ExAmount"; sql += " from Finance_PaymentHandle where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND FormDate< " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")); } dt2 = SysUtils.Fill(sql); if (dt2.Rows.Count != 0) { SQHKAmount = SysConvert.ToDecimal(dt2.Rows[0]["ExAmount"]); } TotalQC = QCAmount + SQSaleAmount - SQRecAmount - SQHKAmount; TotalInvoiceQC = QCAmount + SQSaleAmount - SQInvoiceAmount; //sql = "Select ID,Seq,WHNM,FormDate,'销售' AS FormTypeName,ItemCode,ItemName,ItemStd,ItemModel,Unit,Qty,SinglePrice,DZAmount Amount,0.0 RecAmount,0.0 LeftAmount1,0.0 LeftAmount2";//对账金额 //sql += " from UV1_WH_IOFOrmDts where 1=1"; #region FormListAID ==1 if (FormListAID == 1) { sql = "Select ID,Seq,WHNM,FormDate,'采购' AS FormTypeName,ItemCode,ItemName,ItemStd,ItemModel,Unit,'' Remark,Qty,DZSinglePrice AS SinglePrice,"; //sql += " Amount= Case when ISNULL(DZAmount,0)=0 then Amount"; //sql += " When ISNULL(DZAmount,0)<>0 then DZAmount end"; sql += " DZAmount Amount"; sql += " ,0.0 RecAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";//对账金额 sql += " from UV1_WH_IOFOrmDts where 1=1"; sql += " AND ISNULL(BuyFlag,0)=1"; sql += " AND ISNULL(SubmitFlag,0)=1"; //已提交 sql += " AND ISNULL(DZFlag,0)=1"; //只查询对过帐的数据 sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } sql += " UNION"; sql += " Select ID,1 AS Seq,'' WHNM,ExDate ASFormDate,'付款' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,Remark AS ItemModel,'' Unit,"; sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,ExAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,"; sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3"; sql += " from Finance_RecPay where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND ExDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } sql += " UNION"; sql += " Select ID,1 AS Seq,'' WHNM,MakeDate AS FormDate,'开票' AS FormTypeName,InvoiceNo ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,"; sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,TotalAmount InvoiceAmount,0.0 PaymentHandleAmount,"; sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3"; sql += " from Finance_InvoiceOperation where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND MakeDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } ///货款信息 sql += " UNION"; sql += " Select ID,1 AS Seq,'' WHNM, FormDate,'货款处理' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,"; sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,0.0 InvoiceAmount,Amount PaymentHandleAmount,"; sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3"; sql += " from Finance_PaymentHandle where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } //sql += " Order BY FormDate"; } #endregion #region FormListAID ==2 if (FormListAID == 2) { sql = "Select ID,Seq,WHNM,FormDate,'加工' AS FormTypeName,ItemCode,ItemName,ItemStd,ItemModel,Unit,'' Remark,Qty,DZSinglePrice AS SinglePrice,"; //sql += " Amount= Case when ISNULL(DZAmount,0)=0 then Amount"; //sql += " When ISNULL(DZAmount,0)<>0 then DZAmount end"; sql += " DZAmount Amount"; sql += " ,0.0 RecAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";//对账金额 sql += " from UV1_WH_IOFOrmDts where 1=1"; sql += " AND ISNULL(ColorFlag,0)=1"; sql += " AND ISNULL(SubmitFlag,0)=1"; //已提交 sql += " AND ISNULL(DZFlag,0)=1"; //只查询对过帐的数据 sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } sql += " UNION"; sql += " Select ID,1 AS Seq,'' WHNM,ExDate ASFormDate,'付款' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,Remark AS ItemModel,'' Unit,"; sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,ExAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,"; sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3"; sql += " from Finance_RecPay where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND ExDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } sql += " UNION"; sql += " Select ID,1 AS Seq,'' WHNM,MakeDate AS FormDate,'开票' AS FormTypeName,InvoiceNo ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,"; sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,TotalAmount InvoiceAmount,0.0 PaymentHandleAmount,"; sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3"; sql += " from Finance_InvoiceOperation where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND MakeDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } ///货款信息 sql += " UNION"; sql += " Select ID,1 AS Seq,'' WHNM, FormDate,'货款处理' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,"; sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,0.0 InvoiceAmount,Amount PaymentHandleAmount,"; sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3"; sql += " from Finance_PaymentHandle where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } // sql += " Order BY FormDate"; } #endregion #region FormListAID ==3 if (FormListAID == 3) { //替换之前的CompanyTypeName //sql = "Select ID,Seq,WHNM,FormDate,'销售' AS FormTypeName,ItemCode,ItemName,ItemStd,ItemModel,Unit,Qty,SinglePrice,Amount,0.0 RecAmount,0.0 LeftAmount1,0.0 LeftAmount2";//对账金额 //sql += " from UV1_WH_IOFOrmDts where 1=1"; //sql += " AND ISNULL(SaleFlag,0)=1"; //sql += " AND ISNULL(SubmitFlag,0)=1";//已提交 if (this.FormListBID == 1) { sql = "Select distinct(ID),1 Seq,WHNM,FormDate,"; sql += " FormTypeName= Case when FormDZFlag=1 then '销售'"; sql += "When FormDZFlag=2 then '退货' end ,ItemCode,ItemName,ItemStd,ItemModel,Unit,"; sql += "' 合同号:'"; sql += "+DtsOrderFormNo+"; sql += "' 开票金额:'+CONVERT(nvarchar(50),InvoiceAmount) Remark,DZQty Qty,DZSinglePrice as SinglePrice,"; sql += "Amount= Case When FormDZFlag=1 AND ISNULL(DZAmount,0)<>0 then DZAmount "; sql += "When FormDZFlag=2 AND ISNULL(DZAmount,0)<>0 then 0-DZAmount "; sql += "end ,0.0 RecAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3"; sql += " from UV1_WH_IOFOrmDts2 where 1=1"; sql += "AND ISNULL(SaleFlag,0)=1"; sql += "AND ISNULL(SubmitFlag,0)=1"; sql += "AND ISNULL(DZFlag,0)=1"; } else { sql = "Select ID,Seq,WHNM,FormDate,"; sql += " FormTypeName= Case when FormDZFlag=1 then '销售'"; sql += " When FormDZFlag=2 then '退货' end"; sql += " ,ItemCode,ItemName,ItemStd,ItemModel,Unit,"; sql += " '发票号:'+DtsInvoiceNo+' 合同号:'+DtsOrderFormNo+' 开票日期:'+CONVERT(nvarchar(50), DtsInvoiceDelTime,102 )+' 开票金额:'+CONVERT(nvarchar(50),InvoiceAmount) Remark,";//备注显示发票号、发票金额 sql += " Qty,DZSinglePrice as SinglePrice,"; //sql += " Amount= Case when FormDZFlag=1 AND ISNULL(DZAmount,0)=0 then Amount"; //sql += " When FormDZFlag=2 AND ISNULL(DZAmount,0)=0 then 0-Amount "; //sql += " When FormDZFlag=1 AND ISNULL(DZAmount,0)<>0 then DZAmount "; //sql += " When FormDZFlag=2 AND ISNULL(DZAmount,0)<>0 then 0-DZAmount "; //sql+=" end"; sql += " Amount= Case When FormDZFlag=1 AND ISNULL(DZAmount,0)<>0 then DZAmount "; sql += " When FormDZFlag=2 AND ISNULL(DZAmount,0)<>0 then 0-DZAmount "; sql += " end"; sql += " ,0.0 RecAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3";//对账金额 sql += " from UV1_WH_IOFOrmDts where 1=1"; sql += " AND ISNULL(SaleFlag,0)=1"; sql += " AND ISNULL(SubmitFlag,0)=1"; //已提交 sql += " AND ISNULL(DZFlag,0)=1"; //只查询对过帐的数据 } sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } sql += " UNION"; sql += " Select ID,1 AS Seq,'' WHNM,ExDate AS FormDate,'收款' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,Remark AS ItemModel,'' Unit,"; sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,ExAmount,0.0 InvoiceAmount,0.0 PaymentHandleAmount,"; sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3"; sql += " from Finance_RecPay where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND ExDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } ///开票信息 sql += " UNION"; sql += " Select ID,1 AS Seq,'' WHNM,MakeDate AS FormDate,'开票' AS FormTypeName,InvoiceNo ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,"; sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,TotalAmount InvoiceAmount,0.0 PaymentHandleAmount,"; sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3"; sql += " from Finance_InvoiceOperation where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND MakeDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } ///货款信息 sql += " UNION"; sql += " Select ID,1 AS Seq,'' WHNM, FormDate,'货款处理' AS FormTypeName,'' ItemCode,'' ItemName,'' ItemStd,'' ItemModel,'' Unit,"; sql += " '' Remark,0.0 Qty,0.0 SinglePrice,0.0 Amount,0.0 ExAmount,0.0 InvoiceAmount,Amount PaymentHandleAmount,"; sql += " 0.0 LeftAmount1,0.0 LeftAmount2,0.0 LeftAmount3"; sql += " from Finance_PaymentHandle where 1=1"; sql += HTDataConditionStr; if (chkINDate.Checked) { sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtQIndateS.DateTime.ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(txtQIndateE.DateTime.ToString("yyyy-MM-dd") + " 23:59:59"); } //sql += " Order BY FormDate"; } #endregion DataTable dt = SysUtils.Fill(sql); DataRow dr = dt.NewRow(); if (TotalQC >= 0) { dr["LeftAmount1"] = TotalQC; } else { dr["LeftAmount2"] = 0 - TotalQC; } dr["LeftAmount3"] = TotalInvoiceQC;; //dr["LeftAmount"] = TotalQC; dr["FormTypeName"] = "期初余额"; dr["FormDate"] = txtQIndateS.DateTime.Date.AddDays(-1); dr["ID"] = "-1"; dr["Seq"] = "-1"; dt.Rows.Add(dr); //dt.DefaultView.Sort = " FormDate ASC"; DataRow[] rows = dt.Select("", "FormDate asc"); DataTable t = dt.Clone(); t.Clear(); foreach (DataRow row in rows) { t.ImportRow(row); } dt = t; ProductAmount(dt); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); gridView1.OptionsCustomization.AllowFilter = false; gridView1.OptionsCustomization.AllowSort = false; } catch (Exception E) { this.ShowMessage(E.Message); } }
private PersonNameRet DefinePersonName(string str) { string f_name = ""; string f_pat = ""; string f_fam = ""; string bd = ""; string dd = ""; string tmp = str; string dates = ""; if (SpecialFormat_1) { int ob_pos = tmp.IndexOf("(*"); if (ob_pos >= 0) { int cb_pos = tmp.IndexOf(")", ob_pos); if (cb_pos > ob_pos) { dates = tmp.Substring(ob_pos + 1, cb_pos - ob_pos - 1).Trim(); tmp = tmp.Remove(ob_pos, dates.Length + 2); } } } // if not Special or SpecialNotFound, then classic if (string.IsNullOrEmpty(dates)) { int bd_pos = tmp.IndexOf(ImportUtils.STD_BIRTH_SIGN); int dd_pos = tmp.IndexOf(ImportUtils.STD_DEATH_SIGN); int datesPos = -1; if (bd_pos >= 0 && (dd_pos < 0 || dd_pos > bd_pos)) { datesPos = bd_pos; } else { datesPos = dd_pos; } if (datesPos >= 0) { dates = tmp.Substring(datesPos, tmp.Length - datesPos); tmp = tmp.Remove(datesPos, dates.Length).Trim(); // can be blanks at end } } // parse dates line if (!string.IsNullOrEmpty(dates)) { int b_pos = dates.IndexOf(ImportUtils.STD_BIRTH_SIGN); int d_pos = dates.IndexOf(ImportUtils.STD_DEATH_SIGN); if (d_pos >= 0 && d_pos > b_pos) { dd = dates.Substring(d_pos + 1, dates.Length - d_pos - 1); dates = dates.Remove(d_pos, dd.Length + 1); dates = dates.Trim(); } if (b_pos >= 0) { bd = dates.Substring(b_pos + 1, dates.Length - b_pos - 1); dates = dates.Remove(b_pos, bd.Length + 1); dates = dates.Trim(); } bd = RemoveDot(bd); dd = RemoveDot(dd); } tmp = RemoveCommaDot(tmp); // &Trim() string[] tokens = tmp.Split(new char[] { ' ' }, 3); switch (NameFormat) { case NameFormat.nfIOF: if (tokens.Length > 0) { f_name = RemoveDot(tokens[0]); } if (tokens.Length > 1) { f_pat = RemoveDot(tokens[1]); } if (tokens.Length > 2) { f_fam = RemoveDot(tokens[2]); } break; case NameFormat.nfFIO: if (tokens.Length > 0) { f_fam = RemoveDot(tokens[0]); } if (tokens.Length > 1) { f_name = RemoveDot(tokens[1]); } if (tokens.Length > 2) { f_pat = RemoveDot(tokens[2]); } break; } if (SurnamesNormalize) { f_fam = SysUtils.NormalizeName(f_fam); } return(new PersonNameRet(f_name, f_pat, f_fam, bd, dd)); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { string sql = "SELECT '采购' KPName,* FROM UV1_WH_IOFormDts WHERE 1=1"; sql += " AND SubmitFlag=1"; sql += " AND SubType IN(SELECT ID FROM Enum_FormList WHERE DZFlag=" + (int)EnumDZFlag.对帐正 + ")"; sql += " AND VendorID=" + SysString.ToDBString(m_VendorID); sql += " AND FormDate BETWEEN " + SysString.ToDBString(m_Makedates) + " AND " + SysString.ToDBString(m_Makedatee); sql += " AND DtsID NOT IN(SELECT ISNULL(DLOADDtsID,0) FROM UV1_Finance_InvoiceOperationDts WHERE SubmitFlag=1)"; DataTable dt3 = SysUtils.Fill(sql); foreach (DataRow dr in dt3.Rows) { dr["Qty"] = SysConvert.ToDecimal(dr["Qty"]) + SysConvert.ToDecimal(dr["YQQty"]); dr["Amount"] = SysConvert.ToDecimal(dr["Qty"]) * SysConvert.ToDecimal(dr["SinglePrice"]); } sql = "SELECT * FROM UV1_WH_IOFormDts WHERE 1=1"; sql += " AND SubmitFlag=1"; sql += " AND SubType IN(SELECT ID FROM Enum_FormList WHERE DZFlag=" + (int)EnumDZFlag.对帐负 + ")"; sql += " AND VendorID=" + SysString.ToDBString(m_VendorID); sql += " AND FormDate BETWEEN " + SysString.ToDBString(m_Makedates) + " AND " + SysString.ToDBString(m_Makedatee); sql += " AND DtsID NOT IN(SELECT ISNULL(DLOADDtsID,0) FROM UV1_Finance_InvoiceOperationDts WHERE SubmitFlag=1)"; DataTable dt4 = SysUtils.Fill(sql); for (int i = 0; i < dt4.Rows.Count; i++) { DataRow dr = dt3.NewRow(); dr["KPName"] = "采购退货"; dr["FormDate"] = dt4.Rows[i]["FormDate"]; dr["ItemCode"] = dt4.Rows[i]["ItemCode"]; dr["SinglePrice"] = dt4.Rows[i]["SinglePrice"]; dr["GoodsCode"] = dt4.Rows[i]["GoodsCode"]; dr["Qty"] = 0 - SysConvert.ToDecimal(dt4.Rows[i]["Qty"]) - SysConvert.ToDecimal(dt4.Rows[i]["YQQty"]); dr["Amount"] = SysConvert.ToDecimal(dr["Qty"]) * SysConvert.ToDecimal(dr["SinglePrice"]); dt3.Rows.Add(dr); } sql = "SELECT KPName,MakeDate,ItemCode,GoodsCode,Qty,Amount,SinglePrice from UV1_Finance_InvoiceYOperationDts WHERE SubmitFlag=1 "; sql += " AND KPType=" + (int)EnumKPType.预开票; sql += " AND VendorID=" + SysString.ToDBString(m_VendorID); sql += " AND MakeDate BETWEEN " + SysString.ToDBString(m_Makedates) + " AND " + SysString.ToDBString(m_Makedatee); sql += " AND DtsID NOT IN (SELECT ISNULL(DLOADID,0) FROM UV2_Finance_InvoiceOperationDts WHERE DLOADNO='预开票')"; DataTable dt5 = SysUtils.Fill(sql); for (int j = 0; j < dt5.Rows.Count; j++) { DataRow dr = dt3.NewRow(); dr["KPName"] = "预开票"; dr["FormDate"] = dt5.Rows[j]["MakeDate"]; dr["ItemCode"] = dt5.Rows[j]["ItemCode"]; dr["GoodsCode"] = dt5.Rows[j]["GoodsCode"]; dr["SinglePrice"] = dt5.Rows[j]["SinglePrice"]; dr["Qty"] = 0 - SysConvert.ToDecimal(dt5.Rows[j]["Qty"]); dr["Amount"] = 0 - SysConvert.ToDecimal(dt5.Rows[j]["Amount"]); dt3.Rows.Add(dr); } DataView dv = dt3.DefaultView; dv.Sort = "FormDate Asc"; DataTable dto = dv.ToTable(); gridView1.GridControl.DataSource = dto; gridView1.GridControl.Show(); }
/// <summary> /// Handles when a job from a task requires processing. /// Note that all tasks/jobs in the queue use the same task type ID, /// so the directive <see cref="BackgroundOperationTaskQueueDirective.BackgroundOperationName"/> /// is used to identify which tasks should be executed by /// which background operation. /// </summary> /// <param name="job">The job to process.</param> protected virtual void ProcessJobHandler(TaskProcessorJob job) { // Sanity. if (null == job) { return; } // Ensure cancellation has not been requested. job.ThrowIfCancellationRequested(); // What is the current state? var state = job.AppTaskState; // Update the progress of the task in the task queue. try { this.TaskProcessor.UpdateTaskAsAssignedToProcessor(job); } catch { // Could not mark the task as assigned to a processor. SysUtils.ReportToEventLog ( $"Could not mark task {job.AppTaskId} as assigned to a processor (queue id: {job.AppTaskQueueId}, state: {state}).", System.Diagnostics.EventLogEntryType.Warning ); return; } // Sanity. if (null == job.Data?.Value) { // This is an issue. We have no way to decide what background operation should run it. Die. SysUtils.ReportErrorToEventLog ( $"Job loaded with no application task (queue: {job.AppTaskQueueId}, task id: {job.AppTaskId})." ); return; } // Deserialize the background directive. var backgroundOperationDirective = job.GetTaskQueueDirective <BackgroundOperationTaskQueueDirective>(); if (null == backgroundOperationDirective) { // This is an issue. We have no way to decide what background operation should run it. Die. SysUtils.ReportErrorToEventLog ( $"Job loaded with no background operation name loaded (queue: {job.AppTaskQueueId}, task id: {job.AppTaskId})." ); return; } // If we have a directive then extract it. var dir = backgroundOperationDirective.GetParsedInternalDirective(); // If it is a broadcast directive, then was it generated on the same server? // If so then ignore. if (dir is BroadcastDirective broadcastDirective) { if (broadcastDirective.GeneratedFromGuid == TaskQueueBackgroundOperationManager.CurrentServer.ServerID) { return; } } // Find the background operation to run. TaskQueueBackgroundOperationOverview bo = null; lock (_lock) { if (false == this.BackgroundOperations.TryGetValue(backgroundOperationDirective.BackgroundOperationName, out bo)) { // We have no registered background operation to handle the callback. SysUtils.ReportErrorToEventLog ( $"No background operation found with name {backgroundOperationDirective.BackgroundOperationName}(queue: {job.AppTaskQueueId}, task id: {job.AppTaskId})." ); return; } } // Should we repeat? DateTime?nextRun = null; switch (bo.BackgroundOperation.RepeatType) { case TaskQueueBackgroundOperationRepeatType.Interval: // Add the interval to the current datetime. if (bo.BackgroundOperation.Interval.HasValue) { nextRun = DateTime.UtcNow.Add(bo.BackgroundOperation.Interval.Value); } break; case TaskQueueBackgroundOperationRepeatType.Schedule: // Get the next execution time from the schedule. nextRun = bo.BackgroundOperation.Schedule?.GetNextExecution(DateTime.Now); break; } // If we have a next run time then re-run. if (null != nextRun) { // Bind to the completed event ( called always ) of the job. // That way even if the job is canceled, fails, or finishes successfully // ...we always schedule the next run. job.ProcessingCompleted += (s, op) => { // Ensure that if two threads both run this at once we don't end up with a race condition. lock (_lock) { // Cancel any future executions (we only want the single one created below). this.CancelFutureExecutions(bo.BackgroundOperation.Name); // Now schedule it to run according to the interval. this.RunOnce ( bo.BackgroundOperation.Name, nextRun.Value.ToUniversalTime(), dir ); } }; } // Perform the action. try { // Mark the background operation as running. bo.Status = TaskQueueBackgroundOperationStatus.Running; bo.LastRun = DateTime.UtcNow; // Delegate to the background operation. bo.BackgroundOperation.RunJob(job, dir); } catch (Exception e) { // Exception. this.TaskProcessor.UpdateTaskInfo ( job.Data?.Value, MFTaskState.MFTaskStateFailed, e.Message, false ); // TODO: throw? } finally { // If the status is running then stop it. if (bo.Status == TaskQueueBackgroundOperationStatus.Running) { bo.Status = TaskQueueBackgroundOperationStatus.Stopped; } } }
/// <summary> ///通用 重新设置实体 /// /// </summary> public override void gridViewRowChanged1(object sender) { try { this.BaseFocusLabel.Focus(); ColumnView view = sender as ColumnView; string WHID = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "WHID")); string SBitID = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "SBitID")); string ItemCode = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "ItemCode")); string ColorNum = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "ColorNum")); string ColorName = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "ColorName")); string Batch = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "Batch")); string VendorBatch = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "VendorBatch")); string VendorID = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "VendorID")); string SectionID = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "SectionID")); string JarNum = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "JarNum")); string DtsSO = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "SO")); string ItemUnit = SysConvert.ToString(view.GetRowCellValue(view.FocusedRowHandle, "Unit")); decimal MWidth = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "MWidth")); decimal MWeight = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "MWeight")); #region 查找仓库结算类型 string sql = "SELECT FieldName FROM UV1_WH_WH WHERE WHID=" + SysString.ToDBString(WHID);//获得仓库结算类型字段 DataTable dt = SysUtils.Fill(sql); string FieldNamestr = string.Empty; if (dt.Rows.Count != 0) { FieldNamestr += SysConvert.ToString(dt.Rows[0]["FieldName"]); } #endregion sql = "SELECT * FROM UV1_WH_PackBox WHERE 1=1"; sql += " AND WHID=" + SysString.ToDBString(WHID); sql += " AND SectionID=" + SysString.ToDBString(SectionID); sql += " AND SBitID=" + SysString.ToDBString(SBitID); int CalFieldName = (int)WHCalMethodFieldName.ItemCode; if (FieldNamestr != string.Empty) { string[] FieldName = FieldNamestr.Split('+'); for (int i = 0; i < FieldName.Length; i++) { string sqlFieldName = "SELECT ID FROM Enum_WHCalMethodFieldName WHERE Name=" + SysString.ToDBString(FieldName[i]);//找到库存结算字段对应的ID DataTable dtFieldName = SysUtils.Fill(sqlFieldName); if (dtFieldName.Rows.Count != 0 && dtFieldName.Rows[0]["ID"].ToString() != "") { CalFieldName = SysConvert.ToInt32(dtFieldName.Rows[0]["ID"]); } switch (CalFieldName) { case (int)WHCalMethodFieldName.ItemCode: //产品编码 sql += " AND ISNULL(ItemCode,'')=" + SysString.ToDBString(ItemCode); break; case (int)WHCalMethodFieldName.ColorNum: //色号 sql += " AND ISNULL(ColorNum,'')=" + SysString.ToDBString(ColorNum); break; case (int)WHCalMethodFieldName.ColorName: //颜色 sql += " AND ISNULL(ColorName,'')=" + SysString.ToDBString(ColorName); break; case (int)WHCalMethodFieldName.Batch: //批号 sql += " AND ISNULL(Batch,'')=" + SysString.ToDBString(Batch); break; case (int)WHCalMethodFieldName.VendorBatch: //客户批号 sql += " AND ISNULL(VendorBatch,'')=" + SysString.ToDBString(VendorBatch); break; case (int)WHCalMethodFieldName.VendorID: //客户 sql += " AND ISNULL(DtsVendorID,'')=" + SysString.ToDBString(VendorID); break; case (int)WHCalMethodFieldName.JarNum: //缸号 sql += " AND ISNULL(JarNum,'')=" + SysString.ToDBString(JarNum); break; case (int)WHCalMethodFieldName.Unit: //缸号 sql += " AND ISNULL(Unit,'')=" + SysString.ToDBString(ItemUnit); break; case (int)WHCalMethodFieldName.MWidth: //门幅 sql += " AND ISNULL(MWidth,0)=" + SysString.ToDBString(MWidth); break; case (int)WHCalMethodFieldName.MWeight: //克重 sql += " AND ISNULL(MWeight,0)=" + SysString.ToDBString(MWeight); break; default: throw new Exception("结算异常,结算定义的字段底层未对应:" + CalFieldName + ",请联系管理员"); } } } sql += " AND BoxStatusID=" + SysString.ToDBString((int)EnumBoxStatus.入库); sql += " AND ISNULL(Qty,0)>0"; DataTable dt1 = SysUtils.Fill(sql); gridView2.GridControl.DataSource = dt1; gridView2.GridControl.Show(); gridView2.Columns["ReHandle"].OptionsColumn.AllowEdit = true; gridView2.Columns["ReHandle"].OptionsColumn.ReadOnly = false; gridView2.Columns["SplitColor"].OptionsColumn.AllowEdit = true; gridView2.Columns["SplitColor"].OptionsColumn.ReadOnly = false; gridView2.Columns["MiddleDiff"].OptionsColumn.AllowEdit = true; gridView2.Columns["MiddleDiff"].OptionsColumn.ReadOnly = false; gridView2.Columns["HeadTailDiff"].OptionsColumn.AllowEdit = true; gridView2.Columns["HeadTailDiff"].OptionsColumn.ReadOnly = false; } catch (Exception E) { this.ShowMessage(E.Message); } }
public void PrepareArray(string title, string xAxis, string yAxis, ChartStyle style, bool excludeUnknowns, List <StatsItem> vals) { GraphPane gPane = fGraph.GraphPane; try { gPane.CurveList.Clear(); gPane.Title.Text = title; gPane.XAxis.Title.Text = xAxis; gPane.YAxis.Title.Text = yAxis; if (style != ChartStyle.ClusterBar) { PointPairList ppList = new PointPairList(); int num = vals.Count; for (int i = 0; i < num; i++) { StatsItem item = vals[i]; string s = item.Caption; double lab = (s == "?") ? 0.0f : SysUtils.ParseFloat(s, 0.0f, true); if (lab != 0.0d || !excludeUnknowns) { ppList.Add(lab, item.Value); } } ppList.Sort(); switch (style) { case ChartStyle.Bar: gPane.AddBar("-", ppList, Color.Green); break; case ChartStyle.Point: gPane.AddCurve("-", ppList, Color.Green, SymbolType.Diamond).Symbol.Size = 3; break; } } else { gPane.CurveList.Clear(); int itemscount = vals.Count; double[] yValuesF = new double[itemscount]; double[] yValuesM = new double[itemscount]; double[] xValues = new double[itemscount]; for (int i = 0; i < itemscount; i++) { StatsItem sti = vals[i]; xValues[i] = SysUtils.ParseInt(sti.Caption, 0); yValuesF[i] = sti.ValF; yValuesM[i] = sti.ValM; } gPane.AddBar("F", xValues, yValuesF, Color.Red); gPane.AddBar("M", xValues, yValuesM, Color.Blue); gPane.BarSettings.MinBarGap = 0.0f; gPane.BarSettings.MinClusterGap = 2.5f; // expand the range of the Y axis slightly to accommodate the labels //gPane.YAxis.Scale.Max += gPane.YAxis.Scale.MajorStep; // Create TextObj's to provide labels for each bar BarItem.CreateBarLabels(gPane, false, "f0"); } } finally { fGraph.AxisChange(); fGraph.Invalidate(); } }
private void drpVendorID_EditValueChanged(object sender, EventArgs e) { try { if (SysConvert.ToString(drpVendorID.EditValue) != string.Empty) { string sql = "SELECT * FROM Data_Vendor WHERE VendorID=" + SysString.ToDBString(SysConvert.ToString(drpVendorID.EditValue)); DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count > 0) { txtContact1.Text = SysConvert.ToString(dt.Rows[0]["Contact"]); txtTel1.Text = SysConvert.ToString(dt.Rows[0]["Tel"]); txtFax1.Text = SysConvert.ToString(dt.Rows[0]["Fax"]); txtAddress.Text = SysConvert.ToString(dt.Rows[0]["Address"]); drpSaleOP.EditValue = SysConvert.ToString(dt.Rows[0]["InSaleOP"]); txtCHBrand.Text = SysConvert.ToString(dt.Rows[0]["CHBrand"]); txtENBrand.Text = SysConvert.ToString(dt.Rows[0]["ENBrand"]); txtMPrice1.Text = SysConvert.ToString(dt.Rows[0]["MPrice1"]); txtMPrice2.Text = SysConvert.ToString(dt.Rows[0]["MPrice2"]); txtMPrice3.Text = SysConvert.ToString(dt.Rows[0]["MPrice3"]); txtMPrice4.Text = SysConvert.ToString(dt.Rows[0]["MPrice4"]); txtage1.Text = SysConvert.ToString(dt.Rows[0]["age1"]); txtage2.Text = SysConvert.ToString(dt.Rows[0]["age2"]); txtSJFG.Text = SysConvert.ToString(dt.Rows[0]["SJFG"]); if (SysConvert.ToInt32(dt.Rows[0]["PF"]) == 1) { chkPF.Checked = true; } else { chkPF.Checked = false; } if (SysConvert.ToInt32(dt.Rows[0]["DL"]) == 1) { chkDL.Checked = true; } else { chkDL.Checked = false; } if (SysConvert.ToInt32(dt.Rows[0]["ZY"]) == 1) { chkZY.Checked = true; } else { chkZY.Checked = false; } gridView1.SetRowCellValue(0, "Address", SysConvert.ToString(dt.Rows[0]["MainSale"])); } sql = "SELECT * FROM Data_VendorNews WHERE MainID IN (SELECT ID FROM Data_Vendor WHERE VendorID=" + SysString.ToDBString(SysConvert.ToString(drpVendorID.EditValue)) + ")"; dt = SysUtils.Fill(sql); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { gridView1.SetRowCellValue(i, "Item", SysConvert.ToString(dt.Rows[i]["Item"])); gridView1.SetRowCellValue(i, "ItemPrice", SysConvert.ToString(dt.Rows[i]["ItemPrice"])); } } } } catch (Exception E) { this.ShowMessage(E.Message); } }
private void ProcDataTable(DataTable p_dt) { foreach (DataRow dr in p_dt.Rows) { string WHID = SysConvert.ToString(dr["WHID"]); string SectionID = SysConvert.ToString(dr["SectionID"]); string ItemCode = SysConvert.ToString(dr["ItemCode"]); string ColorNum = SysConvert.ToString(dr["ColorNum"]); string ColorName = SysConvert.ToString(dr["ColorName"]); string GoodsCode = SysConvert.ToString(dr["GoodsCode"]); string Batch = SysConvert.ToString(dr["Batch"]); decimal MWidth = SysConvert.ToDecimal(dr["MWidth"]); decimal MWeight = SysConvert.ToDecimal(dr["MWeight"]); string VendorID = SysConvert.ToString(dr["VendorID"]); string GoodsLevel = SysConvert.ToString(dr["GoodsLevel"]); string VendorBatch = SysConvert.ToString(dr["VendorBatch"]); string JarNum = SysConvert.ToString(dr["JarNum"]); string ItemUnit = SysConvert.ToString(dr["Unit"]); decimal PieceQty = SysConvert.ToDecimal(dr["PieceQty"]); decimal Qty = SysConvert.ToDecimal(dr["Qty"]); #region 查找仓库结算类型 string sql = "SELECT FieldName FROM UV1_WH_WH WHERE WHID=" + SysString.ToDBString(WHID);//获得仓库结算类型字段 DataTable dt = SysUtils.Fill(sql); string FieldNamestr = string.Empty; if (dt.Rows.Count != 0) { FieldNamestr += SysConvert.ToString(dt.Rows[0]["FieldName"]); } #endregion int PackPieceQty = 0; decimal PackQty = 0.0m; sql = "SELECT * FROM WH_PackBox WHERE 1=1"; sql += " AND WHID =" + SysString.ToDBString(WHID); sql += " AND SectionID = " + SysString.ToDBString(SectionID); int CalFieldName = (int)WHCalMethodFieldName.ItemCode; if (FieldNamestr != string.Empty) { string[] FieldName = FieldNamestr.Split('+'); for (int i = 0; i < FieldName.Length; i++) { string sqlFieldName = "SELECT ID FROM Enum_WHCalMethodFieldName WHERE Name=" + SysString.ToDBString(FieldName[i]);//找到库存结算字段对应的ID DataTable dtFieldName = SysUtils.Fill(sqlFieldName); if (dtFieldName.Rows.Count != 0 && dtFieldName.Rows[0]["ID"].ToString() != "") { CalFieldName = SysConvert.ToInt32(dtFieldName.Rows[0]["ID"]); } switch (CalFieldName) { case (int)WHCalMethodFieldName.WHID: //库 上方已处理 break; case (int)WHCalMethodFieldName.SectionID: //区 break; case (int)WHCalMethodFieldName.SBitID: //位 break; case (int)WHCalMethodFieldName.ItemCode: //产品编码 sql += " AND ISNULL(ItemCode,'')=" + SysString.ToDBString(ItemCode); break; case (int)WHCalMethodFieldName.JarNum: //缸号 sql += " AND ISNULL(JarNum,'')=" + SysString.ToDBString(JarNum); break; case (int)WHCalMethodFieldName.ColorNum: //色号 sql += " AND ISNULL(ColorNum,'')=" + SysString.ToDBString(ColorNum); break; case (int)WHCalMethodFieldName.ColorName: //颜色 sql += " AND ISNULL(ColorName,'')=" + SysString.ToDBString(ColorName); break; case (int)WHCalMethodFieldName.MWidth: //门幅 sql += " AND ISNULL(MWidth,0)=" + SysString.ToDBString(MWidth); break; case (int)WHCalMethodFieldName.MWeight: //克重 sql += " AND ISNULL(MWeight,0)=" + SysString.ToDBString(MWeight); break; case (int)WHCalMethodFieldName.VendorID: //客户 sql += " AND ISNULL(VendorID,'')=" + SysString.ToDBString(VendorID); break; case (int)WHCalMethodFieldName.GoodsCode: //商品码 sql += " AND ISNULL(GoodsCode,'')=" + SysString.ToDBString(GoodsCode); break; case (int)WHCalMethodFieldName.GoodsLevel: //等级 sql += " AND ISNULL(GoodsLevel,'')=" + SysString.ToDBString(GoodsLevel); break; case (int)WHCalMethodFieldName.Batch: //批号 sql += " AND ISNULL(Batch,'')=" + SysString.ToDBString(Batch); break; case (int)WHCalMethodFieldName.Unit: //单位 sql += " AND ISNULL(Unit,'')=" + SysString.ToDBString(ItemUnit); break; case (int)WHCalMethodFieldName.VendorBatch: //客户批号 sql += " AND ISNULL(VendorBatch,'')=" + SysString.ToDBString(VendorBatch); break; default: throw new Exception("结算异常,结算定义的字段底层未对应:" + CalFieldName); } } } sql += " AND BoxStatusID=" + SysString.ToDBString((int)EnumBoxStatus.入库); sql += " AND(ISNULL(Qty,0)>0)"; DataTable dt1 = SysUtils.Fill(sql); if (dt1.Rows.Count != 0) { for (int i = 0; i < dt1.Rows.Count; i++) { PackQty += SysConvert.ToDecimal(dt1.Rows[i]["Qty"]); } PackPieceQty = dt1.Rows.Count; } if (PackQty != Qty || PackPieceQty != PieceQty) { dr["YCFlag"] = 1; } } }
public static int ToInt(this object expression, int defValue = 0) { return(SysUtils.StrToInt(expression, defValue)); }
/// <summary> /// Handles when a job from a task requires processing. /// Note that all tasks/jobs in the queue use the same task type ID, /// so the directive <see cref="BackgroundOperationTaskDirective.BackgroundOperationName"/> /// is used to identify which tasks should be executed by /// which background operation. /// </summary> /// <param name="job">The job to process.</param> protected virtual void ProcessJobHandler(AppTasks.ITaskProcessingJob <BackgroundOperationTaskDirective> job) { // Sanity. if (null == job) { return; } // Ensure cancellation has not been requested. job.ThrowIfTaskCancellationRequested(); // What is the current state? var state = job.GetStatus(); // Sanity. if (null == job.Directive) { // This is an issue. We have no way to decide what background operation should run it. Die. SysUtils.ReportErrorToEventLog ( $"Job loaded with no directive (queue: {this.QueueId}, task type: {job.TaskInfo.TaskType}, task id: {job.TaskInfo.TaskID})." ); return; } // Check that we know the job this was associated with. if (string.IsNullOrWhiteSpace(job.Directive.BackgroundOperationName)) { // This is an issue. We have no way to decide what background operation should run it. Die. SysUtils.ReportErrorToEventLog ( $"Job loaded with no background operation name loaded (queue: {this.QueueId}, task type: {job.TaskInfo.TaskType}, task id: {job.TaskInfo.TaskID})." ); return; } // If we have a directive then extract it. var dir = job.Directive.GetParsedInternalDirective(); // Find the background operation to run. TaskQueueBackgroundOperation <TSecureConfiguration> bo = null; lock (_lock) { if (false == this.BackgroundOperations.TryGetValue(job.Directive.BackgroundOperationName, out bo)) { // We have no registered background operation to handle the callback. SysUtils.ReportErrorToEventLog ( $"No background operation found with name {job.Directive.BackgroundOperationName} (queue: {this.QueueId}, task type: {job.TaskInfo.TaskType}, task id: {job.TaskInfo.TaskID})." ); return; } } // Should we repeat? DateTime?nextRun = null; switch (bo.RepeatType) { case TaskQueueBackgroundOperationRepeatType.Interval: // Add the interval to the current datetime. if (bo.Interval.HasValue) { nextRun = DateTime.UtcNow.Add(bo.Interval.Value); } break; case TaskQueueBackgroundOperationRepeatType.Schedule: // Get the next execution time from the schedule. nextRun = bo.Schedule?.GetNextExecution(DateTime.Now); break; } // If we have a next run time then re-run. if (null != nextRun) { // Bind to the completed event ( called always ) of the job. // That way even if the job is canceled, fails, or finishes successfully // ...we always schedule the next run. job.Completed += (s, op) => { // Ensure that if two threads both run this at once we don't end up with a race condition. lock (_lock) { // Cancel any future executions (we only want the single one created below). this.CancelFutureExecutions(bo.Name); // Now schedule it to run according to the interval. this.RunOnce ( bo.Name, nextRun.Value.ToUniversalTime(), dir ); } }; } // Bind to the life-cycle events. job.Succeeded += (sender, op) => CompleteJob(job, MFTaskState.MFTaskStateCompleted); job.Failed += (sender, args) => CompleteJob(job, MFTaskState.MFTaskStateFailed, args.Exception); // Perform the action. // Mark it as started. job.Update ( new TaskInformation() { Started = DateTime.Now, LastActivity = DateTime.Now, CurrentTaskState = MFTaskState.MFTaskStateInProgress } ); // NOTE: this should not have any error handling around it here unless it re-throws the error // Catching the exception here can result in job.ProcessingFailed not being called // Delegate to the background operation. bo.RunJob ( // The TaskProcessorJobEx class wraps the job and allows easy updates. new TaskProcessorJobEx <BackgroundOperationTaskDirective, TSecureConfiguration>() { Job = job, TaskQueueBackgroundOperationManager = this }, dir ); }
public string GetInternalStr() { return(SysUtils.AdjustNum(Level, 2) + GetOrderStr()); }
private void setItemNews(string p_Str) { string[] orderid = p_Str.Split(','); for (int i = 0; i < orderid.Length; i++) { string sql = "SELECT * FROM UV1_Sale_SaleOrderDts WHERE DtsID=" + SysString.ToDBString(SysConvert.ToInt32(orderid[i])); DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count == 1) { gridView1.SetRowCellValue(i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"])); gridView1.SetRowCellValue(i, "GoodsCode", SysConvert.ToString(dt.Rows[0]["GoodsCode"])); gridView1.SetRowCellValue(i, "ColorNum", SysConvert.ToString(dt.Rows[0]["ColorNum"])); gridView1.SetRowCellValue(i, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"])); gridView1.SetRowCellValue(i, "MWidth", SysConvert.ToString(dt.Rows[0]["MWidth"])); gridView1.SetRowCellValue(i, "MWeight", SysConvert.ToString(dt.Rows[0]["MWeight"])); gridView1.SetRowCellValue(i, "WeightUnit", SysConvert.ToString(dt.Rows[0]["WeightUnit"])); gridView1.SetRowCellValue(i, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"])); gridView1.SetRowCellValue(i, "VColorNum", SysConvert.ToString(dt.Rows[0]["VColorNum"])); gridView1.SetRowCellValue(i, "VColorName", SysConvert.ToString(dt.Rows[0]["VColorName"])); gridView1.SetRowCellValue(i, "VItemCode", SysConvert.ToString(dt.Rows[0]["VItemCode"])); gridView1.SetRowCellValue(i, "DVendorID", SysConvert.ToString(dt.Rows[0]["VendorID"])); gridView1.SetRowCellValue(i, "DtsSO", SysConvert.ToString(dt.Rows[0]["FormNo"])); gridView1.SetRowCellValue(i, "Unit", SysConvert.ToString(dt.Rows[0]["Unit"])); string Unit = SysConvert.ToString(dt.Rows[0]["Unit"]); if (Unit.EndsWith("M")) { gridView1.SetRowCellValue(i, "OrderQty", SysConvert.ToDecimal(dt.Rows[0]["Qty"])); } else if (Unit.EndsWith("KG")) { gridView1.SetRowCellValue(i, "OrderQty", SysConvert.ToDecimal(dt.Rows[0]["Weight"])); } else if (Unit.EndsWith("Y")) { gridView1.SetRowCellValue(i, "OrderQty", SysConvert.ToDecimal(dt.Rows[0]["Yard"])); } else if (Unit.EndsWith("PC")) { gridView1.SetRowCellValue(i, "OrderQty", SysConvert.ToDecimal(dt.Rows[0]["PieceQty"])); } if (Unit.EndsWith("M")) { gridView1.SetRowCellValue(i, "Qty", SysConvert.ToDecimal(dt.Rows[0]["Qty"])); } else if (Unit.EndsWith("KG")) { gridView1.SetRowCellValue(i, "Qty", SysConvert.ToDecimal(dt.Rows[0]["Weight"])); } else if (Unit.EndsWith("Y")) { gridView1.SetRowCellValue(i, "Qty", SysConvert.ToDecimal(dt.Rows[0]["Yard"])); } else if (Unit.EndsWith("PC")) { gridView1.SetRowCellValue(i, "Qty", SysConvert.ToDecimal(dt.Rows[0]["PieceQty"])); } gridView1.SetRowCellValue(i, "DLoadID", SysConvert.ToInt32(orderid[i])); txtOrderFormNo.Text = SysConvert.ToString(dt.Rows[0]["FormNo"]); txtOrderDate.DateTime = SysConvert.ToDateTime(dt.Rows[0]["DtsReqDate"]); //if (i == 0) //{ // sql = "SELECT VendorID FROM Data_Item WHERE ItemCode="+SysString.ToDBString( SysConvert.ToString(dt.Rows[0]["ItemCode"])); // dt = SysUtils.Fill(sql); // if (dt.Rows.Count > 0) // { // drpVendorID.EditValue = SysConvert.ToString(dt.Rows[0][0]); // } //} } } }
/// <summary> /// 审核 /// </summary> /// <param name="p_FormID">单据ID</param> /// <param name="p_Type">0/1/2/3:弃审/审核</param> public void RSubmit(int p_FormID, int p_Type, IDBTransAccess sqlTrans) { try { int p_TempType = p_Type;//处理状态 string sql = string.Empty; ItemBuyForm entity = new ItemBuyForm(sqlTrans); entity.ID = p_FormID; entity.SelectByID(); if (entity.SubmitFlag == p_Type)//如果相同异常 { throw new Exception("单据状态重复设置,请关闭程序重新打开操作"); } if (p_Type == (int)ConfirmFlag.未提交) //撤销提交验证 { if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5609))) //采购单有仓库单据不允许修改 { bool allowOPFlag = true; string refuseMessage = string.Empty; DataTable dtSOFlow; if (allowOPFlag) { //仓库流程单据 sql = "SELECT TOP 1 ID,FormNo FROM UV1_WH_IOFormDts WHERE DtsSO=" + SysString.ToDBString(entity.FormNo); dtSOFlow = SysUtils.Fill(sql); if (dtSOFlow.Rows.Count != 0) { allowOPFlag = false; refuseMessage = "此单已有仓库单据(单号):" + dtSOFlow.Rows[0]["FormNo"].ToString() + ",不允许撤销"; } } if (!allowOPFlag)//不允许操作 { throw new Exception(refuseMessage); } } } sql = "UPDATE Buy_ItemBuyForm SET SubmitFlag=" + SysString.ToDBString(p_Type); //if (p_Type == (int)ConfirmFlag.审核通过 || p_Type == (int)ConfirmFlag.审核拒绝) //{ //sql += ",SubmitOPID=" + SysString.ToDBString(ParamConfig.LoginName) + ",SubmitTime=" + SysString.ToDBString(DateTime.Now); //} sql += " WHERE ID=" + p_FormID.ToString();//更新单据主表审核状态 sqlTrans.ExecuteNonQuery(sql); int tempSaleProcedureID = 0; switch (entity.FormAID)//1/2/3/4/5:成品,坯布,纱线,色坯,辅料 { case 1: tempSaleProcedureID = (int)EnumSaleProcedure.成品采购单; break; case 2: tempSaleProcedureID = (int)EnumSaleProcedure.坯布采购单; break; case 3: tempSaleProcedureID = (int)EnumSaleProcedure.纱线采购单; break; case 4: tempSaleProcedureID = (int)EnumSaleProcedure.坯布采购单; break; case 5: //辅料 tempSaleProcedureID = (int)EnumSaleProcedure.辅料采购单; break; } if (p_Type == (int)YesOrNo.Yes) { if (tempSaleProcedureID != (int)EnumSaleProcedure.坯布采购单) { sql = "SELECT DtsSO,ItemCode,ColorNum,ColorName FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; DataTable dtDts = sqlTrans.Fill(sql); SaleOrderRule salerule = new SaleOrderRule(); foreach (DataRow dr in dtDts.Rows) { salerule.RUpdateStep(dr["DtsSO"].ToString(), dr["ItemCode"].ToString(), dr["ColorNum"].ToString(), dr["ColorName"].ToString(), tempSaleProcedureID, 0, 0, 0, p_Type, true, sqlTrans); } } else //坯布采购加载订单时候 将订单里的 ItemCode 加载到 CPItemCode { sql = "SELECT DtsSO,CPItemCode,ColorNum,ColorName FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; DataTable dtDts = sqlTrans.Fill(sql); SaleOrderRule salerule = new SaleOrderRule(); foreach (DataRow dr in dtDts.Rows) { salerule.RUpdateStep(dr["DtsSO"].ToString(), dr["CPItemCode"].ToString(), dr["ColorNum"].ToString(), dr["ColorName"].ToString(), tempSaleProcedureID, 0, 0, 0, p_Type, true, sqlTrans); } } } //#region 回填采购完成数 //if (p_Type == (int)YesOrNo.Yes)//提交 //{ // if (entity.MLType == (int)EnumMLType.纱线 || entity.MLType == (int)EnumMLType.白坯) // { // decimal TotalQty = 0m; // sql = "SELECT SUM(Qty) Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; // DataTable dtDts = sqlTrans.Fill(sql); // if (dtDts.Rows.Count != 0) // { // TotalQty = SysConvert.ToDecimal(dtDts.Rows[0]["Qty"]); // } // sql = "SELECT ID FROM Sale_SaleOrderDts WHERE MainID=(SELECT ID FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo) + ")"; // DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单 // if (dtorder.Rows.Count != 0) // { // while (TotalQty > 0m)//开始回填 // { // for (int i = 0; i < dtorder.Rows.Count;i++ ) // { // SaleOrderDts orderentity = new SaleOrderDts(sqlTrans); // orderentity.ID = SysConvert.ToInt32(dtorder.Rows[i]["ID"]); // bool findR=orderentity.SelectByID(); // if (i == dtorder.Rows.Count - 1) // { // switch (entity.MLType) // { // case (int)EnumMLType.纱线: // orderentity.PSCGQty += TotalQty; // TotalQty = 0; // break; // case (int)EnumMLType.白坯: // orderentity.PBCGQty += TotalQty; // TotalQty = 0; // break; // default: // break; // } // } // else // { // // decimal HTQty = DifQty <= TotalQty ? DifQty : TotalQty; // switch (entity.MLType) // { // case (int)EnumMLType.纱线: // decimal DifPSQty = orderentity.Qty - orderentity.PSCGQty; // if (TotalQty <= DifPSQty) // { // orderentity.PSCGQty += TotalQty; // TotalQty = 0; // break; // } // else // { // if (DifPSQty > 0) // { // orderentity.PSCGQty += DifPSQty; // TotalQty -= DifPSQty; // break; // } // } // break; // case (int)EnumMLType.白坯: // decimal DifPBQty = orderentity.Qty - orderentity.PBCGQty; // if (TotalQty <= DifPBQty) // { // orderentity.PBCGQty += TotalQty; // TotalQty = 0; // break; // } // else // { // if (DifPBQty > 0) // { // orderentity.PBCGQty += DifPBQty; // TotalQty -= DifPBQty; // break; // } // } // break; // default: // break; // } // } // if (findR) // { // SaleOrderDtsRule rule = new SaleOrderDtsRule(); // rule.RUpdate(orderentity, sqlTrans); // } // } //For循环结尾 // } //While结尾 // } // else // { // throw new Exception("数据出现异常未找到原始订单"); // } // } // if (entity.MLType == (int)EnumMLType.成品) // { // sql = "SELECT ItemCode,ColorNum,ColorName,Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; // DataTable dtDts1 = sqlTrans.Fill(sql); // foreach(DataRow dr in dtDts1.Rows) // { // sql = "SELECT DtsID FROM UV1_Sale_SaleOrderDts WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo); // sql += " AND ItemCode=" + SysString.ToDBString(dr["ItemCode"].ToString()); // sql += " AND ColorNum=" + SysString.ToDBString(dr["ColorNum"].ToString()); // sql += " AND ColorName=" + SysString.ToDBString(dr["ColorName"].ToString()); // DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单 // if (dtorder.Rows.Count == 1) // { // SaleOrderDts orderentity = new SaleOrderDts(sqlTrans); // orderentity.ID = SysConvert.ToInt32(dtorder.Rows[0]["DtsID"]); // bool findR=orderentity.SelectByID(); // orderentity.CPCGQty += SysConvert.ToDecimal(dr["Qty"]); // if (findR) // { // SaleOrderDtsRule rule = new SaleOrderDtsRule(); // rule.RUpdate(orderentity, sqlTrans); // } // } // else // { // throw new Exception("数据出现异常未找到原始订单 订单号:"+entity.FormNo); // } // } // } //} //else //撤销提交回填数量 //{ // if (entity.MLType == (int)EnumMLType.纱线 || entity.MLType == (int)EnumMLType.白坯) // { // decimal TotalQty = 0m; // sql = "SELECT SUM(Qty) Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; // DataTable dtDts = sqlTrans.Fill(sql); // if (dtDts.Rows.Count != 0) // { // TotalQty = SysConvert.ToDecimal(dtDts.Rows[0]["Qty"]); // } // sql = "SELECT ID FROM Sale_SaleOrderDts WHERE MainID=(SELECT ID FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo) + ")"; // DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单 // if (dtorder.Rows.Count != 0) // { // while (TotalQty > 0m)//开始回填 // { // for (int i = 0; i < dtorder.Rows.Count; i++) // { // SaleOrderDts orderentity = new SaleOrderDts(sqlTrans); // orderentity.ID = SysConvert.ToInt32(dtorder.Rows[i]["ID"]); // bool findR=orderentity.SelectByID(); // if (i == dtorder.Rows.Count - 1) // { // switch (entity.MLType) // { // case (int)EnumMLType.纱线: // orderentity.PSCGQty -= TotalQty; // //if (orderentity.PSCGQty < 0) // //{ // // orderentity.PSCGQty = 0; // //} // TotalQty = 0; // break; // case (int)EnumMLType.白坯: // orderentity.PBCGQty -= TotalQty; // //if (orderentity.PBCGQty < 0) // //{ // // orderentity.PBCGQty = 0; // //} // TotalQty = 0; // break; // default: // break; // } // } // else // { // switch (entity.MLType) // { // case (int)EnumMLType.纱线: // // decimal DifPSQty = orderentity.Qty - orderentity.PSCGQty; // if (TotalQty <= orderentity.PSCGQty) // { // orderentity.PSCGQty -= TotalQty; // TotalQty = 0; // break; // } // else // { // if (orderentity.PSCGQty > 0) // { // TotalQty -= orderentity.PSCGQty; // orderentity.PSCGQty =0; // break; // } // } // break; // case (int)EnumMLType.白坯: // //decimal DifPBQty = orderentity.Qty - orderentity.PBCGQty; // if (TotalQty <= orderentity.PBCGQty) // { // orderentity.PBCGQty -= TotalQty; // TotalQty = 0; // break; // } // else // { // if (orderentity.PBCGQty > 0) // { // TotalQty -= orderentity.PBCGQty; // orderentity.PBCGQty= 0; // break; // } // } // break; // default: // break; // } // } // if (findR) // { // SaleOrderDtsRule rule = new SaleOrderDtsRule(); // rule.RUpdate(orderentity, sqlTrans); // } // } //For循环结尾 // } //While结尾 // } // else // { // throw new Exception("数据出现异常未找到原始订单"); // } // } // if (entity.MLType == (int)EnumMLType.成品) // { // sql = "SELECT ItemCode,ColorNum,ColorName,Qty FROM Buy_ItemBuyFormDts WHERE MainID=" + p_FormID; // DataTable dtDts1 = sqlTrans.Fill(sql); // foreach (DataRow dr in dtDts1.Rows) // { // sql = "SELECT DtsID FROM UV1_Sale_SaleOrderDts WHERE FormNo=" + SysString.ToDBString(entity.OrderFormNo); // sql += " AND ItemCode=" + SysString.ToDBString(dr["ItemCode"].ToString()); // sql += " AND ColorNum=" + SysString.ToDBString(dr["ColorNum"].ToString()); // sql += " AND ColorName=" + SysString.ToDBString(dr["ColorName"].ToString()); // DataTable dtorder = sqlTrans.Fill(sql);//寻找原始订单 // if (dtorder.Rows.Count == 1) // { // SaleOrderDts orderentity = new SaleOrderDts(sqlTrans); // orderentity.ID = SysConvert.ToInt32(dtorder.Rows[0]["DtsID"]); // bool findR= orderentity.SelectByID(); // orderentity.CPCGQty -= SysConvert.ToDecimal(dr["Qty"]); // if (findR) // { // SaleOrderDtsRule rule = new SaleOrderDtsRule(); // rule.RUpdate(orderentity, sqlTrans); // } // } // else // { // throw new Exception("数据出现异常未找到原始订单 订单号:" + entity.FormNo); // } // } // } //} //#endregion } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 双击得到产品编码 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void txtItemCode_DoubleClick(object sender, EventArgs e) { try { if (HTFormStatus == FormStatus.新增) { if (ProductParamSet.GetIntValueByID(5022) == 1)//面料编码生成规格 { ProductCommon.FormNoIniSet(txtItemCode, "Data_Item", "ItemCode", (int)EnumItemType.面料); } if (ProductParamSet.GetIntValueByID(5022) == 2) //面料编码生成规格-新春兰使用 { string ItemCode = string.Empty; string sql = "Select ItemCodeRule from Data_ItemClass where ID=" + SysConvert.ToInt32(drpItemClassID.EditValue); sql += " AND ISNULL(ItemCodeRule,'')<>''"; DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count != 0) { string VendorID = SysConvert.ToString(drpVendorID.EditValue); string ItemModel = txtItemModel.Text.Trim(); string KZ = txtMWeight.Text.Trim(); string HD = string.Empty; string DB = string.Empty; string SS = string.Empty; for (int i = 0; i < gridView6.RowCount; i++) { if (SysConvert.ToString(gridView6.GetRowCellValue(i, "Name")) == "厚度") { HD = Common.GetCLSIDByCLSNM(SysConvert.ToString(gridView6.GetRowCellValue(i, "Value"))); } if (SysConvert.ToString(gridView6.GetRowCellValue(i, "Name")) == "底布") { DB = Common.GetCLSIDByCLSNM(SysConvert.ToString(gridView6.GetRowCellValue(i, "Value"))); } if (SysConvert.ToString(gridView6.GetRowCellValue(i, "Name")) == "色水") { SS = Common.GetCLSIDByCLSNM(SysConvert.ToString(gridView6.GetRowCellValue(i, "Value"))); } } string ItemCodeRule = SysConvert.ToString(dt.Rows[0]["ItemCodeRule"]); string[] FieldName = ItemCodeRule.Split('+'); for (int i = 0; i < FieldName.Length; i++) { if (FieldName[i].ToString() == "VendorID") { ItemCode += VendorID; } if (FieldName[i].ToString() == "ItemModel") { ItemCode += ItemModel; } if (FieldName[i].ToString() == "HD") { ItemCode += HD; } if (FieldName[i].ToString() == "DB") { ItemCode += DB; } if (FieldName[i].ToString() == "SS") { ItemCode += SS; } if (FieldName[i].ToString() == "MWeight") { ItemCode += KZ; } } } else { this.ShowMessage("请先选择面料类型,并指定好生成规则!"); return; } txtItemCode.Text = ItemCode; } } } catch (Exception E) { this.ShowMessage(E.Message); } }
protected override async Task OnInitializedAsync() { try { //if (string.IsNullOrEmpty(HttpContext.Session.GetString("UserName")) && modId.ToLower() != ConstMod.ModListHomo.ToLower()) //{ // return RedirectToAction("Login", "Home"); // NavigationManager.NavigateTo("PageToRedirect"); //} //Dongpv:look updata if (!string.IsNullOrEmpty(modId) && !string.IsNullOrEmpty(OrderID)) { ArrayList arrDetail = new ArrayList(); SysUtils.String2ArrayList(ref arrDetail, OrderID, "@", "="); modId = SysUtils.getValue(arrDetail, "MODID").ToString(); //Fix //modId = "03" + modId.Substring(2, 3); } //Dongpv:look updata CheckBoxModels = new List <CheckBoxModel>(); lstControl = new List <ModuleFieldInfo>(); moduleFieldInfo = new List <ModuleFieldInfo>(); HomeBus homeBus = new HomeBus(moduleService, iConfiguration, distributedCache); var data = await homeBus.GetModule(modId); int userId = int.Parse("0" + "" /*HttpContext.Session.GetString("UserId")*/); var groupModUser = await moduleService.GetGroupModByUserId(userId); RoleUser = groupModUser; moduleInfoModel = homeBus.ConvertFromViewModel(data); //Set title var arr = new string[1]; arr[0] = moduleInfoModel.ModulesInfo.ModuleName.GetLanguageTitle(moduleInfoModel.LanguageInfo); await JSRuntime.InvokeVoidAsync("SetTitle", arr); //Hết SetTitle Title = moduleInfoModel.ModulesInfo.ModuleName.GetLanguageTitle(await homeBus.LoadAllBtnLanguage()); var cb = moduleInfoModel.FieldsInfo.Where(x => !String.IsNullOrEmpty(x.ListSource)); var scdType = moduleInfoModel.FieldsInfo.Select(x => x.ConditionType); if (cb.Any()) { var codeInfoParram = cb.Select(x => new CodeInfoParram { CtrlType = x.ControlType, Name = x.FieldName, ListSource = x.ListSource }); //var para = string.Join("", sources); var sourceCodeInfo = cb.Where(x => x.ListSource.Contains(":"));//Lấy những thông tin các ListSource từ DefCode var codeInfoModels = new List <CodeInfoModel>(); if (sourceCodeInfo != null && sourceCodeInfo.Any()) { var defCodeAll = await homeBus.LoadAllDefCode(); var lstSource = sourceCodeInfo.Select(x => x.ListSource).ToList(); var cbDefCode = defCodeAll.Where(x => lstSource.Contains(":" + x.CodeType + "." + x.CodeName)); foreach (var item in sourceCodeInfo) { codeInfoModels.Add(new CodeInfoModel { Name = item.FieldName, CodeInfos = cbDefCode.Where(x => ":" + x.CodeType + "." + x.CodeName == item.ListSource).ToList() }); } } var dataCB = (await moduleService.GetCombobox(codeInfoParram.Where(x => !x.ListSource.Contains(":")).ToList()));//Lấy thông tin các Combobox theo Store codeInfoModels.AddRange(dataCB.Data); DataCombobox = codeInfoModels; } modSearch = await homeBus.LoadModSearchByModId(modId); if (modSearch != null) { var parrams = new List <string>(); if (!string.IsNullOrEmpty(parramMods)) { var btnParramInfo = (List <ButtonParamInfo>)JsonConvert.DeserializeObject <List <ButtonParamInfo> >(parramMods); var temp = btnParramInfo.Select(x => x.FieldName + " = '" + x.Value + "'"); parrams.AddRange(temp); } var query = ""; if (modSearch.QueryFormat.IndexOf("{0}") > 0) { if (modSearch.QueryFormat.IndexOf("{1}") > 0) { var currPage = 1; var paging = String.Format(" Limit {1} offset {0}", (currPage - 1) * CommonMethod.PageSize, (currPage - 1) * CommonMethod.PageSize + CommonMethod.PageSize); query = string.Format(modSearch.QueryFormat, Schema, parrams.Any() ? String.Join(" AND ", parrams) : " 1=1 ", paging); } else { query = string.Format(modSearch.QueryFormat, Schema, parrams.Any() ? String.Join(" AND ", parrams) : " 1=1 "); } } else { query = String.Format(modSearch.QueryFormat, Schema); } //Dongpv: //var dataGrid = await moduleService.LoadQueryModule(new ParramModuleQuery { Store = query }); var moduleFields = moduleInfoModel.FieldsInfo.FirstOrDefault(); if (modSearch.GroupModule == "004") { Message msg = new Message(); msg.MsgType = Constants.MSG_MISC_TYPE; //MESSAGE TYPE: INQ, MAINTAIN, TXN, REPORT msg.ObjectName = Constants.OBJ_SEARCH; msg.MsgAction = Constants.MSG_SEARCH; msg.Body.Add("SearchObject"); msg.Body.Add(moduleFields.Entity); msg.Body.Add("Condition"); msg.Body.Add(" WHERE 1=1"); msg.Body.Add("Page"); msg.Body.Add(0); var dataGrid = await moduleService.getQuery(msg); DataSearch = dataGrid; } else { var dataGrid = await moduleService.LoadQueryModule(new ParramModuleQuery { Store = query }); DataSearch = dataGrid; } //Dongpv: //var dataGrid = await _moduleService.LoadQueryModule(new ParramModuleQuery { Store = modSearch.QueryFormat }); ////Dongpv: //DataSearch = dataGrid; btnInfos = moduleInfoModel.ButtonsInfo == null ? new List <ButtonInfo>() : moduleInfoModel.ButtonsInfo; var moduleInfo = moduleInfoModel.ModulesInfo == null ? new ModuleInfo() : moduleInfoModel.ModulesInfo; moduleFieldInfo = moduleInfoModel.FieldsInfo == null ? new List <ModuleFieldInfo>() : moduleInfoModel.FieldsInfo; var parrs = moduleInfoModel.ButtonParamsInfo == null ? new List <ButtonParamInfo>() : moduleInfoModel.ButtonParamsInfo; codeInfos = DataCombobox; checkColAction = btnInfos.Where(x => x.ShowOnToolbar == "N").ToList(); checkBtnViews = btnInfos.Where(x => x.ButtonName.ToUpper() == EDefModBtn.BTN_VIEW.ToString().ToUpper()).ToList(); checkBtnEdits = btnInfos.Where(x => x.ButtonName.ToUpper() == EDefModBtn.BTN_EDIT.ToString().ToUpper()).ToList(); checkBtnDels = btnInfos.Where(x => x.ButtonName.ToUpper() == EDefModBtn.BTN_DELETE.ToString().ToUpper()).ToList(); checkBtnAssRole = btnInfos.Where(x => x.ButtonName.ToUpper() == EDefModBtn.BTN_ASSIGN_ROLE.ToString().ToUpper()).ToList(); checkBtnAssUsers = btnInfos.Where(x => x.ButtonName.ToUpper() == EDefModBtn.BTN_ASSIGN_USER.ToString().ToUpper()).ToList(); if (groupMods == null || groupMods.Count == 0) { groupMods = new List <GroupMod>(); groupMods.Add(new GroupMod { GroupId = "1", ModId = moduleInfoModel.ModulesInfo.ModuleID }); if (checkBtnEdits.Any()) { groupMods.Add(new GroupMod { GroupId = "1", ModId = checkBtnEdits.First().CallModuleID }); } if (checkBtnDels.Any()) { groupMods.Add(new GroupMod { GroupId = "1", ModId = checkBtnDels.First().CallModuleID }); } } checkBtnDel = checkBtnDels.Any(); checkBtnView = checkBtnViews.Any(); checkBtnEdit = checkBtnEdits.Any(); checkBtnAssignRole = checkBtnAssRole.Any(); checkBtnAssignUser = checkBtnAssUsers.Any(); parramEdit = new List <ButtonParamInfo>(); parramView = new List <ButtonParamInfo>(); parramDel = new List <ButtonParamInfo>(); parramAssignUser = new List <ButtonParamInfo>(); if (checkBtnView) { var parramViews = parrs.Where(x => x.ButtonName == EDefModBtn.BTN_VIEW.ToString()); if (parramViews.Any()) { parramView = parramViews.ToList(); } } if (checkBtnEdit) { var parramEdits = parrs.Where(x => x.ButtonName == EDefModBtn.BTN_EDIT.ToString()); if (parramEdits.Any()) { parramEdit = parramEdits.ToList(); } } if (checkBtnDel) { var parramDels = parrs.Where(x => x.ButtonName == EDefModBtn.BTN_DELETE.ToString()); if (parramDels.Any()) { parramDel = parramDels.ToList(); } } if (checkBtnAssignUser) { var parramAssignUsers = parrs.Where(x => x.ButtonName == EDefModBtn.BTN_ASSIGN_USER.ToString()); if (parramAssignUsers.Any()) { parramAssignUser = parramAssignUsers.ToList(); } } } //return View("Search", modId); } catch (Exception ex) { //return View("Search", modId); } }
/// <summary> /// 获得数据源 /// </summary> /// <returns></returns> DataTable GetDataSource() { string sql = string.Empty; //查询条件 string condition = ""; if (m_WHID != "") { condition += " AND WHID=" + SysString.ToDBString(m_WHID); } if (m_SectionID != "") { condition += " AND SectionID=" + SysString.ToDBString(m_SectionID); } if (m_SBitID != "") { condition += " AND SBitID=" + SysString.ToDBString(m_SBitID); } condition += " AND ItemCode=" + SysString.ToDBString(m_ItemCode); condition += " AND BoxStatusID=" + SysString.ToDBString((int)EnumBoxStatus.入库); condition += " AND OrderFormNo=" + SysString.ToDBString(m_OrderFormNo); //if (m_WHType == (int)EnumWHType.面料仓库) //{ condition += " AND ColorNum=" + SysString.ToDBString(m_ColorNum); condition += " AND ColorName=" + SysString.ToDBString(m_ColorName); //} //else //坯布色号颜色不参与 //{ //} if (radgSearchType.SelectedIndex == 0)//按缸号批号 { if (m_Batch != string.Empty) { condition += " AND Batch=" + SysString.ToDBString(m_Batch); } if (m_JarNum != string.Empty) { condition += " AND JarNum=" + SysString.ToDBString(m_JarNum); } } else if (radgSearchType.SelectedIndex == 1)//按颜色,不处理 { } condition += Condition2; sql = "SELECT 0 SelectFlag,ID, SubSeq,0 SelectFlag,BoxNo,Qty,Weight,Yard,GoodsLevel,'' ItemModel, JarNum,Batch FROM WH_PackBox WHERE 1=1"; //KPFlag暂时当着匹号,要修改代码 (zfc)2014.10.17处理添加了SubSeq字段 sql += condition; sql += " ORDER BY SectionID,Batch,JarNum"; //缺少匹号 DataTable dt = SysUtils.Fill(sql); //所有可选码单数据 //查询已选码单数据 if (PackType == (int)EnumPackType.仓库单据) { sql = "SELECT BoxNo FROM WH_IOFormDtsPack WHERE MainID=" + IOFormID; } else if (PackType == (int)EnumPackType.发货单据) { sql = "SELECT BoxNo FROM Sale_FHFormDtsPack WHERE MainID=" + IOFormID; } else if (PackType == (int)EnumPackType.扣料单据) { sql = "SELECT BoxNo FROM WO_FabricWHOutFormDtsPack WHERE MainID=" + IOFormID; } else if (PackType == (int)EnumPackType.调拨单据) { sql = "SELECT BoxNo FROM WH_DBFormDtsPack WHERE MainID=" + IOFormID; } DataTable dtSelect = SysUtils.Fill(sql); string isnSelect = string.Empty; for (int i = 0; i < dtSelect.Rows.Count; i++) { if (isnSelect != string.Empty) { isnSelect += ","; } isnSelect += SysString.ToDBString(dtSelect.Rows[i]["BoxNo"].ToString()); } if (isnSelect != string.Empty)//如果有已选 { DataRow[] drA = dt.Select("BoxNo IN(" + isnSelect + ")"); for (int i = 0; i < drA.Length; i++)//遍历选择项,改变标志 { drA[i]["SelectFlag"] = 1; } } return(dt); }
/// <summary> /// 设置销售订单复合布算料信息 /// </summary> /// <param name="str"></param> private void SetSaleOrderFabricCompSite(string str) { string[] arr = str.Split(','); int index = gridView1.FocusedRowHandle; //checkRowSet(); int length = 0; for (int i = index; i < arr.Length + index; i++) { string sql = "SELECT * FROM UV1_Sale_SaleOrderTFabricCompSite WHERE DtsID=" + SysString.ToDBString(SysConvert.ToInt32(arr[length])); DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count > 0) { gridView1.SetRowCellValue(i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"])); gridView1.SetRowCellValue(i, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"])); gridView1.SetRowCellValue(i, "ItemModel", SysConvert.ToString(dt.Rows[0]["ItemModel"])); if (SysConvert.ToString(dt.Rows[0]["MWeight"]) != string.Empty) { gridView1.SetRowCellValue(i, "MWeight", SysConvert.ToString(dt.Rows[0]["MWeight"])); } else { gridView1.SetRowCellValue(i, "MWeight", DBNull.Value); } if (SysConvert.ToString(dt.Rows[0]["MWidth"]) != string.Empty) { gridView1.SetRowCellValue(i, "MWidth", SysConvert.ToString(dt.Rows[0]["MWidth"])); } else { gridView1.SetRowCellValue(i, "MWidth", DBNull.Value); } gridView1.SetRowCellValue(i, "ItemStd", SysConvert.ToString(dt.Rows[0]["ItemStd"])); gridView1.SetRowCellValue(i, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"])); if (SysConvert.ToString(dt.Rows[0]["Qty"]) != string.Empty) { gridView1.SetRowCellValue(i, "Qty", SysConvert.ToString(dt.Rows[0]["Qty"])); } else { gridView1.SetRowCellValue(i, "Qty", DBNull.Value); } gridView1.SetRowCellValue(i, "DtsSO", SysConvert.ToString(dt.Rows[0]["SO"]));//FormNo //gridView1.SetRowCellValue(i, "Unit", SysConvert.ToString(dt.Rows[0]["ItemUnit"]));// if (SysConvert.ToString(dt.Rows[0]["Unit"]) != string.Empty) { gridView1.SetRowCellValue(i, "Unit", SysConvert.ToString(dt.Rows[0]["Unit"])); } else { gridView1.SetRowCellValue(i, "Unit", SysConvert.ToString(dt.Rows[0]["ItemUnit"])); } if (i == index) { txtOrderFormNo.Text = SysConvert.ToString(dt.Rows[0]["SO"]); //txtOrderDate.DateTime = SysConvert.ToDateTime(dt.Rows[0]["DtsReqDate"]); sql = "SELECT ReqDate FROM Sale_SaleOrder WHERE FormNo=" + SysString.ToDBString(SysConvert.ToString(dt.Rows[0]["SO"])); DataTable dtInfo = SysUtils.Fill(sql); if (dtInfo.Rows.Count != 0) { txtOrderDate.DateTime = SysConvert.ToDateTime(dtInfo.Rows[0]["ReqDate"]); } drpSaleOPID.EditValue = dt.Rows[0]["SaleOPID"].ToString(); } } length++; } }
public void SendLog() { SysUtils.SendMail(GKData.APP_MAIL, "GEDKeeper: feedback", "This automatic notification of error.", AppHost.GetLogFilename()); }
private void setItemNews(string p_Str) { string[] orderid = p_Str.Split(','); for (int i = 0; i < orderid.Length; i++) { string sql = "SELECT * FROM UV1_Sale_SaleOrderDts WHERE DtsID=" + SysString.ToDBString(SysConvert.ToInt32(orderid[i])); DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count == 1) { int ProductTypeID = SysConvert.ToInt32(dt.Rows[0]["ProductTypeID"]);//1毛巾 2面料 if (ProductTypeID == 1) { gridView1.Columns["BoxQty"].Visible = true; gridView1.Columns["BoxQty"].VisibleIndex = 11; gridView1.Columns["SetQty"].Visible = true; gridView1.Columns["SetQty"].VisibleIndex = 12; gridView1.Columns["DozensQty"].Visible = true; gridView1.Columns["DozensQty"].VisibleIndex = 13; gridView1.SetRowCellValue(i, "BoxQty", SysConvert.ToInt32(dt.Rows[0]["BoxQty"])); gridView1.SetRowCellValue(i, "SetQty", SysConvert.ToInt32(dt.Rows[0]["SetQty"])); gridView1.SetRowCellValue(i, "DozensQty", SysConvert.ToInt32(dt.Rows[0]["DozensQty"])); } else { gridView1.Columns["BoxQty"].Visible = false; gridView1.Columns["SetQty"].Visible = false; gridView1.Columns["DozensQty"].Visible = false; } gridView1.SetRowCellValue(i, "ItemCode", SysConvert.ToString(dt.Rows[0]["ItemCode"])); gridView1.SetRowCellValue(i, "GoodsCode", SysConvert.ToString(dt.Rows[0]["GoodsCode"])); gridView1.SetRowCellValue(i, "FreeStr1", SysConvert.ToString(dt.Rows[0]["FreeStr1"]));//画本号 gridView1.SetRowCellValue(i, "ColorNum", SysConvert.ToString(dt.Rows[0]["ColorNum"])); gridView1.SetRowCellValue(i, "ColorName", SysConvert.ToString(dt.Rows[0]["ColorName"])); gridView1.SetRowCellValue(i, "MWidth", SysConvert.ToString(dt.Rows[0]["MWidth"])); gridView1.SetRowCellValue(i, "MWeight", SysConvert.ToString(dt.Rows[0]["MWeight"])); gridView1.SetRowCellValue(i, "WeightUnit", SysConvert.ToString(dt.Rows[0]["WeightUnit"])); gridView1.SetRowCellValue(i, "ItemName", SysConvert.ToString(dt.Rows[0]["ItemName"])); gridView1.SetRowCellValue(i, "Unit", SysConvert.ToString(dt.Rows[0]["Unit"])); gridView1.SetRowCellValue(i, "VColorNum", SysConvert.ToString(dt.Rows[0]["VColorNum"])); gridView1.SetRowCellValue(i, "VColorName", SysConvert.ToString(dt.Rows[0]["VColorName"])); gridView1.SetRowCellValue(i, "VItemCode", SysConvert.ToString(dt.Rows[0]["VItemCode"])); gridView1.SetRowCellValue(i, "DVendorID", SysConvert.ToString(dt.Rows[0]["VendorID"])); gridView1.SetRowCellValue(i, "DtsSO", SysConvert.ToString(dt.Rows[0]["FormNo"])); gridView1.SetRowCellValue(i, "ItemModel", SysConvert.ToString(dt.Rows[0]["ItemModel"])); gridView1.SetRowCellValue(i, "ItemStd", SysConvert.ToString(dt.Rows[0]["ItemStd"])); gridView1.SetRowCellValue(i, "OrderSinglePrice", SysConvert.ToDecimal(dt.Rows[0]["SingPrice"])); gridView1.SetRowCellValue(i, "DLoadID", SysConvert.ToInt32(orderid[i])); string Unit = SysConvert.ToString(dt.Rows[0]["Unit"]); if (Unit.Contains("/KG")) { gridView1.SetRowCellValue(i, "OrderQty", SysConvert.ToString(dt.Rows[0]["Weight"])); gridView1.SetRowCellValue(i, "Qty", SysConvert.ToString(dt.Rows[0]["Weight"])); } else if (Unit.Contains("/M")) { gridView1.SetRowCellValue(i, "OrderQty", SysConvert.ToString(dt.Rows[0]["Qty"])); gridView1.SetRowCellValue(i, "Qty", SysConvert.ToString(dt.Rows[0]["Qty"])); } else if (Unit.Contains("/Y")) { gridView1.SetRowCellValue(i, "OrderQty", SysConvert.ToString(dt.Rows[0]["Yard"])); gridView1.SetRowCellValue(i, "Qty", SysConvert.ToString(dt.Rows[0]["Yard"])); } else if (Unit.Contains("/PC")) { gridView1.SetRowCellValue(i, "OrderQty", SysConvert.ToString(dt.Rows[0]["PieceQty"])); gridView1.SetRowCellValue(i, "Qty", SysConvert.ToString(dt.Rows[0]["PieceQty"])); } gridView1.SetRowCellValue(i, "OrderUnit", SysConvert.ToString(dt.Rows[0]["Unit"])); drpOrderVendorID.EditValue = SysConvert.ToString(dt.Rows[0]["VendorID"]); if (i == 0) { txtOrderFormNo.Text = SysConvert.ToString(dt.Rows[0]["FormNo"]); txtOrderDate.DateTime = SysConvert.ToDateTime(dt.Rows[0]["DtsReqDate"]); drpSaleOPID.EditValue = dt.Rows[0]["SaleOPID"].ToString(); } //if (i == 0) //{ // sql = "SELECT VendorID FROM Data_Item WHERE ItemCode="+SysString.ToDBString( SysConvert.ToString(dt.Rows[0]["ItemCode"])); // dt = SysUtils.Fill(sql); // if (dt.Rows.Count > 0) // { // drpVendorID.EditValue = SysConvert.ToString(dt.Rows[0][0]); // } //} } } }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { //查询出入库信息 string sql = "SELECT * FROM UV1_WH_IOFormDts WHERE 1=1"; sql += " AND SubmitFlag=1"; if (chkINDate.Checked) { sql += " AND FormDate BETWEEN " + SysString.ToDBString(txtFormDateS.DateTime) + " AND " + SysString.ToDBString(txtFormDateE.DateTime); } if (SysConvert.ToString(drpVendorID.EditValue) != "") { sql += " AND VendorID=" + SysString.ToDBString(drpVendorID.EditValue.ToString()); } if (SysConvert.ToString(drpSaleOPID.EditValue) != "") { sql += " AND VendorID IN(SELECT VendorID FROM Data_Vendor WHERE InSaleOP=" + SysString.ToDBString(drpSaleOPID.EditValue.ToString()) + ")"; } if (txtGoodsCode.Text.Trim() != "") { sql += " AND GoodsCode LIKE " + SysString.ToDBString("%" + txtGoodsCode.Text.Trim() + "%"); } if (txtItemCode.Text.Trim() != "") { sql += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%"); } sql += " AND SubType NOT IN(SELECT ID FROM Enum_FormList WHERE DZFlag=" + SysString.ToDBString((int)EnumDZFlag.对帐) + ")"; if (FormListAID == (int)EnumVendorType.客户) { sql += " AND SubType IN(SELECT ID FROM Enum_FormList WHERE DZType=" + SysString.ToDBString((int)EnumDZType.销售) + ")"; } if (FormListAID == (int)EnumVendorType.工厂) { sql += " AND SubType IN(SELECT ID FROM Enum_FormList WHERE DZType=" + SysString.ToDBString((int)EnumDZType.采购) + ")"; } sql += " ORDER BY FormDate"; DataTable dt = SysUtils.Fill(sql); dt.Columns.Add("KPQty", typeof(float)); dt.Columns.Add("KPAmount", typeof(float)); dt.Columns.Add("LKAmount", typeof(float)); SetDt(dt); //查询开票信息 sql = "SELECT MakeDate,VendorID,ItemCode,GoodsCode,SUM(DInvoiceQty) DInvoiceQty,SUM(DInvoiceAmount) DInvoiceAmount FROM UV1_Finance_InvoiceOperationDts WHERE 1=1"; if (FormListAID == (int)EnumVendorType.客户) { sql += " AND DZTypeID=" + SysString.ToDBString((int)EnumDZType.销售); } if (FormListAID == (int)EnumVendorType.工厂) { sql += " AND DZTypeID=" + SysString.ToDBString((int)EnumDZType.采购); } sql += " AND SubmitFlag=1"; sql += " AND KPType=" + (int)EnumKPType.正常开票; if (chkINDate.Checked) { sql += " AND MakeDate BETWEEN " + SysString.ToDBString(txtFormDateS.DateTime) + " AND " + SysString.ToDBString(txtFormDateE.DateTime); } if (SysConvert.ToString(drpVendorID.EditValue) != "") { sql += " AND VendorID=" + SysString.ToDBString(drpVendorID.EditValue.ToString()); } if (SysConvert.ToString(drpSaleOPID.EditValue) != "") { sql += " AND VendorID IN(SELECT VendorID FROM Data_Vendor WHERE InSaleOP=" + SysString.ToDBString(drpSaleOPID.EditValue.ToString()) + ")"; } if (txtGoodsCode.Text.Trim() != "") { sql += " AND GoodsCode LIKE " + SysString.ToDBString("%" + txtGoodsCode.Text.Trim() + "%"); } if (txtItemCode.Text.Trim() != "") { sql += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%"); } sql += " GROUP BY MakeDate,VendorID,ItemCode,GoodsCode"; DataTable dt2 = SysUtils.Fill(sql); //预开票 sql = "SELECT * FROM UV1_Finance_InvoiceYOperationDts WHERE 1=1"; if (FormListAID == (int)EnumVendorType.客户) { sql += " AND DZTypeID=" + SysString.ToDBString((int)EnumDZType.销售); } if (FormListAID == (int)EnumVendorType.工厂) { sql += " AND DZTypeID=" + SysString.ToDBString((int)EnumDZType.采购); } sql += " AND SubmitFlag=1"; sql += " AND KPType=" + (int)EnumKPType.预开票; if (chkINDate.Checked) { sql += " AND MakeDate BETWEEN " + SysString.ToDBString(txtFormDateS.DateTime) + " AND " + SysString.ToDBString(txtFormDateE.DateTime); } if (SysConvert.ToString(drpVendorID.EditValue) != "") { sql += " AND VendorID=" + SysString.ToDBString(drpVendorID.EditValue.ToString()); } if (SysConvert.ToString(drpSaleOPID.EditValue) != "") { sql += " AND VendorID IN(SELECT VendorID FROM Data_Vendor WHERE InSaleOP=" + SysString.ToDBString(drpSaleOPID.EditValue.ToString()) + ")"; } if (txtGoodsCode.Text.Trim() != "") { sql += " AND GoodsCode LIKE " + SysString.ToDBString("%" + txtGoodsCode.Text.Trim() + "%"); } if (txtItemCode.Text.Trim() != "") { sql += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%"); } DataTable dt5 = SysUtils.Fill(sql); //查询收付款信息 sql = "SELECT * FROM Finance_RecPay WHERE 1=1"; if (FormListAID == (int)EnumVendorType.客户) { sql += " AND RecPayTypeID=" + SysString.ToDBString((int)EnumRecPayType.收款); } if (FormListAID == (int)EnumVendorType.工厂) { sql += " AND RecPayTypeID=" + SysString.ToDBString((int)EnumRecPayType.付款); } sql += " AND SubmitFlag=1"; sql += " AND ISNULL(HTNO,'')='' "; if (chkINDate.Checked) { sql += " AND ExDate BETWEEN " + SysString.ToDBString(txtFormDateS.DateTime) + " AND " + SysString.ToDBString(txtFormDateE.DateTime); } if (SysConvert.ToString(drpVendorID.EditValue) != "") { sql += " AND VendorID=" + SysString.ToDBString(drpVendorID.EditValue.ToString()); } if (SysConvert.ToString(drpSaleOPID.EditValue) != "") { sql += " AND VendorID IN(SELECT VendorID FROM Data_Vendor WHERE InSaleOP=" + SysString.ToDBString(drpSaleOPID.EditValue.ToString()) + ")"; } if (txtGoodsCode.Text.Trim() != "") { sql += " AND 1=0"; } if (txtItemCode.Text.Trim() != "") { sql += " AND 1=0"; } DataTable dt3 = SysUtils.Fill(sql); //查询收付款信息 sql = "SELECT * FROM UV1_Finance_RecPayHTDts WHERE 1=1"; if (FormListAID == (int)EnumVendorType.客户) { sql += " AND RecPayTypeID=" + SysString.ToDBString((int)EnumRecPayType.收款); } if (FormListAID == (int)EnumVendorType.工厂) { sql += " AND RecPayTypeID=" + SysString.ToDBString((int)EnumRecPayType.付款); } sql += " AND SubmitFlag=1"; sql += " AND ISNULL(HTNO,'')<>'' "; if (chkINDate.Checked) { sql += " AND ExDate BETWEEN " + SysString.ToDBString(txtFormDateS.DateTime) + " AND " + SysString.ToDBString(txtFormDateE.DateTime); } if (SysConvert.ToString(drpVendorID.EditValue) != "") { sql += " AND VendorID=" + SysString.ToDBString(drpVendorID.EditValue.ToString()); } if (SysConvert.ToString(drpSaleOPID.EditValue) != "") { sql += " AND VendorID IN(SELECT VendorID FROM Data_Vendor WHERE InSaleOP=" + SysString.ToDBString(drpSaleOPID.EditValue.ToString()) + ")"; } if (txtGoodsCode.Text.Trim() != "") { sql += " AND GoodsCode LIKE " + SysString.ToDBString("%" + txtGoodsCode.Text.Trim() + "%"); } if (txtItemCode.Text.Trim() != "") { sql += " AND HTItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%"); } DataTable dt4 = SysUtils.Fill(sql); for (int i = 0; i < dt2.Rows.Count; i++) { DataRow dr = dt.NewRow(); dr["KPQty"] = SysConvert.ToDecimal(dt2.Rows[i]["DInvoiceQty"]); dr["KPAmount"] = SysConvert.ToDecimal(dt2.Rows[i]["DInvoiceAmount"]); dr["FormDate"] = SysConvert.ToDateTime(dt2.Rows[i]["MakeDate"]); dr["VendorAttn"] = Common.GetVendorNameByVendorID(SysConvert.ToString(dt2.Rows[i]["VendorID"])); dr["ItemCode"] = SysConvert.ToString(dt2.Rows[i]["ItemCode"]); dr["GoodsCode"] = SysConvert.ToString(dt2.Rows[i]["GoodsCode"]); //dr["DtsOrderFormNo"] = SysConvert.ToString(dt3.Rows[j]["HTNO"]); dt.Rows.Add(dr); } for (int i = 0; i < dt5.Rows.Count; i++) { DataRow dr = dt.NewRow(); dr["KPQty"] = SysConvert.ToDecimal(dt5.Rows[i]["Qty"]); dr["KPAmount"] = SysConvert.ToDecimal(dt5.Rows[i]["Amount"]); dr["FormDate"] = SysConvert.ToDateTime(dt5.Rows[i]["MakeDate"]); dr["VendorAttn"] = Common.GetVendorNameByVendorID(SysConvert.ToString(dt5.Rows[i]["VendorID"])); dr["ItemCode"] = SysConvert.ToString(dt5.Rows[i]["ItemCode"]); dr["GoodsCode"] = SysConvert.ToString(dt5.Rows[i]["GoodsCode"]); dr["DtsOrderFormNo"] = SysConvert.ToString(dt5.Rows[i]["DtsOrderNo"]); dt.Rows.Add(dr); } for (int j = 0; j < dt3.Rows.Count; j++) { DataRow dr = dt.NewRow(); dr["LKAmount"] = SysConvert.ToDecimal(dt3.Rows[j]["ExAmount"]); dr["FormDate"] = SysConvert.ToDateTime(dt3.Rows[j]["ExDate"]); dr["VendorAttn"] = Common.GetVendorNameByVendorID(SysConvert.ToString(dt3.Rows[j]["VendorID"])); dr["DtsOrderFormNo"] = SysConvert.ToString(dt3.Rows[j]["HTNO"]); dt.Rows.Add(dr); } for (int j = 0; j < dt4.Rows.Count; j++) { DataRow dr = dt.NewRow(); dr["LKAmount"] = SysConvert.ToDecimal(dt4.Rows[j]["HTAMOUNT"]); dr["FormDate"] = SysConvert.ToDateTime(dt4.Rows[j]["ExDate"]); dr["VendorAttn"] = Common.GetVendorNameByVendorID(SysConvert.ToString(dt4.Rows[j]["VendorID"])); dr["DtsOrderFormNo"] = SysConvert.ToString(dt4.Rows[j]["HTNO"]); dr["ItemCode"] = SysConvert.ToString(dt4.Rows[j]["HTItemCode"]); dr["GoodsCode"] = SysConvert.ToString(dt4.Rows[j]["GoodsCode"]); dt.Rows.Add(dr); } if (chkZK.Checked) { //查询开票信息 sql = "SELECT MakeDate,VendorID,ItemCode,GoodsCode,DInvoiceSinglePrice,SUM(DInvoiceQty) DInvoiceQty,SUM(DInvoiceAmount) DInvoiceAmount FROM UV1_Finance_InvoiceOperationDts WHERE 1=1"; if (FormListAID == (int)EnumVendorType.客户) { sql += " AND DZTypeID=" + SysString.ToDBString((int)EnumDZType.销售); } if (FormListAID == (int)EnumVendorType.工厂) { sql += " AND DZTypeID=" + SysString.ToDBString((int)EnumDZType.采购); } sql += " AND DLOADNO='折扣缺损'"; sql += " AND SubmitFlag=1"; sql += " AND KPType=" + (int)EnumKPType.正常开票; if (chkINDate.Checked) { sql += " AND MakeDate BETWEEN " + SysString.ToDBString(txtFormDateS.DateTime) + " AND " + SysString.ToDBString(txtFormDateE.DateTime); } if (SysConvert.ToString(drpVendorID.EditValue) != "") { sql += " AND VendorID=" + SysString.ToDBString(drpVendorID.EditValue.ToString()); } if (SysConvert.ToString(drpSaleOPID.EditValue) != "") { sql += " AND VendorID IN(SELECT VendorID FROM Data_Vendor WHERE InSaleOP=" + SysString.ToDBString(drpSaleOPID.EditValue.ToString()) + ")"; } if (txtGoodsCode.Text.Trim() != "") { sql += " AND GoodsCode LIKE " + SysString.ToDBString("%" + txtGoodsCode.Text.Trim() + "%"); } if (txtItemCode.Text.Trim() != "") { sql += " AND ItemCode LIKE " + SysString.ToDBString("%" + txtItemCode.Text.Trim() + "%"); } sql += " GROUP BY MakeDate,VendorID,ItemCode,GoodsCode,DInvoiceSinglePrice"; DataTable dtZK = SysUtils.Fill(sql); for (int i = 0; i < dtZK.Rows.Count; i++) { DataRow dr = dt.NewRow(); dr["Qty"] = SysConvert.ToDecimal(dtZK.Rows[i]["DInvoiceQty"]); dr["Amount"] = SysConvert.ToDecimal(dtZK.Rows[i]["DInvoiceAmount"]); dr["FormDate"] = SysConvert.ToDateTime(dtZK.Rows[i]["MakeDate"]); dr["VendorAttn"] = Common.GetVendorNameByVendorID(SysConvert.ToString(dtZK.Rows[i]["VendorID"])); dr["ItemCode"] = SysConvert.ToString(dtZK.Rows[i]["ItemCode"]); dr["GoodsCode"] = SysConvert.ToString(dtZK.Rows[i]["GoodsCode"]); dr["VItemCode"] = "折扣缺损"; dr["SinglePrice"] = SysConvert.ToDecimal(dtZK.Rows[i]["DInvoiceSinglePrice"]); //dr["DtsOrderFormNo"] = SysConvert.ToString(dt3.Rows[j]["HTNO"]); dt.Rows.Add(dr); } } dt.Columns.Add("VOrderFormNo", typeof(string)); foreach (DataRow dr in dt.Rows) { dr["VOrderFormNo"] = GetVOrderFormNo(dr["DtsOrderFormNo"].ToString()); } DataView dv = dt.DefaultView; dv.Sort = "FormDate Asc"; DataTable dto = dv.ToTable(); gridView1.GridControl.DataSource = dto; gridView1.GridControl.Show(); BindLabel(); }
public void Test_Sort() { fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 2016, 05, 05, "2016/05/05 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 2016, 05, 04, "2016/05/04 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctJulian, 2016, 04, 21, "2016/05/04 [g] = 2016/04/21 [j]")); fDates.Add(new UDNRecord(UDNCalendarType.ctJulian, 2016, 04, 23, "2016/05/06 [g] = 2016/04/23 [j]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 2016, 05, UDN.UnknownDay, "2016/05/?? [g]")); // must be first fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 2016, 06, UDN.UnknownDay, "2016/06/?? [g]")); // must be last fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, UDN.UnknownYear, UDN.UnknownMonth, UDN.UnknownDay, "??/??/?? [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, UDN.UnknownYear, 04, 23, "??/04/23 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, UDN.UnknownYear, 03, 23, "??/03/23 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, UDN.UnknownYear, UDN.UnknownMonth, 23, "??/??/23 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 2016, UDN.UnknownMonth, UDN.UnknownDay, "2016/??/?? [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 2016, UDN.UnknownMonth, 10, "2016/??/10 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 2015, 03, 23, "2015/03/23 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 2014, UDN.UnknownMonth, 23, "2014/??/23 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 2016, 05, 31, "2016/05/31 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 2016, 05, 31, "2016/05/31 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, -4712, 1, 2, "-4712/01/02 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, -4712, 1, 3, "-4712/01/03 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctHebrew, 5564, 04, 04, "1804/06/13 [g] = 5564/04/04 [h]")); fDates.Add(new UDNRecord(UDNCalendarType.ctIslamic, 1216, 01, 04, "1801/05/17 [g] = 1216/01/04 [i]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 1802, 05, 01, "1802/05/01 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 0, 1, 3, "0000/01/03 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, -1, 1, 3, "-0001/01/03 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 1, 1, 3, "0001/01/03 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 2015, 2, 27, "2015/02/27 [g]")); fDates.Add(new UDNRecord(UDNCalendarType.ctGregorian, 3268, 1, 23, "3268/01/23 [g]")); // Add dates before. fDates.Add(new UDNRecord(UDN.CreateBefore( UDNCalendarType.ctGregorian, 1, 1, 4), UDNCalendarType.ctGregorian, "before 0001/01/04 [g]")); fDates.Add(new UDNRecord(UDN.CreateBefore( UDNCalendarType.ctGregorian, 2016, 05, 31), UDNCalendarType.ctGregorian, "before 2016/05/31 [g]")); fDates.Add(new UDNRecord(UDN.CreateBefore( UDNCalendarType.ctGregorian, -4712, 1, 2), UDNCalendarType.ctGregorian, "before -4712/01/02 [g]")); fDates.Add(new UDNRecord(UDN.CreateBefore( UDNCalendarType.ctGregorian, UDN.UnknownYear, 05, 31), UDNCalendarType.ctGregorian, "before ????/05/31 [g]")); fDates.Add(new UDNRecord(UDN.CreateBefore( UDNCalendarType.ctGregorian, 2015, UDN.UnknownMonth, 31), UDNCalendarType.ctGregorian, "before 2015/??/31 [g]")); // Add dates after. fDates.Add(new UDNRecord(UDN.CreateAfter( UDNCalendarType.ctGregorian, 2016, 05, 31), UDNCalendarType.ctGregorian, "after 2016/05/31 [g]")); fDates.Add(new UDNRecord(UDN.CreateAfter( UDNCalendarType.ctGregorian, UDN.UnknownYear, 05, 31), UDNCalendarType.ctGregorian, "after ????/05/31 [g]")); fDates.Add(new UDNRecord(UDN.CreateAfter( UDNCalendarType.ctGregorian, UDN.UnknownYear, 06, 15), UDNCalendarType.ctGregorian, "after ????/06/15 [g]")); fDates.Add(new UDNRecord(UDN.CreateAfter( UDNCalendarType.ctGregorian, 2015, UDN.UnknownMonth, 31), UDNCalendarType.ctGregorian, "after 2015/??/31 [g]")); fDates.Add(new UDNRecord(UDN.CreateAfter( UDNCalendarType.ctGregorian, 2015, UDN.UnknownMonth, 30), UDNCalendarType.ctGregorian, "after 2015/??/30 [g]")); // Add approximate dates. fDates.Add(new UDNRecord(UDN.CreateApproximate( UDNCalendarType.ctGregorian, 2016, 05, 31), UDNCalendarType.ctGregorian, "~ 2016/05/31 [g]")); fDates.Add(new UDNRecord(UDN.CreateApproximate( UDNCalendarType.ctGregorian, 1, 1, 4), UDNCalendarType.ctGregorian, "~ 0001/01/04 [g]")); fDates.Add(new UDNRecord(UDN.CreateApproximate( UDNCalendarType.ctGregorian, 1, 1, UDN.UnknownDay), UDNCalendarType.ctGregorian, "~ 0001/01/?? [g]")); fDates.Add(new UDNRecord(UDN.CreateApproximate( UDNCalendarType.ctGregorian, UDN.UnknownYear, 05, 31), UDNCalendarType.ctGregorian, "~ ????/05/31 [g]")); fDates.Add(new UDNRecord(UDN.CreateApproximate( UDNCalendarType.ctGregorian, 2015, UDN.UnknownMonth, 31), UDNCalendarType.ctGregorian, "~ 2015/??/31 [g]")); fDates.Add(new UDNRecord(UDN.CreateApproximate( UDNCalendarType.ctGregorian, 2015, 2, 28), UDNCalendarType.ctGregorian, "~ 2015/02/28 [g]")); // standart sort for .NET and Mono gives different result at items 31 and 32 SysUtils.QuickSort(fDates, delegate(UDNRecord left, UDNRecord right) { return(left.Value.CompareTo(right.Value)); }); //fDates.Sort(delegate(UDNRecord left, UDNRecord right) { return left.Value.CompareTo(right.Value); }); Assert.AreEqual("??/??/?? [g]", fDates[0].Description, "(00)"); Assert.AreEqual("??/??/23 [g]", fDates[1].Description, "(01)"); Assert.AreEqual("0000/01/03 [g]", fDates[2].Description, "(02)"); Assert.AreEqual("??/03/23 [g]", fDates[3].Description, "(03)"); Assert.AreEqual("??/04/23 [g]", fDates[4].Description, "(04)"); Assert.AreEqual("before ????/05/31 [g]", fDates[5].Description, "(05)"); Assert.AreEqual("~ ????/05/31 [g]", fDates[6].Description, "(06)"); Assert.AreEqual("after ????/05/31 [g]", fDates[7].Description, "(07)"); Assert.AreEqual("after ????/06/15 [g]", fDates[8].Description, "(08)"); Assert.AreEqual("before -4712/01/02 [g]", fDates[9].Description, "(09)"); Assert.AreEqual("-4712/01/02 [g]", fDates[10].Description, "(10)"); Assert.AreEqual("-4712/01/03 [g]", fDates[11].Description, "(11)"); Assert.AreEqual("-0001/01/03 [g]", fDates[12].Description, "(12)"); Assert.AreEqual("~ 0001/01/?? [g]", fDates[13].Description, "(13)"); Assert.AreEqual("0001/01/03 [g]", fDates[14].Description, "(14)"); Assert.AreEqual("before 0001/01/04 [g]", fDates[15].Description, "(15)"); Assert.AreEqual("~ 0001/01/04 [g]", fDates[16].Description, "(16)"); Assert.AreEqual("1801/05/17 [g] = 1216/01/04 [i]", fDates[17].Description, "(17)"); Assert.AreEqual("1802/05/01 [g]", fDates[18].Description, "(18)"); Assert.AreEqual("1804/06/13 [g] = 5564/04/04 [h]", fDates[19].Description, "(19)"); Assert.AreEqual("2014/??/23 [g]", fDates[20].Description, "(20)"); Assert.AreEqual("after 2015/??/30 [g]", fDates[21].Description, "(21)"); Assert.AreEqual("before 2015/??/31 [g]", fDates[22].Description, "(22)"); Assert.AreEqual("~ 2015/??/31 [g]", fDates[23].Description, "(23)"); Assert.AreEqual("after 2015/??/31 [g]", fDates[24].Description, "(24)"); Assert.AreEqual("2015/02/27 [g]", fDates[25].Description, "(25)"); Assert.AreEqual("~ 2015/02/28 [g]", fDates[26].Description, "(26)"); Assert.AreEqual("2015/03/23 [g]", fDates[27].Description, "(27)"); Assert.AreEqual("2016/??/?? [g]", fDates[28].Description, "(28)"); Assert.AreEqual("2016/??/10 [g]", fDates[29].Description, "(29)"); Assert.AreEqual("2016/05/?? [g]", fDates[30].Description, "(30)"); Assert.AreEqual("2016/05/04 [g]", fDates[31].Description, "(31)"); Assert.AreEqual("2016/05/04 [g] = 2016/04/21 [j]", fDates[32].Description, "(32)"); Assert.AreEqual("2016/05/05 [g]", fDates[33].Description, "(33)"); Assert.AreEqual("2016/05/06 [g] = 2016/04/23 [j]", fDates[34].Description, "(34)"); Assert.AreEqual("before 2016/05/31 [g]", fDates[35].Description, "(35)"); Assert.AreEqual("~ 2016/05/31 [g]", fDates[36].Description, "(36)"); Assert.AreEqual("2016/05/31 [g]", fDates[37].Description, "(37)"); Assert.AreEqual("2016/05/31 [g]", fDates[38].Description, "(38)"); Assert.AreEqual("after 2016/05/31 [g]", fDates[39].Description, "(39)"); Assert.AreEqual("2016/06/?? [g]", fDates[40].Description, "(40)"); Assert.AreEqual("3268/01/23 [g]", fDates[41].Description, "(41)"); UDNRecord rec; Assert.Throws(typeof(ArgumentOutOfRangeException), () => { rec = fDates[42]; }, "(42)"); // end }
private bool CheckCondition(FilterCondition fcond) { bool res = true; try { object dataval = GetColumnValueEx(fcond.ColumnIndex, -1, false); if (dataval == null) { return(true); } int compRes = 0; if (fcond.Condition != ConditionKind.ck_Contains) { compRes = ((IComparable)dataval).CompareTo(fcond.Value); } switch (fcond.Condition) { case ConditionKind.ck_NotEq: res = compRes != 0; break; case ConditionKind.ck_LT: res = compRes < 0; break; case ConditionKind.ck_LET: res = compRes <= 0; break; case ConditionKind.ck_Eq: res = compRes == 0; break; case ConditionKind.ck_GET: res = compRes >= 0; break; case ConditionKind.ck_GT: res = compRes > 0; break; case ConditionKind.ck_Contains: res = SysUtils.MatchesMask(dataval.ToString(), "*" + fcond.Value + "*"); break; case ConditionKind.ck_NotContains: res = !SysUtils.MatchesMask(dataval.ToString(), "*" + fcond.Value + "*"); break; } } catch (Exception ex) { Logger.LogWrite("ListManager.CheckCondition(): " + ex.Message); res = true; } return(res); }
/// <summary> /// 字符串转数字 /// </summary> /// <param name="str">需要转换的字符串</param> /// <param name="defValue">内容</param> /// <returns></returns> public static int ToInt(this string str, int defValue = 0) { return(SysUtils.StrToInt(str, defValue)); }