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); }
private StockModel DrToStocktakingBill(DataRow dr) { StockModel sb = new StockModel(); sb.StocktakingID = Convert.ToInt64(dr["StackingBillID"]); sb.CmstID = Convert.ToInt32(dr["CmstID"]); sb.DepotID = DataValidate.GetValueOrNullInt(dr["DepotID"]); sb.DepotName = dr["DepotName"]?.ToString(); sb.ReservoirID = DataValidate.GetValueOrNullInt(dr["ReservoirID"]); sb.ReservoirName = dr["ReservoirName"]?.ToString(); sb.CompanyID = DataValidate.GetValueOrNullInt(dr["CompanyID"]); sb.CompanyName = dr["CompanyName"]?.ToString(); sb.Maker = Convert.ToInt32(dr["Maker"]); sb.MakerName = dr["MakerName"].ToString(); sb.MakeTime = Convert.ToDateTime(dr["MakeTime"]); sb.Status = Convert.ToInt32(dr["Status"]); sb.StatusName = dr["StatusName"].ToString(); return(sb); }