private static UPackageProduct IsExist(string caseCode, string snOutter)
{
var selectSQL = $"SELECT {DbTable.F_Out_Case_Product.BINDING_STATE} " +
$"FROM {DbTable.F_OUT_CASE_PRODUCT_NAME} WHERE " +
$"{DbTable.F_Out_Case_Product.OUT_CASE_CODE} = '{caseCode}' AND " +
$"{DbTable.F_Out_Case_Product.SN_OUTTER} = '{snOutter}'";
LogHelper.Log.Info(selectSQL);
var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0];
UPackageProduct uPackageProduct = new UPackageProduct();
if (dt.Rows.Count > 0)
{
uPackageProduct.IsRecordExist = true;
var value = dt.Rows[0][0].ToString();
if (value == "0")
{
uPackageProduct.IsProductBinding = false;
}
else if (value == "1")
{
uPackageProduct.IsProductBinding = true;
}
}
else
{
uPackageProduct.IsRecordExist = false;
}
return(uPackageProduct);
}
private static UPackageProduct OtherBindingRecordState(string productSN, string caseCode)
{
UPackageProduct uPackageProduct = new UPackageProduct();
var selectSQL = $"SELECT distinct " +
$"{DbTable.F_Out_Case_Product.OUT_CASE_CODE} " +
$"FROM " +
$"{DbTable.F_OUT_CASE_PRODUCT_NAME} " +
$"WHERE " +
$"{DbTable.F_Out_Case_Product.SN_OUTTER} = '{productSN}' " +
$"AND " +
$"{DbTable.F_Out_Case_Product.BINDING_STATE} = '1'";
var ds = SQLServer.ExecuteDataSet(selectSQL);
if (ds.Tables.Count < 1)
{
LogHelper.Log.Info("【更新产品打包】不存在其他绑定记录" + selectSQL);
uPackageProduct.IsExistOtherBindingRecord = false;
return(uPackageProduct);
}
LogHelper.Log.Info("【更新产品打包】可能存在其他绑定记录");
System.Data.DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
var otherCaseCode = dt.Rows[0][0].ToString();
if (caseCode != otherCaseCode)
{
//该产品已绑定其他箱子
LogHelper.Log.Info("【更新产品打包】存在其他绑定记录");
uPackageProduct.IsExistOtherBindingRecord = true;
uPackageProduct.bindedOtherOutcasecode = otherCaseCode;
return(uPackageProduct);
}
else
{
LogHelper.Log.Info("【更新产品打包】不存在其他绑定记录<<casecode=" + caseCode + "<<nowcase=" + dt.Rows[0][0].ToString());
uPackageProduct.IsExistOtherBindingRecord = false;
return(uPackageProduct);
}
}
//该产品未绑定其他箱子
uPackageProduct.IsExistOtherBindingRecord = false;
return(uPackageProduct);
}
