public FeedbackInfomation QueryStocktakingBillDetial(long stocktakingDetailId)
{
FeedbackInfomation fi = new FeedbackInfomation();
try
{
StocktakingBillDetail sbd = MySMDAL.SelectStocktakingBillDetail(stocktakingDetailId);
if (sbd != null)
{
fi.Result = sbd;
fi.FeedbackMessage = "";
fi.ErrorStatus = STATUS_ADAPTER.QUERY_NORMAL;
}
else
{
fi.Result = null;
fi.FeedbackMessage = Tips.QERUY_RESULT_EMPTY;
fi.ErrorStatus = STATUS_ADAPTER.QUERY_NODATA;
}
return(fi);
}
catch (Exception ex)
{
fi.Result = null;
fi.FeedbackMessage = Tips.QUERY_FAILED + ":" + ex.Message.ToString();
fi.ErrorStatus = STATUS_ADAPTER.QUERY_ERROR;
return(fi);
}
}
public FeedbackInfomation CheckStocktakingDetail(long stocktakingId, long stocktakingDetailId, int result, int checker, string remark)
{
FeedbackInfomation fi = new FeedbackInfomation();
try
{
using (SqlConnection conn = SqlDataHelper.GetConnection())
{
conn.Open();
SqlTransaction st = conn.BeginTransaction();
CheckDetail(stocktakingId, stocktakingDetailId, result, checker, remark, st);
StocktakingBillDetail sbd = MySMDAL.SelectStocktakingBillDetail(stocktakingDetailId, st);
st.Commit();
fi.Result = sbd;
fi.FeedbackMessage = Tips.CHECK_SUCCESS;
fi.ErrorStatus = STATUS_ADAPTER.CHECK_SUCCESS;
return(fi);
}
}
catch (Exception ex)
{
fi.Result = null;
fi.ErrorStatus = STATUS_ADAPTER.CHECK_FAILED;
fi.FeedbackMessage = Tips.CHECK_SUCCESS + ":" + ex.Message.ToString();
return(fi);
}
}
private StocktakingBillDetail DrToStocktakingBillDetail(DataRow dr)
{
StocktakingBillDetail sbd = new StocktakingBillDetail();
sbd.StocktakingDetailID = Convert.ToInt64(dr["StocktakingDetailID"]);
sbd.StocktakingID = Convert.ToInt64(dr["StocktakingID"]);
sbd.CompanyID = Convert.ToInt32(dr["CompanyID"]);
sbd.CompanyName = dr["CompanyName"].ToString();
sbd.DepotName = dr["DepotName"].ToString();
sbd.ReservoirName = dr["ReservoirName"].ToString();
sbd.GalID = Convert.ToInt32(dr["GalID"]);
sbd.GalName = dr["GalName"]?.ToString();
sbd.GalDescript = dr["GalDescript"]?.ToString();
sbd.SkuID = Convert.ToInt32(dr["SkuID"]);
sbd.ProductName = dr["ProductName"]?.ToString();
sbd.GoodsName = dr["GoodsName"]?.ToString();
sbd.Spec = dr["Spec"]?.ToString();
sbd.Grade = dr["Grade"]?.ToString();
sbd.Manufacturer = dr["Manufacturer"]?.ToString();
sbd.Packaging = dr["Packaging"]?.ToString();
sbd.SignType = dr["SignType"]?.ToString();
sbd.SignNum = dr["SignNum"]?.ToString();
sbd.Spare = dr["Spare"]?.ToString();
sbd.PN = Convert.ToInt32(dr["PN"]);
sbd.AN = Convert.ToDecimal(dr["AN"]);
sbd.Status = Convert.ToInt32(dr["Status"]);
sbd.StatusName = dr["StatusName"].ToString();
sbd.ResultStatus = DataValidate.GetValueOrNullInt(dr["ResultStatus"]);
sbd.ResultStatusName = dr["ResultStatusName"]?.ToString();
sbd.Checker = DataValidate.GetValueOrNullInt(dr["Checker"]);
sbd.CheckName = dr["CheckName"]?.ToString();
sbd.CheckTime = DataValidate.GetValueOrNullDateTime(dr["CheckTime"]);
sbd.Remark = dr["Remark"]?.ToString();
return(sbd);
}
