//插入一条数据到packageDetail表中，并且显示
private void ShowPackageDetailTable(PickException _temp)
{
// dgExceptionTable.Rows.Add();
var row = pickExceptionTable.NewRow();
row["发生时间"] = _temp.Time.ToString();
row["日期"] = _temp.PickDate;
row["线路名称"] = _temp.LineID.ToString();
row["客户编码"] = _temp.CustomerID;
row["客户名称"] = _temp.CustomerName;
row["包号"] = _temp.PackID.ToString();
row["商品名称"] = _temp.ProductName;
row["异常原因"] = _temp.Detail;
this.PerformSafely(() => pickExceptionTable.Rows.Add(row));
}
//分析一个包中条烟数量情况
private void ResultAnalysis(int _result, int _abnormalCount, int _allCount, PickPackageDetail _pd)
{
var pdresult = orderHandle.localDatabase.dataBase.PackageDetails.FirstOrDefault(c => c.PickPackageDetailID == _pd.PickPackageDetailID);
var _ps = orderHandle.localDatabase.dataBase.Packages.FirstOrDefault(c => c.PickPackageID == _pd.PickPackageID);
PickException exception = null;
string message = "";
if (_result == 0)
{
pdresult.Details = "正常";
pdresult.Readed = _pd.Readed;
pdresult.Result = (int)ReadResult.OK;
}
else if (_result > 0)
{
message = "缺少 " + _pd.Product.ProductName.Trim() + " , " + _pd.ProductID.Trim() + "," + _result.ToString() + "条";
pdresult.Details = "缺少 " + _result.ToString() + "条";
pdresult.Readed = _pd.Readed;
pdresult.Result = (int)ReadResult.LESS;
exception = new PickException();
exception.CustomerID = _ps.CustomerID;
exception.CustomerName = _ps.CustomerName;
exception.Detail = "少烟";
exception.PackID = _ps.PackID;
exception.PickDate = _ps.PickDate;
exception.ProductName = _pd.Product.ProductName;
exception.LineID = _ps.LineID;
exception.Time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff");
}
else
{
message = ("多 " + _pd.Product.ProductName.Trim() + " , " + _pd.ProductID.Trim() + "," + (-_result).ToString() + "条");
pdresult.Details = "多 " + (-_result).ToString() + "条";
pdresult.Readed = _pd.Readed;
pdresult.Result = (int)ReadResult.MORE;
exception = new PickException();
exception.CustomerID = _ps.CustomerID;
exception.CustomerName = _ps.CustomerName;
exception.Detail = "多烟";
exception.PackID = _ps.PackID;
exception.PickDate = _ps.PickDate;
exception.ProductName = _pd.Product.ProductName;
exception.LineID = _ps.LineID;
exception.Time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff");
}
try
{
orderHandle.localDatabase.dataBase.Entry(pdresult).State = System.Data.Entity.EntityState.Modified;
if (exception != null)
{
orderHandle.localDatabase.dataBase.PickExceptions.Add(exception);
}
orderHandle.localDatabase.dataBase.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine(ex.InnerException.Message);
}
this.PerformSafely(() => {
listBoxMessageShow.Items.Add(new CCWin.SkinControl.SkinListBoxItem {
Text = message
});
});
}