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