public WMSGoodsShelfRowAndCellToDb(GoodsShelfInfo wmsInfo) : base(s_metadata) { SetSqlInt32(0, wmsInfo.RowNumber); SetSqlInt32(1, wmsInfo.CellNumber); SetSqlString(2, wmsInfo.GoodsShelvesName); }
public WMSGoodsShelfToDb(GoodsShelfInfo wmsInfo) : base(s_metadata) { SetSqlInt64(0, wmsInfo.ID); SetSqlInt64(1, wmsInfo.ProjectID); SetSqlInt64(2, wmsInfo.CustomerID); SetSqlInt64(3, wmsInfo.WareHouseID); SetSqlString(4, wmsInfo.GoodsShelvesName); SetSqlString(5, wmsInfo.Levels); SetSqlString(6, wmsInfo.Grids); SetSqlString(7, wmsInfo.Weights); SetSqlString(8, wmsInfo.Lengths); SetSqlString(9, wmsInfo.Widths); SetSqlString(10, wmsInfo.Heights); SetSqlString(11, wmsInfo.Remark); SetSqlString(12, wmsInfo.Creator); SetSqlString(13, wmsInfo.Updator); SetSqlDateTime(14, wmsInfo.CreateTime ?? SqlTypes.SqlDateTime.Null); SetSqlDateTime(15, wmsInfo.UpdateTime ?? SqlTypes.SqlDateTime.Null); SetSqlString(16, wmsInfo.Str1 == "" ? null : wmsInfo.Str1); SetSqlString(17, wmsInfo.Str2 == "" ? null : wmsInfo.Str2); SetSqlString(18, wmsInfo.Str3 == "" ? null : wmsInfo.Str3); SetSqlString(19, wmsInfo.Str4 == "" ? null : wmsInfo.Str4); SetSqlString(20, wmsInfo.Str5 == "" ? null : wmsInfo.Str5); SetSqlInt32(21, wmsInfo.Int1); SetSqlInt32(22, wmsInfo.Int2); SetSqlInt32(23, wmsInfo.Int3); SetSqlInt32(24, wmsInfo.Int4); SetSqlInt32(25, wmsInfo.Int5); SetSqlDateTime(26, wmsInfo.DateTime1 ?? SqlTypes.SqlDateTime.Null); SetSqlDateTime(27, wmsInfo.DateTime2 ?? SqlTypes.SqlDateTime.Null); SetSqlDateTime(28, wmsInfo.DateTime3 ?? SqlTypes.SqlDateTime.Null); SetSqlDateTime(29, wmsInfo.DateTime4 ?? SqlTypes.SqlDateTime.Null); SetSqlDateTime(30, wmsInfo.DateTime5 ?? SqlTypes.SqlDateTime.Null); SetSqlString(31, wmsInfo.Location == "" ? null : wmsInfo.Location); SetSqlInt64(32, wmsInfo.LevelsNumber); SetSqlInt64(33, wmsInfo.SerialNumber); SetSqlString(34, wmsInfo.AreaName); }