/// <summary>
/// 分切打印
/// </summary>
/// <param name="View"></param>
/// <param name="Context"></param>
/// <param name="指定标签模板"></param>
/// <param name="orgid"></param>
/// <param name="MacInfo"></param>
/// <param name="客户"></param>
/// <param name="物料名"></param>
/// <param name="条码或者生产订单号+行号的值"></param>
/// <param name="条码或者生产订单号+行号的类型"></param>
/// <param name=""></param>
public static DataSet getPrintModel(IBillView View, Context Context, string ZDPrintModel, string orgid, string MacInfo, string F_SZXY_CUSTID, ref int V)
{
DataSet RESDS = null;
string SelCust = $"/*dialect*/select T6.FNAME '客户名' from T_BD_CUSTOMER T5 left join T_BD_CUSTOMER_L t6 on t6.FCUSTID=T5.FCUSTID where t6.FCUSTID='{F_SZXY_CUSTID}'";
DataSet SelCustDS = DBServiceHelper.ExecuteDataSet(Context, SelCust);
if (SelCustDS != null && SelCustDS.Tables.Count > 0 && SelCustDS.Tables[0].Rows.Count > 0)
{
Logger.Debug($"客户:{Convert.ToString(SelCustDS.Tables[0].Rows[0][0])}", $"指定标签模板:{ZDPrintModel},MAC地址为{MacInfo}");
}
#region
string SQL12 = "/*dialect*/select T1.FID,T1.F_SZXY_REPORT,T1.F_SZXY_PRINTMAC,T1.F_SZXY_PRINTQTY,T1.F_SZXY_LPRINT,T1.F_SZXY_CONNSTRING,T1.F_SZXY_QUERYSQL," +
"T1.F_SZXY_ListSQL,T1.F_SZXY_CustID ,T1.F_SZXY_Model '产品型号', T3.FNAME, T1.F_SZXY_CHECKBOX 'CKB',T1.F_SZXY_Remark,T1.FNUMBER '标签' from SZXY_t_BillTemplatePrint T1" +
" left join T_BD_MATERIAL T2 on T2.FMATERIALID=T1.F_SZXY_Model " +
" left join T_BD_MATERIAL_L T3 on t2.FMATERIALID=T3.FMATERIALID where" +
" T1.F_SZXY_BILLIDENTIFI='" + View.BusinessInfo.GetForm().Id + "' and T1.FUSEORGID='" + orgid + "'" +
" and T1.F_SZXY_TYPESELECT='1' and T1.FDOCUMENTSTATUS='C' " + ZDPrintModel + " ";
DataSet DS = null;
string WhereSql = "";
if (F_SZXY_CUSTID.IsNullOrEmptyOrWhiteSpace() || F_SZXY_CUSTID == "")
{
F_SZXY_CUSTID = "0";
}
//如果不为空 客户
WhereSql = $" {SQL12} and T1.F_SZXY_CustID={F_SZXY_CUSTID} and F_SZXY_Remark='{MacInfo}'";
DS = DBServiceHelper.ExecuteDataSet(Context, WhereSql);
if (DS != null && DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
foreach (DataRow DR in DS.Tables[0].Rows)
{
V = 0;
if (!Convert.ToString(DR["CKB"]).IsNullOrEmptyOrWhiteSpace())
{
V = Convert.ToInt32(DR["CKB"]);
}
RESDS = DS;
}
}
else
{
WhereSql = $" {SQL12} and T1.F_SZXY_CustID=0 and F_SZXY_Remark='{MacInfo}' ";
DS = DBServiceHelper.ExecuteDataSet(Context, WhereSql);
if (DS != null && DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
foreach (DataRow DR in DS.Tables[0].Rows)
{
V = 0;
if (!Convert.ToString(DR["CKB"]).IsNullOrEmptyOrWhiteSpace())
{
V = Convert.ToInt32(DR["CKB"]);
}
RESDS = DS;
}
}
else
{
WhereSql = $" {SQL12} and T1.F_SZXY_CustID={F_SZXY_CUSTID} and F_SZXY_Remark='' ";
DS = DBServiceHelper.ExecuteDataSet(Context, WhereSql);
if (DS != null && DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
foreach (DataRow DR in DS.Tables[0].Rows)
{
V = 0;
if (!Convert.ToString(DR["CKB"]).IsNullOrEmptyOrWhiteSpace())
{
V = Convert.ToInt32(DR["CKB"]);
}
RESDS = DS;
}
}
else
{
WhereSql = $" {SQL12} and T1.F_SZXY_CustID=0 and F_SZXY_Remark='' ";
DS = DBServiceHelper.ExecuteDataSet(Context, WhereSql);
if (DS != null && DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
foreach (DataRow DR in DS.Tables[0].Rows)
{
V = 0;
if (!Convert.ToString(DR["CKB"]).IsNullOrEmptyOrWhiteSpace())
{
V = Convert.ToInt32(DR["CKB"]);
}
RESDS = DS;
}
}
else
{
View.ShowWarnningMessage("没有匹配到模板！");
}
}
}
}
Logger.Debug("匹配单据套打模板编码Sql", WhereSql);
if (RESDS != null && RESDS.Tables.Count > 0 && RESDS.Tables[0].Rows.Count > 0)
{
string BQ = Convert.ToString(RESDS.Tables[0].Rows[0]["标签"]);
Logger.Debug("匹配单据套打模板编码", BQ);
}
return(RESDS);
#endregion
}
