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