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