public bool Edit(CategoryItems entity)
{
string sql = entity.GetUpdateSql();
SqlCmdHelper helper = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
return(helper.GenerateNoQuerySqlAndExcute(sql, entity) > 0);
}
public bool ChangeSpell(int id, string spell)
{
CategoryItems item = new CategoryItems()
{
Id = id, IndexSpell = spell
};
string sql = item.GetChangeSpellWord();
SqlCmdHelper helper = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
return(helper.GenerateNoQuerySqlAndExcute(sql, item) > 0);
}
public bool ChangeParentMenu(int id, int parentId)
{
Menu m = new Menu()
{
Id = id, ParentId = parentId
};
string sql = m.ChangeParentMenuSql();
SqlCmdHelper cmd = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
return(cmd.GenerateNoQuerySqlAndExcute(sql, m) > 0);
}
/// <summary>
/// 设置是否启用菜单
/// </summary>
/// <param name="id"></param>
/// <param name="operate"></param>
/// <returns></returns>
public bool ChangeMenuStatue(int id, bool operate)
{
Menu menu = new Menu()
{
Id = id,
IsEnable = operate
};
string sql = menu.ChangeStatueSql();
SqlCmdHelper cmd = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
return(cmd.GenerateNoQuerySqlAndExcute(sql, menu) > 0);
}
/// <summary>
/// 设置更改菜单类型
/// </summary>
/// <param name="id"></param>
/// <param name="type"></param>
/// <returns></returns>
public bool ChangeMenuType(int id, int type)
{
Menu menu = new Menu()
{
Id = id,
MenuType = (short)type
};
string sql = menu.ChangeMenuTypeSql();
SqlCmdHelper cmd = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
return(cmd.GenerateNoQuerySqlAndExcute(sql, menu) > 0);
}
public bool SaveSignInInfo(UserAccount user)
{//保存数据
if (string.IsNullOrEmpty(user.Encry))
{
user.Encry = "-1";
}
user.Id = Guid.NewGuid();
user.CreateTime = DateTime.Now;
SqlCmdHelper help = new SqlCmdHelper()
{
SqlConnString = SqlConnString
};
string sql = SqlCmdHelper.GenerateInsertSql <UserAccount>();
return(help.GenerateNoQuerySqlAndExcute(sql, user) > 0);
}