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