/// <summary>
/// 更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Update(SeatManage.ClassModel.SysFuncDicInfo model)
{
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append("update SysFuncDic set MCaption=@MCaption,MenuLink=@MenuLink,OrderSeq=@OrderSeq");
sqlstr.Append(" where ModSeq=@ModSeq");
SqlParameter[] parameters =
{
new SqlParameter("@ModSeq", SqlDbType.NVarChar, 50),
new SqlParameter("@MCaption", SqlDbType.NVarChar, 60),
new SqlParameter("@MenuLink", SqlDbType.NVarChar, 255),
new SqlParameter("@OrderSeq", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.No;
parameters[1].Value = model.Name;
parameters[2].Value = model.PageUrl;
parameters[3].Value = model.Order;
try
{
int rows = DbHelperSQL.ExecuteSql(sqlstr.ToString(), parameters);
if (rows == 0)
{
return(false);
}
else
{
return(true);
}
}
catch
{
throw;
}
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Delete(SeatManage.ClassModel.SysFuncDicInfo model)
{
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append("delete SysFuncDic");
sqlstr.Append(" where ModSeq=@ModSeq");
SqlParameter[] parameters =
{
new SqlParameter("@ModSeq", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.No;
try
{
int rows = DbHelperSQL.ExecuteSql(sqlstr.ToString(), parameters);
if (rows == 0)
{
return(false);
}
else
{
return(true);
}
}
catch
{
throw;
}
}
