public int AddShelf([FromForm] tb_Shelf model) { int count = _structure.GetShelfCount("tb_Shelf"); count = count + 1; string shelfNo = "HJ" + count.ToString().PadLeft(3, '0'); model.ShelfNo = shelfNo; return(_structure.AddShelf(model)); }
/// <summary> /// 添加货架 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddShelf(tb_Shelf model) { string procName = "proc_AddShelf"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter { ParameterName = "@shelfName", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.ShelfName }, new SqlParameter { ParameterName = "@AreaId", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.AreaId }, new SqlParameter { ParameterName = "@ShelfNo", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.ShelfNo }, new SqlParameter { ParameterName = "@StorageId", DbType = DbType.String, Direction = ParameterDirection.Input, Value = model.StorageId }, }; int code = _helper.ExecuteNonQueryProc(procName, sqlParameters); return(code); }