/// <summary> /// 更新一条数据 /// </summary> public bool Update(FwjSoft.Model.MenuInfoModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MenuInfo set "); strSql.Append("MenuName=@MenuName,"); strSql.Append("MenuSpaceName=@MenuSpaceName,"); strSql.Append("MenuFrmName=@MenuFrmName,"); strSql.Append("MenuParentId=@MenuParentId,"); strSql.Append("MenuUse=@MenuUse,"); strSql.Append("MenuSort=@MenuSort,"); strSql.Append("MenuBig=@MenuBig,"); strSql.Append("MenuBigImage=@MenuBigImage"); strSql.Append(" where MenuId=@MenuId"); SqlParameter[] parameters = { new SqlParameter("@MenuName", SqlDbType.VarChar, 50), new SqlParameter("@MenuSpaceName", SqlDbType.VarChar, 50), new SqlParameter("@MenuFrmName", SqlDbType.VarChar, 50), new SqlParameter("@MenuParentId", SqlDbType.Int, 4), new SqlParameter("@MenuUse", SqlDbType.Bit, 1), new SqlParameter("@MenuSort", SqlDbType.Int, 4), new SqlParameter("@MenuBig", SqlDbType.Bit, 1), new SqlParameter("@MenuBigImage", SqlDbType.Image), new SqlParameter("@MenuId", SqlDbType.Int, 4) }; parameters[0].Value = model.MenuName; parameters[1].Value = model.MenuSpaceName; parameters[2].Value = model.MenuFrmName; parameters[3].Value = model.MenuParentId; parameters[4].Value = model.MenuUse; parameters[5].Value = model.MenuSort; parameters[6].Value = model.MenuBig; parameters[7].Value = model.MenuBigImage; parameters[8].Value = model.MenuId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(FwjSoft.Model.MenuInfoModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MenuInfo("); strSql.Append("MenuName,MenuSpaceName,MenuFrmName,MenuParentId,MenuUse,MenuSort,MenuBig,MenuBigImage)"); strSql.Append(" values ("); strSql.Append("@MenuName,@MenuSpaceName,@MenuFrmName,@MenuParentId,@MenuUse,@MenuSort,@MenuBig,@MenuBigImage)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MenuName", SqlDbType.VarChar, 50), new SqlParameter("@MenuSpaceName", SqlDbType.VarChar, 50), new SqlParameter("@MenuFrmName", SqlDbType.VarChar, 50), new SqlParameter("@MenuParentId", SqlDbType.Int, 4), new SqlParameter("@MenuUse", SqlDbType.Bit, 1), new SqlParameter("@MenuSort", SqlDbType.Int, 4), new SqlParameter("@MenuBig", SqlDbType.Bit, 1), new SqlParameter("@MenuBigImage", SqlDbType.Image) }; parameters[0].Value = model.MenuName; parameters[1].Value = model.MenuSpaceName; parameters[2].Value = model.MenuFrmName; parameters[3].Value = model.MenuParentId; parameters[4].Value = model.MenuUse; parameters[5].Value = model.MenuSort; parameters[6].Value = model.MenuBig; parameters[7].Value = model.MenuBigImage; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FwjSoft.Model.MenuInfoModel GetModel(int MenuId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 MenuId,MenuName,MenuSpaceName,MenuFrmName,MenuParentId,MenuUse,MenuSort,MenuBig,MenuBigImage from MenuInfo "); strSql.Append(" where MenuId=@MenuId"); SqlParameter[] parameters = { new SqlParameter("@MenuId", SqlDbType.Int, 4) }; parameters[0].Value = MenuId; FwjSoft.Model.MenuInfoModel model = new FwjSoft.Model.MenuInfoModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }