private LeafLevel SetValue()
{
LeafLevel m_Base = new LeafLevel();
m_Base.Level = txtLEAF_LEVEL.Text;
m_Base.LeafLevelName = txtLeafLevelName.Text;//等级名称
m_Base.LeafLevelDesc = txtLeafLevelDesc.Text;//等级描述
m_Base.LeafLevelPrice = Convert.ToDouble(txtLeafLevelPrice.Text);//烟叶等级价格
m_Base.LeafLevelSort = Convert.ToInt32(txtLeafLevelSort.Text);//排序
return m_Base;
}
/// <summary>
/// 根据 Level 更新烟叶等级表记录
/// </summary>
/// <returns>返回烟叶等级受影响的行数</returns>
public virtual int Update(LeafLevel leaflevel)
{
return db.ExecuteNoQuery(@"UPDATE T_BASE_LEAF_LEVEL SET LEAF_LEVEL_NAME = @LEAF_LEVEL_NAME, LEAF_LEVEL_DESC = @LEAF_LEVEL_DESC,
LEAF_LEVEL_PRICE = @LEAF_LEVEL_PRICE, LEAF_LEVEL_SORT = @LEAF_LEVEL_SORT WHERE LEAF_LEVEL = @LEAF_LEVEL",
db.GetDataParameter("@LEAF_LEVEL", leaflevel.Level),
db.GetDataParameter("@LEAF_LEVEL_NAME", leaflevel.LeafLevelName),
db.GetDataParameter("@LEAF_LEVEL_DESC", leaflevel.LeafLevelDesc),
db.GetDataParameter("@LEAF_LEVEL_PRICE", leaflevel.LeafLevelPrice),
db.GetDataParameter("@LEAF_LEVEL_SORT", leaflevel.LeafLevelSort)
//db.GetDataParameter("@LEAF_LEVEL_IS_DELETED", leaflevel.LeafLevelIsDeleted),
//db.GetDataParameter("@LEAF_LEVEL_DELETED_DATE", leaflevel.LeafLevelDeletedDate)
);
}
/// <summary>
/// 新增一条烟叶等级记录
/// </summary>
/// <param name="leaflevel">System.String[]<param>
/// <returns>返回烟叶等级受影响的行数</returns>
public virtual int Add(LeafLevel leaflevel)
{
return db.ExecuteNoQuery(@"INSERT INTO T_BASE_LEAF_LEVEL (LEAF_LEVEL, LEAF_LEVEL_NAME, LEAF_LEVEL_DESC, LEAF_LEVEL_PRICE, LEAF_LEVEL_SORT,LEAF_LEVEL_IS_DELETED)
VALUES (@LEAF_LEVEL, @LEAF_LEVEL_NAME, @LEAF_LEVEL_DESC, @LEAF_LEVEL_PRICE, @LEAF_LEVEL_SORT, 'N')",
db.GetDataParameter("@LEAF_LEVEL", leaflevel.Level),
db.GetDataParameter("@LEAF_LEVEL_NAME", leaflevel.LeafLevelName),
db.GetDataParameter("@LEAF_LEVEL_DESC", leaflevel.LeafLevelDesc),
db.GetDataParameter("@LEAF_LEVEL_PRICE", leaflevel.LeafLevelPrice),
db.GetDataParameter("@LEAF_LEVEL_SORT", leaflevel.LeafLevelSort)
//db.GetDataParameter("@LEAF_LEVEL_IS_DELETED", leaflevel.LeafLevelIsDeleted),
//db.GetDataParameter("@LEAF_LEVEL_DELETED_DATE", leaflevel.LeafLevelDeletedDate)
);
}