public override IModel CreateModel(SqlDataReader dr) { CustomsClearanceApply customsclearanceapply = new CustomsClearanceApply(); int indexCustomsApplyId = dr.GetOrdinal("CustomsApplyId"); customsclearanceapply.CustomsApplyId = Convert.ToInt32(dr[indexCustomsApplyId]); int indexApplyId = dr.GetOrdinal("ApplyId"); if (dr["ApplyId"] != DBNull.Value) { customsclearanceapply.ApplyId = Convert.ToInt32(dr[indexApplyId]); } int indexAssetId = dr.GetOrdinal("AssetId"); if (dr["AssetId"] != DBNull.Value) { customsclearanceapply.AssetId = Convert.ToInt32(dr[indexAssetId]); } int indexGrossWeight = dr.GetOrdinal("GrossWeight"); if (dr["GrossWeight"] != DBNull.Value) { customsclearanceapply.GrossWeight = Convert.ToDecimal(dr[indexGrossWeight]); } int indexNetWeight = dr.GetOrdinal("NetWeight"); if (dr["NetWeight"] != DBNull.Value) { customsclearanceapply.NetWeight = Convert.ToDecimal(dr[indexNetWeight]); } int indexUnitId = dr.GetOrdinal("UnitId"); if (dr["UnitId"] != DBNull.Value) { customsclearanceapply.UnitId = Convert.ToInt32(dr[indexUnitId]); } int indexOutCorpId = dr.GetOrdinal("OutCorpId"); if (dr["OutCorpId"] != DBNull.Value) { customsclearanceapply.OutCorpId = Convert.ToInt32(dr[indexOutCorpId]); } int indexInCorpId = dr.GetOrdinal("InCorpId"); if (dr["InCorpId"] != DBNull.Value) { customsclearanceapply.InCorpId = Convert.ToInt32(dr[indexInCorpId]); } int indexCustomsCorpId = dr.GetOrdinal("CustomsCorpId"); if (dr["CustomsCorpId"] != DBNull.Value) { customsclearanceapply.CustomsCorpId = Convert.ToInt32(dr[indexCustomsCorpId]); } int indexCustomsPrice = dr.GetOrdinal("CustomsPrice"); if (dr["CustomsPrice"] != DBNull.Value) { customsclearanceapply.CustomsPrice = Convert.ToDecimal(dr[indexCustomsPrice]); } int indexCurrencyId = dr.GetOrdinal("CurrencyId"); if (dr["CurrencyId"] != DBNull.Value) { customsclearanceapply.CurrencyId = Convert.ToInt32(dr[indexCurrencyId]); } int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr["CreatorId"] != DBNull.Value) { customsclearanceapply.CreatorId = Convert.ToInt32(dr[indexCreatorId]); } int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr["CreateTime"] != DBNull.Value) { customsclearanceapply.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); } int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { customsclearanceapply.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { customsclearanceapply.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } return customsclearanceapply; }
public ResultModel GetModelByApplyId(UserModel user, int applyId) { ResultModel result = new ResultModel(); SqlDataReader dr = null; try { string sql = string.Format("select * from dbo.St_CustomsClearanceApply where ApplyId = {0}", applyId); dr = SqlHelper.ExecuteReader(ConnectString, CommandType.Text, sql, null); Model.CustomsClearanceApply model = new CustomsClearanceApply(); if (dr.Read()) { model = CreateModel(dr) as CustomsClearanceApply; result.AffectCount = 1; result.Message = "读取成功"; result.ResultStatus = 0; result.ReturnValue = model; } else { result.Message = "读取失败或无数据"; result.AffectCount = 0; } } catch (Exception ex) { result.ResultStatus = -1; result.Message = ex.Message; } finally { if (dr != null) dr.Dispose(); } return result; }
public override IModel CreateModel(DataRow dr) { CustomsClearanceApply customsclearanceapply = new CustomsClearanceApply(); customsclearanceapply.CustomsApplyId = Convert.ToInt32(dr["CustomsApplyId"]); if (dr["ApplyId"] != DBNull.Value) { customsclearanceapply.ApplyId = Convert.ToInt32(dr["ApplyId"]); } if (dr["AssetId"] != DBNull.Value) { customsclearanceapply.AssetId = Convert.ToInt32(dr["AssetId"]); } if (dr["GrossWeight"] != DBNull.Value) { customsclearanceapply.GrossWeight = Convert.ToDecimal(dr["GrossWeight"]); } if (dr["NetWeight"] != DBNull.Value) { customsclearanceapply.NetWeight = Convert.ToDecimal(dr["NetWeight"]); } if (dr["UnitId"] != DBNull.Value) { customsclearanceapply.UnitId = Convert.ToInt32(dr["UnitId"]); } if (dr["OutCorpId"] != DBNull.Value) { customsclearanceapply.OutCorpId = Convert.ToInt32(dr["OutCorpId"]); } if (dr["InCorpId"] != DBNull.Value) { customsclearanceapply.InCorpId = Convert.ToInt32(dr["InCorpId"]); } if (dr["CustomsCorpId"] != DBNull.Value) { customsclearanceapply.CustomsCorpId = Convert.ToInt32(dr["CustomsCorpId"]); } if (dr["CustomsPrice"] != DBNull.Value) { customsclearanceapply.CustomsPrice = Convert.ToDecimal(dr["CustomsPrice"]); } if (dr["CurrencyId"] != DBNull.Value) { customsclearanceapply.CurrencyId = Convert.ToInt32(dr["CurrencyId"]); } if (dr["CreatorId"] != DBNull.Value) { customsclearanceapply.CreatorId = Convert.ToInt32(dr["CreatorId"]); } if (dr["CreateTime"] != DBNull.Value) { customsclearanceapply.CreateTime = Convert.ToDateTime(dr["CreateTime"]); } if (dr["LastModifyId"] != DBNull.Value) { customsclearanceapply.LastModifyId = Convert.ToInt32(dr["LastModifyId"]); } if (dr["LastModifyTime"] != DBNull.Value) { customsclearanceapply.LastModifyTime = Convert.ToDateTime(dr["LastModifyTime"]); } return customsclearanceapply; }