/// <summary> /// 更新一条数据 /// </summary> public bool Update(zs.Model.Sys_Group model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_Group set "); strSql.Append("Type=@Type,"); strSql.Append("GroupName=@GroupName,"); strSql.Append("PID=@PID,"); strSql.Append("IDPath=@IDPath,"); strSql.Append("NamePath=@NamePath"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Type", SqlDbType.VarChar, 10), new SqlParameter("@GroupName", SqlDbType.VarChar, 20), new SqlParameter("@PID", SqlDbType.Int, 4), new SqlParameter("@IDPath", SqlDbType.VarChar, 150), new SqlParameter("@NamePath", SqlDbType.VarChar, 250), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.Type; parameters[1].Value = model.GroupName; parameters[2].Value = model.PID; parameters[3].Value = model.IDPath; parameters[4].Value = model.NamePath; parameters[5].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }